References to Infocubes in Routines

[Former Member]

I am trying to do this really simple thing it involves taking my data from my infocube into an internal table in a routine.

I have gathered it is not good to refer to the Fact and Dimension table DDIC structures because at runtime these have not been activated and the routine will fail.

Does anyone have any really simple dynamic code in template format for getting data out of an infocube and into an internal table. Any example or actual code will help. Thanks!

[Former Member · Accepted solution]

Hi McCavoy ,

we can't get the data from the cube using routine because cube is not a flat structure .. and for a cube we will have the fact table and dim tables ... fact table contains the key figures and dim ids..

and dim tables contain dim ids and sids ....so what ever table u refer u cant get the data....

we can get the data from dso , master data infoobjects using routine into some other tables....so we can have a look up using a master data infoobject or a dso which is a flat structure but not from a cube,,,,,

Regards

vamsi

[former_member184494 · Accepted solution]

You will have to hit the F Table - then find the Dim IDs for each of the dimensions - then get the SIDs from the DIM table and then get the data you want - otherwise you can use RSDRI_INFOPROV_READ to read the contents from your infocube into an internal table and then process the same...

[Former Member]

Hi,

You can create query on infocube and take all required data in query output. Create function module and write MDX on query and take required result in output which you can use in your internal table. I hope this will work.

Rgds,

Manish