-
Dimensions definition
Hi
I have to modify a Datawarehouse and adapt it to multi-company. Basically this is what I should do
a Sales fact table, the Group was one company but after some merges it becomes three companies. So now they have to do rollup and drill down analysis based on companies, product category and Category type
For example
company ===> 3 companies
product category ===> engine oil, fuel etc
category type ===> Services, marketing product, finishing material etc
The new aggreates can be based on companies, product category and/or category type
Some data
Company
============
company_A
company_B
company_C
Product category (these are codes)
===================================
10
20
30
40
50
60
Category type (these are codes)
===================================
01
02
MK
PS
SV
The problem is any company can or NOT to share the product category codes and category type codes. I.E
Company_A, 10, 01 can be same as Company_B, 10, 01 or Company_C, 20, 02
My question how on earth would the dimensions defined? I was thinking to define three dimensions however since the codes by themselves EXCEPT the company code are not UNIQUE (The unique key would be the combination of all three) so there is no way to isolate product category and category type in their dimension (If my understanding of dimension is correct)
I am thinking to simply add the three columns to the fact table and byebye to the dimensions...
Any suggestions?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|