My dimension table looks something like this

Category
Subcategory
Product
SKU

The fact will hold information at the SKU level

I need to create 2 dimensions for users analysis

Category, Subcategory and Product
Subcategory, Product and SKU

How can I do this? Can both the hierarchies be made available in the same
cube? (as grain level is different?)

thanks in advance

--
Message posted via http://www.sqlmonster.com

If the grain of your fact data is the same, then you can do it all in one
cube. (I'm assuming SKU is the lowest level of product, and it's captured in
all your fact rows)

You can do it two ways:
1) have two hierarchies in your product dimension
2) have two different dimensions for each hierarchy you described

Either way, storage will physically be the same, multiple hierarchies of the
same dimension are treated as though they're two seperate dimensions.

Some front ends won't allow you to look at different hierarchies of the same
dimension at the same time. If this is a problem, or you'd like to have
those hierarchies on different axis in your reporting, you should definitely
use the second approach.

Good luck.



"tarana halsall via SQLMonster.com" wrote: