Hi,

I am new to MDX querying.

We have a cube with the following measures: Activations, Cancelarions and
Terminations.

Associated with contracts. But each contract can have a "quantity
associated" (dimension).

We need to create a calculated member that would return:
+ "quantity associated" * [measure].[activations].
+ "quantity associated" * [measure].[cancelations].
+ "quantity associated" * [measure].[terminations].
Of course that only the "quantity associated" with an activation (et al.)
must be considered.

We could solve this in the relational source, but we rather do it using MDX.

We have tryied to use "quantity associated" as a mesaure but it does not
restrict the quantity associated with an activation (et al.).

Thanks in advance.

Does your fact table have separate records for Activations,
Cancellations and Terminations? In that case, creating a dimension like
"ContractEvent", with members being these 3 options, may be beneficial.
You could re-define the original measures as calculated measures, like:

'([Measures].[EventCount], [ContractEvent].[Activation])'
And separating the quantity by Event will be simpler.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!