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

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  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

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  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