Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Copying Key figure from Cube 1 to Cube 2

Hello Experts,

I'm a beginner in IP and do have one question:

I've a IP layout created on top of an aggregation level which is on top of a MultiProvider that encompasses both a real-time as well as Standard Cube.

The layout looks like the following:

For a single Customer and Product Hierarchy

                    Period1    Period2   Period3

Revenue            20

Driver 1             30

Driver 2             40

Total Revenue   90

Now I would like to copy this value of '90' to another cube for same customer,Product Hierarchy,Posting Period and so on, which will be disaggregated to lower SKU's.

How shall I achieve this?

Really Appreciate your guidance on this.

Thanks & regards,

Jomy

Former Member
Former Member replied

DATA I_FISCPER TYPE 0FISCPER3.

DATA I_CSUP TYPE Product.

DATA I_CUST TYPE Customer.

FOREACH I_CUST,I_CSUP,I_FISCPER.

  {AMOUNT,I_FISCPER,Cube3,I_CSUP,I_CUST} =

                                                 {Driver2,I_FISCPER,Cube2,I_CSUP,I_CUST} +

                                                 {AMOUNT,I_FISCPER,Cube1,I_CSUP,I_CUST} *

                                                 (1 + {Driver1,I_FISCPER,Cube2,I_CSUP,I_CUST} / 100).

ENDFOR.

Maybe something like this?

About interface - it doesn't matter, just place object with this icon somewhere in your layout and you get desired messages.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question