Skip to Content
0

Repeat Time dimension in row & Colum axis in BPC 10.0

Nov 28, 2016 at 09:16 PM

165

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Nov 30, 2016 at 03:51 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Nov 28, 2016 at 09:27 PM
0

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...

Share
10 |10000 characters needed characters left characters exceeded
Nirmala Rozario Nov 29, 2016 at 03:17 PM
0

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.


Show 3 Share
10 |10000 characters needed characters left characters exceeded

You have already selected your answer as Accepted :)

0

I am sorry. I seem to have accepted the answer by mistake.

0

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.

0
Vadim Kalinin Nov 29, 2016 at 05:50 PM
0

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!)

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your response. I am not familiar on how to use EPMRETRIEVEDATA. Could you write me the formula?

Also may I know when can EPMDimensionOverride & EPMAxisOverride be used ?

0

Sorry, but I am not providing online EPM training!

Just read help: http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

And may be something here: http://wiki.sdn.sap.com/wiki/display/CPM/EPM+Add-in+Academy

I will answer only specific questions.

0

Thank you.

0

In my org they use the CELKEYRANGE (Evdre) for displaying the comparative years in the column axis

0

I wanted to know if there is an equivalent to CELLKEYRANGE in EPM ?

0