combine all the fact tables - 07-02-2003 , 02:19 AM
I have 10 tables each represent a product category. I have
created 10 cubes for all these products. However, I need
to create a cube that combine all the product categories.
Is it possible to do it?
Re: combine all the fact tables - 07-02-2003 , 05:12 PM
Yes you can if the 10 cubes have at least 1 shared dimension in common.
In that case you can create a virtual cube that is the union of the 10
I suggest you:
1) create a shared dimension "Product Category" that contains values from 1
to 10 (and description you need).
2) add a "Product Category" column in every cube with every row having the
same value (the value of the product
category of the cube)
3) add the shared dimension "Product Category" in every "real" cubes and
4) create the virtual cube and in this cube show the shared dimension
Now you can navigate through your ten Product Category as you like.