Hi,

I have this problem:

I need to create a Custom Member (Dimension) that depends on the value of
a measure (Salary).
In few words, depending on the LastYear Salary I need to classify the Employee
into 3 classes "Rich - Normal - Poor" ... to define this class there are
value ranges, i mean for an YearSalary between 0 and 10000 Class is "poor",
for YearSalary between 10000 and 80000 is "normal" and so on...
how can i create this custom member?!?!

Thanks a lot
Ste

Hey,

Have you tried a case statement


Stefano wrote:

Hi,

Thanks for the answer... it probably should work for constant ranges, but
my ranges are in another Table like this:

ClassID int
ClassName varchar
LowerLimit float
UpperLimit float

so it means that i have to lookup that table to get the ClassName depending
on the YearSalary between LowerLimit and UpperLimit.

(i'm sorry i forgot to tell you that)

Thanks a lot
Ste



Hello tsachin (AT) gmail (DOT) com,