Good day everyone,
i have a question about lookup cube as follows :
- i have the following cube (source cube)
P_Min P_Max Value
Criterion 1 0 20 A
Criterion 2 20 999 B
i want to populate dimension called "Degree" using another dimension called "P" in the destination Cube. The values of "P" could be any thing between 0 and 999. I want to do a range lookup so if for example the value of "P" is
5 i want to put the value "A" in the dimension "Degree". If the value is 88 the value of "Degree" should be "B".
how could this be done using analyst ?
thank you for your help.
Hello
If I understand your requirement then this is quite straight forwards. There several ways of doing based on your need but NOTE: You cannot restrict the values in a D-List lookup based on the values in another D-Cube. However;
A Solution
Your Degree dimension will look like
P
A_Min
A_Max
B_Min
B_Max
VALUE
You will import your criterion min and max values through a D-Link. These will then be used in a calculation in the line VALUE,
Calculation
IF ({P} < {A_Max} AND {P} > {A_Min})
THEN 1
IF ({P} < {B_Max} AND {P} > {B_Min})
THEN 2
Where the 1 and 2 relate to the IID of a Value lookup D-List.
E.G D-Cube
P A_Min A_Max B_Min B_Max VALUE
1 10 0 20 20 999 A
2 80 0 20 20 999 B
Hope this helps
Stuart