Skip to Content
avatar image
Former Member

Retrieving only Totals in the report based upon property values of a dimension

Hi Experts,

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Apr 04, 2016 at 04:41 PM

    Property can't be used for aggregation. Use hierarchy (existing or new) to get a total value.

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2016 at 05:18 AM

    Try with this once,..

    Use =SUBTOTAL("") in formula bar of local member.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 06, 2016 at 07:33 AM

    Hi Rupali,

    As Vadim suggested you can build a H2 Hierarchy based on the client requirement to show the Totals of CC & also you can increase the performance of the report.

    Regards,

    Aravind

    Add comment
    10|10000 characters needed characters exceeded