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)
 AS2005 - Dimension problem

Author  Topic 

maevr
Posting Yak Master

169 Posts

Posted - 2007-10-08 : 09:07:24
How do I create dimensions that exists in multiple cubes with different facttables. The dimensions must have the same name.

In AS2000 you separated them as shared dimensions and private dimensions.

How do I manage this in AS2005?

maevr
Posting Yak Master

169 Posts

Posted - 2007-10-08 : 09:39:10
Solved it myself.

You create two database dimensions connected to their own cubes Cube1, dim_1 and Cube2, dim_2, then you add them as private dimensions and rename them. The link between their parent database dimensions still works.

Go to Top of Page
   

- Advertisement -