on 2011 Dec 15 7:47 PM
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
I hope you can check with APD to convert KF model to Account Model.
Regards,
Sonti.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
8 | |
5 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.