Hi experts,
I'm getting report using report studio 10.2, implement the concept drill down using regular dimensional package in cross table. I design the report row as name and group name field, column as budget and actual, it is measure value too. when I run the report got exact correct result immediately then I add one more row work in report, It won't give the result instead of display loading screen too long time "YOUR REPORT IS RUNNING PLEASE WAIT". so I tried only that work and measure value in the new project and run the report same problem happened again. But got exact results using name and group name only in report. Everything is in same dimension package. Why it is happen? How to overcome it?
Please guys let me to solve this issue.
Note:
name belongs to the level person_name in person hierarchy,
group belongs to the level group_name in group hierarchy,
work belongs to the level work in work_effort hierarchy,
budget and actual are individual measures in measure folder.
Thank you