Hi,
Need your help... we are on HFR 11.1.2.4.003 using essbase connection to a BSO cube of a planning application.
All our reports take less than 1 minute to execute. - so everything is fine...
and our outline ordering is based on optimizing calculations i.e. account, period then smallest sparse and in the end largest sparse....
Couple of our reports that have below configuration are taking more than 3 minutes to run and fetch data - 51 pages in PDF format
1) Level 0 descendants of top parent of 2 business dimensions (SPARSE) and and account dimension (DENSE)
2) supress rows with missing / zero = ON
3) settings in data query optimization -> supress rows on database connection server and the essbase sparse command is INCLUDED
Is there anything else that we can do to reduce some time on the execution on this to say approx 1 minute (apart from changing the outline)?? Thanks.