cancel
Showing results for 
Search instead for 
Did you mean: 

complicated kf

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (4)

Answers (4)

andrea_previati
Contributor
0 Kudos

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6eb89190-0201-0010-89bf-ad4...

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

Former Member
0 Kudos

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

andrea_previati
Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.