Skip to Content
0
Jan 11, 2012 at 03:55 AM

DSO vs. Infocube - modeling criterion

173 Views

Hi All,

I am working on query performance optimization analysis, I have a scenario where a multiprovider has predominantly infocube and just 4 DSOs. These 4 DSOs are flat-file loads and are directly used for reporting.

We have applied Multiprovider hint table option, query run time is better but still more shorter run time is expected by users.

The only option left out is to introduce infocube layer for above 4 DSOs and use them in multiprovider. I would like to know, the criterion for introducing infocube above DSO. I have got a little learning from below link, but I am unable to get to a conclusion.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b04a79b4-bbea-2b10-da86-bf0fe933fe34?QuickLink=index&overridelayout=true

Please share your ideas, thoughts and experiences w.r.t. this issue.

Thank you.

Regards,

Shashidhar.