Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Linked MOLAP dimension in ROLAP cube

Author  Topic  Dkmg Starting Member 1 Post Posted - 2009-04-17 : 16:51:51 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 new cube ROLAP (on different OLAP server). 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.