If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Lookup for range of values

Started by talmest, 29 Sep 2010 07:23:26 AM

Previous topic - Next topic

talmest

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.

StuartS

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