BW multiple key figures

[Former Member]

I am trying to load the assets related actual data from BW cube, which is prescribed by SAP 0FIAA_C13.

This cube has as may as 20 key figures.

The question is how do one load so many key figures to BPC or map them, even if 10 of it is needed.

Has some one experienced the same while maintaining asset planning model.

'

Appreciate your inputs..

[Former Member · Accepted solution]

Hi BPC,

You can create a new dimension that cater for the multiple key figures.

BW:

Data     KF1     KF2     KF3

BPC

dimension ID

KF1

KF2

KF3

If you want to sum up multiple KF then you can use routine for that.

Andy

[Former Member · Accepted solution]

Hi,

Please use rule groups in BW transformation for splitting the multiple key figure record into individual key figure records.

Regards,

Venkat

[Former Member · Accepted solution]

Can you give example of splitting key figure as per your suggestion.

[former_member186338 · Accepted solution]

Sorry, but what do you want to achieve???

In many cases it's sufficient to just link different key figures to the different account members:

ACCOUNT: FIXEDASSETS

KF1: Amount

KF2: QTY

Result:

ACCOUNT: FAAMOUNT, FAQTY

Vadim

[Former Member · Accepted solution]

Hi,

Lets assume data is getting loaded from BW DSO to BPC Cube

In transformation, we will map DSO Keyfugures to BPC Cube key figures.

Create new cube say BPC CUBE 1 with additional info object called ZAMOUNT on top of BPC Cube. Now in transformation create multiple rule groups as

follows:

Assume you have 2 key figures,1 quantity fields in your cube, so create two rule groups.

In first rule group: MAP only KF 1 to ZAMOUNT and dont touch KF 2

In second rule group; MAP only KF2 to ZAMOUNT and dont touch KF1

In BPC, please create key figure and quanity as account dimensions and perform below calculation in mapping section under transformation file.

ACCOUNT= *MVAL(ZAMOUNT|*NEWCOL(Amount)||ZQNTY|*NEWCOL(QNTY))

Regards,

Venkat