Skip to Content
0
Feb 09, 2011 at 05:37 AM

Modelling suggestion for Master data

24 Views

HI All,

We are currently doing design for our BI implementation, Oracle being the source system. For one of the dimensions, Geography, user will need to drill down from Company to Country and to Area,. Area being the highest in the hierarchy, such as North America, Asia etc. Company infoobject will have Country as an attribute which means, the first part is more or less clear. Where as for Country to Area. We have a linking table in the source which is Country in Area which will have Area type ( customized regions types), Country ID and Valid from and Valid to.

We decided to have infoobjects for Area, Company and Country, we are not sure how to handle Country in Area to provide the drilldown from Country to Area. One Area can have multiple countries, depending on the Area Type, once country can be part of several Area Types. We are using SAP BODS as ETL tool and BO as reporting tool.

Can someone help us on this.

Thanks and Regards,

Srinivas