Post reply

Using User!UserID in SSRS to access data in SSAS Cube

  • October 11, 2018 at 11:30 am

    #379145

    I am running SQL 2012 and I have a SSAS multidimensional cube that holds measures for our retail business. I have created an SSRS report that pulls the data from the SSAS cube. I want the user to be able to run the report and only pass the users specific store revenue, customer count, ect, on the SSRS report that they are viewing. I have created a parameter from the cube. Under the report parameter that was created from the cube I put in under default values, specific values, this expression for the value ="[DimUserTable].[Username].[UserID].&[" + User!UserID + "]", the report will not run. It gives the error;

    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    Query execution failed for dataset 'Revenue'. (rsErrorExecutingCommand)

    Does anyone have any idea how I can accomplish getting only the users store information to show on the report they are viewing?

    MCSE SQL Server 2012\2014\2016

  • October 11, 2018 at 12:36 pm

    #2009220

    RESOLUTION - In the default values, specific values, the expression for the value you have to put in is ="["+User!UserID+"]" in order to get it to work

    MCSE SQL Server 2012\2014\2016

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply