Hi all,
I have a multidimensional report with multiple charts (10 in total). I want to display the zero or null values in the report but when I don't apply the zero or null values suppression, my reports runs for close to 15 mins and when I do the report runs a lot faster. I tried to reduce the number of queries in the report, meaning some of the charts share the same query.
Please share if anyone has any idea of how I can make the report to run faster without suppressing zero or null values of the charts,
Thank you in advance,
Hi BubuReloaded,
Is this a TM1 cube or something else ?
Cheers
Ajay
Hi AJAYC,
It's a TM1 Cube,
Thank you,
Hi BubuReloaded
OK, so first question.....have you got filters on any of the queries ? If so you want to be looking at making them slicers instead.
TM1 cubes work better off of slicers than filters.
Second question, do you have any unnecessary calculations in the report ? for example, adding two numbers together to get a third ? in this case you'd want a more efficient way from the cube, which is simply a consolidation of two members.
I'd look at this first before delving deeper
HTH
Ajay