Improving the performance of a cube report

[BubuReloaded]

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,

[AJAYC]

Hi BubuReloaded,

Is this a TM1 cube or something else ?

Cheers
Ajay

[BubuReloaded]

Hi AJAYC,

It's a TM1 Cube,

Thank you,

[AJAYC]

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