Skip to Content
avatar image
Former Member

For creating EPM report

For creating the EPM report: I have 2 dimensions in row axis:

Dim 1 : Product A, B and C

Dim 2: Account. 100 101 102 103 104

I need to change the olapmembero display and unique values so that the report row axis should display like below:

A 101

A 102

B 103

C 103

C 104

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 21, 2017 at 09:13 AM

    What is the relation between Product and Account dimension? Looks like many-to-many!

    Please read my blog:

    https://blogs.sap.com/2017/03/04/report-or-input-form-with-many-to-many-relationship-between-2-dimensions/

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 21, 2017 at 08:05 AM

    Hi, You have to list your dimension member combinations on the side and refer to them in the olap member formulas as per below.

    Regards,

    Cecilia

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I have more than 100 rows in row axis, changing manually in OLAP member formula will take lots of time. Do we have any other simple idea?