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?