to create detailed level report which is preffered cube or ods

[Former Member]

can any 1 plz justify for a new requirement ,detailed level reporting which is best and why.

[Former Member · Accepted solution]

Hi,

Cube is used for detailed level data, we can analyse data 16*245 angles.

Regards,

Sai.

[Former Member]

thanks u all, 4 such wonderful replies

[Former Member]

Hi Satish,

Infocubes are preffered for Atomic and Summarized Reporting whereas DSOs are more detailed and granular.

But there are certain major drawbacks of Using DSOs for Reporting :

- Low performance as direct reporting will be extremly slow due to large amount of data stored in single table.

- Multi-Dimensional analysis not possible.

- Calculation overheads for KPIs

Choice of DSO/Cube depends on the requirements but Infocubes are more preffered for reportings.

Please check below links for more details to help make choice easier :

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b04a79b4-bbea-2b10-da86-bf0fe933f...

http://infobyte.in/sap/(sap-bi)-difference-between-info-cube-and-dso-(datastore-object)/?action=prin...

Regards,

Akanksha

[Former Member]

Hi,

I you want to do detail level reporting, DSO would be preferred because in DSO generally we store detail level data .

If you want to make a report which involved calculations, then we should choose cube .

Hope the above reply was helpful.

Kind Regards,

Ashutosh Singh