cancel
Showing results for 
Search instead for 
Did you mean: 

DATA MART

Former Member
0 Kudos

HI,

friends i need some information regarding the Data Mart of SAP BW.

how to cerate it and why it is been used.

if possible with Adventage and Dis advanteage .

thanks and regards

shafeeq ahmed

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Shafeeq,

When data is loaded from one source to another source within BW, then the source provider becomes the data mart. Suppose you have an ODS and you have a cube to which the data is loaded. From the context menu of the ODS if you select the option 'Generate Export Dat source'' and infosource will be automatically generated in the infoarea called d'data marts' with naming convention 8<name of the ODS. This will be the infosource to the cube to which the data is to be loaded from the ODS. Thus the ODS becomes the data mart to the cube.

Hope this helps you.....

Answers (1)

Answers (1)

Former Member
0 Kudos

Havig a datamart or not having a data mart totally depends on what do you want to do. Let me give you an example. You bring in data from the source and load into a ODS or a cube. The same cube has potential to be used by different business areas or divisions in your organization. But their data requirements are slightly different from what the cube / ods has. In that case, it is a practice to make the cube a data mart by generating export data source. From this data mart / export data sourc you apply the busines slogic of each division / busines area, transform the data and load into the reporting cubes.

It is hard to pinpoint advantages and disadvantages of data mart. Advantage is each business area / division has their own rrporting cube and you can maintain authorization accordingly. Disadvantage is you tend to keep data in multiple cubes.

Ravi Thothadri