Hi,

I have the following problem with my cubes.

Some time ago I created MOLAP cube, with MOLAP dimensions. But now I am working on a new ROLAP cube (on different server, separate OLAP database). In this new ROLAP cube, I want to add some MOLAP dimensions from previous MOLAP cube, for example DimProduct (with natural hierarchy Category - Subcategory - Product). I linked this dimension to my ROLAP cube but it doesn't work with ROLAP partitions. I can't see any values for higher levels of product hierarchy (Category-Subcategory). There are only values for key attribute - Product.

Why MOLAP dimensions doesn't work with ROLAP partitions on attributes that are not key attributes?

Best regards

D.