Dimension Design

View previous topic View next topic Go down

Dimension Design

Post  MorneJNel on Mon Mar 09, 2009 12:47 pm

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.

MorneJNel

Posts : 2
Join date : 2009-03-09

View user profile

Back to top Go down

Re: Dimension Design

Post  BoxesAndLines on Mon Mar 09, 2009 1:02 pm

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

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Dimension Design

Post  MorneJNel on Mon Mar 09, 2009 1:32 pm

Thanks, that at least gives me another option.

MorneJNel

Posts : 2
Join date : 2009-03-09

View user profile

Back to top Go down

Re: Dimension Design

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum