SSAS \ SSRS Parameters

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  September 24, 2018 at 1:14 pm

  #150822

  Good afternoon all;

    I am very new to SSAS and have a question about parameters for the report. So here's the skinny;

  I am creating a dashboard for our stores in SSRS using a SSAS cube, I have put in all my calculations, KPI's, and even was able to setup a default date parameter that default to yesterdays date in the SSRS dashboard however I need our store managers to be able to launch the report\dashboard and only see their stores information. I have created a DIM table with report users and put in a hierarchy, userid-->username-->storename-->storied if this information helps. I also have their email address connected to the storeid's but not in the hierarchy. Any ideas on how I an get this working?

  I have been scouring google for a week and I do not want them to see a drop down just default to their stores information.

  thanks in advance!

  MCSE SQL Server 2012\2014\2016