I'm using a cube. In my report, one of my columns contains parent(parent([Selected Fiscal Month])). Our time dimension is
Year, Quarter, Month. So when I run the report I see the year. This is what I need.
How do I code to disable the drill down on Year only? I have a calculated measure as sub columns. When I drill down the totals are incorrect. I still want to be able to drill down in my other columns.
Thank you in advance.
Hello kgcognos,
In report studio, from the menu bar got to Data > Drill behavior. You can disable drill up/down/both for any data item you want.
Thanks,
Cognos810