i need to get a calculated measure like 2^3 (=8). is there a function? thanks.

Try this Foodmart MDX (based on my preceding post):

SELECT {X} on 0 FROM Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

but how to simply write the formula in Calculated member in Cube editor?
thanks.
by the way, i don't have Foodmart installed, can you let me know how to
install it?

"Deepak Puri" wrote:

sorry, perhaps, you missunderstood me: i need to get:
Measures: amount
((Measures.amount.currentmember-measures.amount.currentmember.prevmember)
/measures.amount.currentmember.prevmember) ^12

"Deepak Puri" wrote:

Is this a recursive definition of [Measures].[amount] in terms of
itself, or another calculated measure? I you provide some sample data,
it will be easier.

((Measures.amount.currentmember-measures.amount.currentmember.prevmember
)
/measures.amount.currentmember.prevmember) ^12
When installing SQL Server Analysis Services 2000, there should be an
option to install the Foodmart sample DB (I haven't done this in a
while, so don't know details).

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***