Hi All OLAP Gurus,

I have problems with incorrect total value, as the following:
Customer|BudgetCost|BudgetVolume|UnitBudgetCost
CustA|100|50|2 (100/50)
CustB|50|50|1 (50/50)

BudgetCost and BudgetVolume are real measures.

UnitBudgetCost is calculated member with this formula:
iif([Measures].[Budget Volume]=null,null,[Measures].[Budget Total
Cost]/[Measures].[Budget Volume])

What I want for the total UnitBudgetCost to be 3 (2+1) and not 1.5 as a
result of applying the formula.

I searched the forum and found that I could change UnitBudgetCost to
real measure so that it can aggregate the total to sum up the value,
but how to do this with the above formula?

Or should I set the solve order for UnitBudgetCost?

I'm very new to OLAP and very confused at the moment. Any help is very
much appreciated.

Thanks in advance
Josephine

You can create a view of your fact table adding a column that precalculates
UnitBudgetCost. You then build you cube using the view as the fact table and
define UnitBudgetCost as a stored measure based on your computed column.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"ing" wrote:

Thanks a lot Brian,

I intend to use the view you suggested when I don't have any other way
to do it directly on the Analysis Services.

I just found a solution to this. I set All Member formula to the
dimensions (in this case 6 dimensions) using Sum(X.children) and set
the solve order to -5120.

It works fine for 1 dimension (eg. Customer). But when I apply it to
the second dimension (eg. Product), the Pivot table (from Frontpage)
becomes very slow. It's using up to 550MB of memory.
Any suggestion to improve on this?

TIA
Josephine