select data from InfoCube?

[Former Member]

Hello Experts,

I'd like to know if there anyone has ever written start routine or end routine by selecting data from InfoCube?

As I knew so far, selecting data from InfoCube table is quite complicate because data could not be directly picked up.

It is required to link many tables, isn't it?

Scenario:

(DSO-A) load into (InfoCube-B)

DSO-A contained order number

InfoCube-B also contained order number

In term of performance and maintenance in long-term, If I'd like to get order number, should it be be better to get from DSO-A or InfoCube-B?

Could anyone has experience or best-practice on this?

Any suggestion would be sincerely appreciated.

Thank you very much.

-WJ-

[Former Member]

Hi.

You can read the data directly from infocube using FM RSDRI_INFOPROV_READ.

Please look at RSDRI_INFOPROV_READ_DEMO report that describes how to use such FM.

Regards.

[Former Member]

Hi,

If there is no specific requirement to use a cube then I would suggest to use DSO and not info cube as the DSO stores data at granular level and it will be also easy to access data from it later.

Thanks,

Naveen

[Former Member]

Hi Naveen

Can u please tell me about Customer Exit and where do we use.

thanks

[former_member182516]

Search in the forum about customer Exit this was discussed lot of time.

Edited by: prashanthk on Oct 25, 2010 2:59 PM

[former_member206635]

Hi,

You don't need to bother about dimension as source_package in start routine is pretty dynamic. Just work with that. Coming to your second doubt, if same data lies both in DSO & cube then better to report from cube, if dimensions are not huge and correctly designed.

--Akashdeep

[Former Member]

I differ a bit here. If there is a choice, pick DSO instead of IC. Dso has flat structure and has relatively low volume of data. For performance wise, DSO would be better over IC.