Anyone out there created their own DMart/RMart?? Want to relate your experience? What difficulties?? Was there Abap to staging to ods to dimensional Dmart? Did the Dmart reflect RMart design and focus?
How did you manage Abap handling (also did you process directly to staging tables from Abap)??
Were there any new concepts applied to the design??? The thing is, and this is the bottom line, I find this process so outdated. Someone out there holds the key to EDW 4.0!
Yes, we have created and implemented several Rapid Marts, Data Marts around SAP content.
Are you building this from scratch or are you using a Rapid Mart? If from scratch I would recommend using the following structure:
SAP->(abap data flow or BW extractor)->Staging Area->Data Mart(s)
You have a choice when it comes to extraction, I would consider your company’s core competencies when deciding how to extract – ABAP Data Flows vs Extractors
I would most certainly recommend a Staging Area - It will open up your architecture for re-use when sharing master data or constructing specialized data marts. More than likely you will be creating content incrementally – this will allow you to integrate new content easily
What are your reporting requirements? If purchasing, you will also certainly need to bring along AP, GL and Material Movements data and a slew of shared master data (material, vendor, plant, etc)
(BOB member since 2004-05-21)
(BOB member since 2010-11-09)