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.
| Author |
Topic |
|
davidagnew37
Starting Member
33 Posts |
 Posted - 2004-08-12 : 09:10:24
|
| "Dimensions affect all measures in Virtual Cube...."I have a situation where measure 1 and 2 ("Actual", "Budget") is dimensioned by dimension A, B, C, D. Measure 3 ("Full Year Budget") is dimensioned by A, B, C, E. Therefore I put the measures 1 & 2 in one cube and 3 in another separate cube. I eventually hope to achieve having a virtual cube with three measures: "Actual", "Budget" and "Full Year Budget". The dimensions I have are:a - Account No_ / Name b - Cost Code c - Sub Cost Coded - Time/Dates e - Budget Name The Problem is that both "Actual" & "Budget" need to be filtered/dimensioned by:a - Account No_ / Name b - Cost Code c - Sub Cost Coded - Time/Dates (exclusive to "Actual", "Budget")BUT "Full Year Budget" needs to be filtered/dimensioned by: a - Account No_ / Name b - Cost Code c - Sub Cost Codee - Budget Name (exclusive to "Full Year Budget")The problem being the following dimensions:- Time/Dates = exclusive to "Actual", "Budget"- Budget Name = exclusive to "Full Year Budget"The problem is when I create the virtual Cube, the Dimensions affect ALL measures....perhaps the underlying problem is when I create the two cubes which eventually create the Virtual Cube - in the way that I use shared and private dimensions. I have tired creating virtual dimensions also. Is this the right direction to go in? |
|
|
|
|
|
Joining 2 Cubes - virtual cube