I have a problem I'm trying to solve. I have an analysis services cube which is being deployed to users via an html publication of an excel pivot table.
The users have requested to limit access to data in the report based on information passed to the report at run time.
That is if a user has access only to data for say 1 region they want to pass a parameter to the report to say which region the user has access to and have the report only show data related to that region.
All regions are included in the report by default.
Is there any way to pass a parameter to an excel pivot table report to restrict which data is visible at the time the report is run?
The users have requested to limit access to data in the report based on information passed to the report at run time.
That is if a user has access only to data for say 1 region they want to pass a parameter to the report to say which region the user has access to and have the report only show data related to that region.
All regions are included in the report by default.
Is there any way to pass a parameter to an excel pivot table report to restrict which data is visible at the time the report is run?