AS2005 - Calculation Tab - DimensionMembers: MemberC = MemberB - MemberA

Hi to all,

I have one problem:

I have a dimensionshierarchy "Example" like this:

1

A1 B1 C1

2

A2 B2 C2

1 and 2 are parents.

C1 and C2 are dummy members, so I want to filll them

in the calculation tab with this formula:

C1 = B1-A1

C2 = B2-A2

That's what is standing now in calculation tab:

[Example].[1].[C1] = [Example].[1].[B1] - [Example].[1].[A1]

[Example].[2].[C2] = [Example].[2].[B2] - [Example].[2].[A2]

In the cube I have several measures. If I drag the Dimension "Example"

on the row axis and add measures on pivot table one-by-one, the calculation works

for some measures, but for some the PivotTable in Browse-Tab gives me

that exception:

..unexpected internal error.

It can be that it is a bug of pivottable-object. I can solve this problem, if i make calculations

explicit for each measure:

([Example].[2].[C2], Measure1) = ([Example].[2].[B2],Measure1) - ([Example].[2].[A2], Measure1)

But this is no elegant method (if I add some measures later I have to add again some code in this calculation). Have I written something wrong in Calculations Editor?

What would be more elegant approach for all measures?

Thank you in advanced, Mastroyani.

Try something like:

([Example].[1].[C1], Measures.Members) = [Example].[1].[B1] - [Example].[1].[A1]

If this does not work, can you provide more details on the error you recieve? Try the Show Techinical Details icon if available on the error message.

|||

Hi, it doesn't help, here is the error message (integrated in the pivottable):

Example Gesamtergebnis Measure1 Die Abfrage konnte nicht ausgeführt werden: Measure2 o Interner Fehler: Unerwartete Ausnahme.

Translated: Query could not be executed.

Internal Error: Unexpected Exception

I tried this:

([Example].[1].[C1], [Measures].Members) = [Example].[1].[B1] - [Example].[1].[A1]

([Example].[1].[C1], [Measures].Members) = ([Example].[1].[B1], [Measures].Members) - ([Example].[1].[A1], [Measures].Members)

Is there some other solution?

Thank you for the answers.

|||

Hi, i have played more with this problem and this I could find out:

this error comes always if I filter this calculated member (C1 or C2) out.

If both (C1 and C2) are included, all is OK.

What can it be?

|||

It is solved. Problem was: null values.

The calculation I've used from the beginning, and calculation provided as answer in this topic,

both were right.