Hi !

Say that I have three measures AAA,BBB,CCC

now I use two to calculate a new member DDD

ex: [Measures].[AAA]/[Measures].[BBB]

works fine

But how can I use a measure iside a funtion like STDDEV or
SQRT ?? When I try as like above it gives errors !!

Also How can I use certain measures.. only to calculate
another measure ??

ex: Use measures AA and BB to calculate CC but only show
CC in the drill down process ??

To display only the calculated measure, hide the unwanted
measures by setting the visible property under advanced
tab to "false".(First click the required measure in the
cube editor)

Abhinav Kumar
akumar (AT) itmag (DOT) com.au