cancel
Showing results for 
Search instead for 
Did you mean: 

MVAL - Reverse ACCT model to KF model

Former Member
0 Kudos
80

Gurus,

As per the link below we can convert multiple KF to single KF

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/b8/a76a1ca9ac4ca698259a8ff397bb61/content.htm

Source data:

Account, Entity, Data source, LC, GC, TC.

Cash, SalesItaly, Input, key1, key2, key3

Mapping command:

Account =MVAL(LC|STR(Cash_lc)||GC|COL(1)+STR(gc)||TC|*STR(Cash_tc))

Target data:

Account, Entity, Data source, keyfigure

Cash_lc, SalesItaly, Input, key1

Cash_gc, SalesItaly, Input, key2

Cash_tc, SalesItaly, Input, key3

Taking the same example above ,how to now reverse it convert Account based model to KF model

please suggest the MVAL syntax mapping command with example

This would be required for exporting data out from BPC to BW

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I hope you can check with APD to convert KF model to Account Model.

Regards,

Sonti.

former_member190501
Active Contributor
0 Kudos

Hi,

You can use APD's(Tcode [RSANWB|http://www.erphowtos.com/guides-a-tutorials/doc_view/543-analysis-process-designer-apd-1.html]) to convert Account based model to KF model.

Hope it helps...

regards,

Raju

Former Member
0 Kudos

with Full optimization the cube name changes so APD may not work ....

krishna_priya1
Contributor
0 Kudos

I was told that full optimization only runs when BPC cube meets certain requirements .One of them is cube should have >= 13 dimensions. That way technical name of cube doesn't change and can use APD. Correct me if i am wrong !!

Former Member
0 Kudos

That is correct ,keeping in mind the longer term vison

krishna_priya1
Contributor
0 Kudos

I am just curious to know , what might happen in long run which effects full optimization to change technical name . is it data in cube ?

Former Member
0 Kudos

Chetan,

It was mentioned that the Technical name will get changed and even we the DTP gets effected if we do Full optimization. So, it the model is apt and has 13 dimensions, then there won't be any new cube creation in the back end. ?

Appreciate your thoughts on this.

Regards,

Sonti.

Former Member
0 Kudos

Hi Chetan,

I am not sure what you mean by - "keeping in mind the longer term vision" ?

Do you plan to change the structure of the application, in the future. This is very unlikely in practical scenario.

How many dimensions do you have now? If its 9 or 10, I dont think you will ever add 3 or more dimensions to your application, after it has already gone live.

Think over this.

Its good to think about risk mitigation plans but the risks should be reasonable.

Former Member
0 Kudos

Niranjan , but i still did not get the answer of how to use reverse the MVAL syntax

Also if APD is the solution then can you tell me what needs to be done on the APD side ,which transformation and any routines if any ..

Thanks

former_member190501
Active Contributor
0 Kudos

Hi,

Create a Bex Query on multiprovider which is generated by system on BPC application. Using [APD|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a019563e-bae8-2c10-0abf-b760907630e9?QuickLink=index&overridelayout=true] (RSANWB) you can download this report result in to DSO or Flatfile. While trasfering data from report result to target you can use "Transformation data record into list" to convert single key figure into multiple.

Hope it helps....

regards,

Raju