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.
Please share your ideas, thoughts and experiences w.r.t. this issue.
Thank you.
Regards,
Shashidhar.