Hi Cognos Guru's,
Cognos 10.1.1, Relational data (DMR), Analysis Studio, Database Oracle 11g.
Here is the issue we are facing with Analysis studio.
When we nested more than 2 rows in the crosstab with the zero suppression it is kind of taking so long time to bring back the data.
With out zero suppression the report takes about 25 second.
With zero suppression the report takes about 15 min.
Is there anything we can do to make the crosstab run faster in Analysis studio? If so please share some idea with us.