Hi ,
I create a report with two prompts level 5 and level 4 from one dimension and show these levels also in my rows nested and I have a corresponding measure and ytd as column.
Now when I run this report in report studio, I drill down on my level 4 for a specific value and now change the prompt values the report refreshes according to the new prompt values ignoring the drilled down state.
But the same report when moved to workspace, after drill down and changing prompt values shows me some random data .I am not sure why is this behaving this way in workspace.
Any help on this is appreciated.
Thanks,
Nithya