We are building a cube that has about twelve dimensions and our cube builders have decided that the variances (and budgets, when implemented) will be in Measures. Without variances we have 9 measures. With variances (variance to last year and % variance to last year) we will have 27 measures and when we include budgets we will have 27 more. How do you handle your Budget and variances?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Budgets and variances
- Thread starter jkari
- Start date
lhendrickson
Technical User
We have our budgets and variances in the Scenario dimension. Actual, Budget, Forecast, and Variances all roll into this dimension. I have never seen it done any other way -- let me know how your proposed structure works out.
LHendrickson
LHendrickson
- Thread starter
- #3
Like lhendrickson said the Actual, Forecast, and Budget should be build into a scenario dimension. Since Variances are typically calculations they should be in the Measures dimension or a Calculations dimension.
"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck
"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck
- Status