I am trying to pass a level of a hierarchy to a report via report parameter and in the MDX query I want to take the hierarchy level that I pass to the report and populate the report with the next level of the hierarchy.
So I used
Drilldownlevel(StrtoSet(@division))
and it is not converting to the next level, it is populating the dataset with the same level that was passed into the report. It works when there isn't a parameter. Any ideas that can solve this?
Kevin