Skip to Content
avatar image
Former Member

Repeat Time dimension in row & Colum axis in BPC 10.0

Hello,

I am using the BPC 10.0 version and need to resolve a conflict. I have the dimension "TIME" in the ROW axis. However, I want to add the "TIME" dimension to the COLUMN axis as well. How do I do that? Please help.

Example:

------------COLUMN1---COLUMN 2----COLUMN3----COLUMN4

(ROW 1) 2016.Q1 NET SALES 100,000 ?????(<<--2015 or say Prior Year)

sap-doubt.png

sap-doubt.png (7.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 30, 2016 at 03:51 PM

    There is no equivalent of CELLKEYRANGE in EPM.

    In general EPM functions are absolutely different compared to EVDRE functions. There is no magic conversion of EVDRE reports to EPM (only very simple reports can be converted). In 99% of cases you have to create EPM from zero. And you need a good EPM training to create complex EPM reports.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2016 at 09:27 PM

    It's impossible to have one dimension both in row and column axis of the same report!

    You can try to solve your issue with multiple reports, but I do not understand the strange idea...

    Do you have different time members in rows? Can you show a bigger test report...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2016 at 03:17 PM

    In my org they use y-o-y and month-on-month comparison and hence this format. Currently they are using BPC 7.5 and I see that in these reports that they have created another report in a similar format outside the main report. Just wanted to know if there is a better way in BPC 10.0 to do it without creating another report by using EPMAXISOVERRIDE or EPMDIMENSIONOVERRIDE.

    I have attached the formats done in EVDRE to get a clearer picture on how it is done in EVDRE. IN BPC 10.0 we are mirroring the same info by creating another report.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In my org they use y-o-y and month-on-month comparison and hence this format. Currently they are using BPC 7.5 and I see that in these reports that they have created another report in a similar format outside the main report. Just wanted to know if there is a better way in BPC 10.0 to do it without creating another report by using EPMAXISOVERRIDE or EPMDIMENSIONOVERRIDE.

      I have attached the formats done in EVDRE to get a clearer picture on how it is done in EVDRE. IN BPC 10.0 we are mirroring the same info by creating another report.

  • Nov 29, 2016 at 05:50 PM

    I have already told you that "It's impossible to have one dimension both in row and column axis of the same report"

    Same for BPC 7.5, 10, 10.1

    You have a strange report - why not to move quarters to column axis???

    If you still want to have the existing layout you have to:

    1. Use multiple reports

    2. Use =EPMRetrieveData(... in local members (slow!)

    Add comment
    10|10000 characters needed characters exceeded