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 2000 Forums  Analysis Services (2000)  Virtual Cube : Sales Vs. Budget

Author  Topic  FrA Starting Member 1 Post Posted - 2003-04-24 : 04:13:44 Hello! I have a problem with building a virtual cube that compare the cube of 'budget' and the cube of 'sales'. The datamart is based of these two facts : budget and sales. These facts have different granularity. Budget's dimensions : - AGENTS : inspector / agent - ZONES : macrozone / zone - LINES : line - SEASONS : year-season Sales's dimensions : - AGENTS : inspector / agent - CUSTOMERS : macrozone / zone / city / province / customer - PRODUCT : year-season / line / group / product - SEASONS : year-season / month / day For dimension 'AGENT' I have not problem, because is the same in the two dirrent cubes (budget and sales). 1) How I define the others dimensions ? 2) Virtuals ? 3) With custom rollup? How? I hope in yours aid! Bye.