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)  Composite Key

Author  Topic  budski Starting Member 7 Posts Posted - 2010-05-15 : 13:04:49 I'm having some trouble getting a composite key to work so I'm hoping some one can point me in the right direction. The problem..... I have a fact table of sales and a dimension table the key for the sales table is SalesPersonID And RegionID and that is joined to the fact table on SalesPersonID and RegionID. The dimension table Has 2 attributes Age and SalesTrainingProgam. The wizard gives me a message that can't create composite key dimension so I inspect the dimension in the editor and the columns collection contains all the columns i specified so I'm at loss as to what it doesn't create. When I try and process the cube with 1 dimension containing 2 attributes and two measures Sales and Incentives it craps out with an internal error message which is about ambiguous as it can get so I'm at a loss. Any help with this would be greatly appreciated