Doubt Can I create Infocube or DSO

[Former Member]

Hello,

Using LO-Extraction activated 2LIS_11_VAHDR(Delta Enabled) and 2LIS_11_VAITM(Delta enabled) loaded data into PSA tables.

In order to Delta load and less report time, which is the best way from below.

Can i load data from PSA to DSO then INFOCUBE ?

OR

Can i directly load data from PSA to INFOCUBE?

Expert

[Former Member · Accepted solution]

Since you are using Delta load, I'll suggets you t go for first option. PSA->DSO->Cube. The SO will give you staginf flexibility and it handles delta very efficiently.

Thanks...

Shambhu

[Former Member]

HI

Its better first load the data into ODS and then from ODS you can map the update rules to cube, on top of the cube you can create the report.

Regards,

chandra.

[Former Member]

reporting time alone does not drive the data model. It depends on a number of factors.

Usually having a ODS layer is a good approach. There are exceptions however.

This is a generic question and has no straight forward answer.