on 05-02-2006 6:29 AM
Dear Gurus,
I have complicated KFs that are derived at query runtime.
I need these KFs into a new cube.
As the new cube is also loading from various other cubes, I like to use the query results of the complicated KFs cube to export as source for the new cube so that I need not derive the complicated KF.
I tried the standard ways of rscrm_bapi but it seems that the batch job never starts due to delays and warnings about invalid Keyfigure even though my Keyfigure used for testing is a simple one.
Is it true that this feature is no longer supported in BW3.1C?
If I were to only export to table inside BW and not exporting to external systems, do I still need additional license? For purpose of testing, can I still use this feature without buying the license until I am sure this is what is needed? Is my errors due to licensing?
Can Open Hub BAdi transformation be used to perform calculation on the keyfigures? Seems that only characteristics are avail for selection. How can the keyfigures be referenced in codes in BAdi?
Many thanks!
Suzie Fernando
Hi Suzie,
another option might be to create a generated datasource using a custom defined function module as extractor. In this fm you need to call the functions to run the query to get the data into the extract structure. Assign the datasource to a infosource and proceed as usual. Make sure all relevant fields will be included in the query.
Check out the following fm for that.
RRI_REPDIR_READ,
RRX_SESSION_INITIALIZE
RRX_REPORT_OPEN
RRX_GRID_CMD_PROCESS
If you need more help, let me know.
regards
Siggi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
With jump query you can read your KF from another query.
So you can export the data you need in a sender- receiver process trough queries.
You can check these links
http://help.sap.com/saphelp_nw04/helpdata/en/73/246f3f12290866e10000000a114084/frameset.htm
The open hub instead allows you to export to a table or in .csv format the infocube data either KF or char...
You can also manipulate the exported data with ABAP ...
Hope it helps
Andrea
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks San.
I need to check with you guys if Open Hub can allow me to manipulate the keyfigures for calculation in effect like a start routine.
Regards,
Suzie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Maybe you should focus your attention on Query Jump (RRI) using Transaction (RSBBS). The jump query allows to read KF from other queries.
The open Hub instead allows to export and manipulate data to external systems in .csv format .
Hope it helps
Andrea
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Interesting Andrea. Thanks.
Would you know if the jump query read from query of different cube/ods?
open hub also allows export to table. And there is preprocessing by Badi but not sure if KF can be operated by it as I cannot see KF being selected. Only chars. Can open hub badi process like start routines? Experts could you give a hint?
Regards,
Suzie.
Hello Suzie,
Using Infospoke you should be able to export it to flatfile and Database tables. I am not sure of licence though as for flat file it won't be require but for database file i am not sure, wait for more comments from experts.
This may help you.......
take a look
http://help.sap.com/saphelp_nw2004s/helpdata/en/c5/03853c01c89d7ce10000000a11405a/frameset.htm
and about BADI
http://help.sap.com/saphelp_nw2004s/helpdata/en/e6/d54d3c596f0b26e10000000a11402f/frameset.htm
http://help.sap.com/saphelp_nw2004s/helpdata/en/eb/3e7cf4940e11d295df0000e82de14a/frameset.htm
Business Add-Ins (BAdIs) are enhancements to the standard version. They can be inserted into the SAP System to accommodate user requirements too specific to be included in the standard delivery.
Rgds,
San.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.