Retrieving only Totals in the report based upon property values of a dimension
I am working on building a report in SAP BPC NW 10 and would request your help for the same.
The structure of my report is such that I have 2 dimensions PROD and CC in my rows and TIME dimension in my column axis. Column axis is getting dynamically populated (using EPMDimensionOverride) with base members of the current year; PROD through base of the top most parent (ALL_PROD); and CC is getting populated dynamically (again using EPMDimensionOverride) based on the value of a property (‘YES’ for property ‘INCLUDED’).
Number of CC members which have ‘YES’ as property value for property ‘INCLUDED’ is around 1000 and thus to prevent the tuple size from exceeding maximum limit of 150000, I have checked the option ‘Remove Empty and Zero Values’.
In this report, what the client is interested in is getting the sum of values of all the CCs by PROD, which I have achieved through putting in a local member formula for sum after CC dimension on the report (CC being my innermost dimension)
The issue is that, due the large data set being retrieved, the report is taking huge amount of time to refresh (around 15 mins).
Is there a way to build this report, by which I can reduce the refresh time? As client is only interested in total of these CCs by PROD, is there a way by which I can just retrieve the sums and thus reduce the size of data set being retrieved?
Would really appreciate your inputs on the above issue.
Thanks in Advance.