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

Is it possible to do the following...

Started by jive, 31 Jan 2010 08:29:25 PM

Previous topic - Next topic

jive

Hi, first of all english is not my first language I will try to be as clear as I can.


Supposed I have 2 dimension , one for the sex the second the language and as meausre dollars.
these are the data in alist
sex    lang    $
w      en      15
w      fr       100
m     en       200
m     en       151
m     en        49
m     fr         45

In a crosstab that will look like

     woman     man     total
en   15          400      415
fr    100         45         45

Now I want to split for the man the dollar like this "man with more or less then 50$" , the result should be

     woman          man                total
                      <50        >50
en  15              351       49         415
fr   100              45         0          45


The problem here, I don't have any dimension for dollar range. there is a way to create kind of a "sub dimension' based on measure and dimension. If yo know how I don't want the solution step by step but more am indication to how i can do it and If you have documentation I will like to look at it.

Thanks for your help

thanks


NaviGator

jive,

I think you can create two calculated members to perform you requirements

The first calculated member should be, 

case
when man > 50
then man
else 0


The other calculated member will be something like

case
when man < 50
then man
else 0


And when you are going to use them in the crosstab as a sub-node to man, they will be aggregated and will give you the required result.

Never Stop Learning ..