## Calculated Member Question

### Calculated Member Question

I have a renewal status dimension in a cube that has term_number at its
first level.  I'm being asked to drop that dimension, and replace it with
one that simply returns NEW is term_number is equal to one, or RENEWAL if
term_number is greater than one.  Can I use a Calculated Member to do this?
I could add a new column to the table and use that as a dimension, but I
would prefer not to do that.  If calculated member isn't the answer, is
there another way to create a derived dimension?

Kelly Rowe
Renaissance Worldwide, Inc.

Hi,

I am new to OLAP. This is what I am trying to do:

I want to calulate the middle value for a measure. I know how to do the
average but am not sure how I can calculate the middle value.

I have 2 measures - Amount,Feature. For example, if there are 3 features and
the paid amount are 100, 10,000, 1,000,000 then
the average is (100 + 10,000 + 1,000,000) / 3

The medium is 10,000 -- the middle one - HOW CAN I CALULATE THIS? I need
this to rollup also.

TIA.