Hi
I am new to MDX. If someone can please help me with
simple question

I have to create a calculated member
I have 3 dimensions Product, Time, Sales
I have two measures. CostA, CostB

The result that I want for calculated member is
(sum)costA/(sum)costB

I tried doing [Measures](sum)(costA)/[Measures](sum)
(costB) but got error


Thanks

David

Create two measures in your cube called CostA and CostB. Use the SUM
aggregate type on these.
Then create a calculated member on the Measures dimension and call it
whatever you'd like and define it as

[Measures].[CostA]/[Measures].[CostB]


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

<anonymous (AT) discussions (DOT) microsoft.com> wrote

I think this would work for you

((sum([Measures].costA))/(sum([Measures].costA)

you may also want to look at support for divide by zero and formattin
see functions
ISEMPTY(
IIF()
----- anonymous (AT) discussions (DOT) microsoft.com wrote: ----

H
I am new to MDX. If someone can please help me with
simple questio

I have to create a calculated membe
I have 3 dimensions Product, Time, Sale
I have two measures. CostA, Cost

The result that I want for calculated member is
(sum)costA/(sum)cost

I tried doing [Measures](sum)(costA)/[Measures](sum
(costB) but got erro


Thank

Davi

SUM function requires a set as 1st argument.

public @ the domain below
www.tomchester.net

"Jason" <anonymous (AT) discussions (DOT) microsoft.com> wrote