ODS my favorite thing to do in BW
I had different ideas about using the ODS vs. the InfoProvider with another Consulant and a few clients on my last project, and I would want your thought on this.
How often or what should be determined when to use the ODS or the InfoProvider? Yes I have read the Modeling white paper many times, and I understand the tables and their SIDs. My thought on using ODS is not favorable because it is a flat structure reporting method whereas the InfoProvider is multidimensional. Here are some links to the differences between an ODS and IC.
The clients were just out of training and wanted to do everything using ODS. The Consultant confirmed about the SIDs to me and was on my case. My issue was I was working on a task that had no key figures, but I used the InfoProvider to do reporting anyway because then it can be analyzed in multidimensional format. So what if the SIDs tables are created? These people read off to me from the BW book on how the SID tables are created when using the IC where the ODS does not.
My question is how would you explain to these people that it all depends on the requirement? Ultimately, you would still have to update the IC to do multidimensional reporting.
I want to educate myself and to these people that if you want to do ODS reporting why not use the SAP R3 ABAP reporting process. <b>Why take all this energy to shout and scream your head off about using BW?</b>
Bhanu Gupta replied
SIDs are going to be created if your ODS is enabled for BEx reporting too!
You are right about the reporting performance and capabilities of a multidimensional object like InfoCube or MultiProvider (as you say: why go through all the trouble otherwise)
Did your clients want to just have an ODS layer (for the EDW) or also do all their reporting off the ODS too?