Dimension Design

[MorneJNel]

Hi

I need some best design ideas for the scenario I'm sitting with. I have a Product Dimension consisting of standard attributes like Owner, Category, Brand, PackType , ProductId as natural key etc. The problem that I sit with is that the different clients have different brand for a product. For example the product id 12 that is Coke light 330ml can has Brand Coke light, but clients in say Namibia group it as Coke - Core while the clients in Ethiopia group it as Coke. What I did upto now is I created My product Dimension with Columns for Brand, NamibiaBrand and EthiopiaBrand etc. The problem is I have 30 clients so 30 columns. This create havoc for my ETL and now I have to create a different report structure for each client even thought the layout of report is the same except that I I have to change the column Name I read the Brand from.

Is there a better way of doing this without using snowflake dimension.

The option I thought was to split the dimension table into separate dimension tables dim_Owner, dim_Category, Dim_Brand and Dim_Product. Thus I can select a brand for a product for a specific owner. This make my live easier for Aggregate Fact tables And Dimension for I need a aggregated table based on brand and owner.

Please help.

[BoxesAndLines]

http://www.kimballgroup.com/html/designtipsPDF/KimballDT62Alternative.pdf

[MorneJNel]

Thanks, that at least gives me another option.

[Sponsored content]