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?
Siegfried Szameitat replied
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.
If you need more help, let me know.