Read Infocube in Transformation

[Former Member]

Hi,

in my end routine, I need to read the data in a infocube what is the select statement is it the same as an ODS.

Select * from infocube-name where field-name = 1111

Thanks,

Eric

[Former Member · Accepted solution]

Eric,

you can read the data in the cube using select but make sure which table u need to access wheather it is fact table or dimension table. Coming to ODS it stores the data in the flat transperent table.

Advise me if am wrong.

Thanks,

@P..

[Former Member · Accepted solution]

Hi,

I need to access the fact table to access it I need to know the dim id of each dimension table. it's not really friendly ???

Any idea

[Former Member · Accepted solution]

Look in sm37 and look for a function module that reads infocube (i don't remember the name try to look for readinfocube*).

Don't try to read an infocube with select statements.

[Former Member · Accepted solution]

The FM for reading infocube contents is RSDRI_INFOPROV_READ.

Thanks,

@P...

[Former Member · Accepted solution]

Go thru this blog..........it might help u.........

/people/dinesh.lalchand/blog/2006/06/07/reading-infocube-data-in-updatetransfer-rules

Thanks,

@p..