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

IF THEN ELSE like functionality working on a cube

Started by Bibuzz, 19 Aug 2020 07:51:36 AM

Previous topic - Next topic

Bibuzz

Hi,

I am working on a report using a cube source (MS).
There report contains a cross tab that looks like this:

                     2019   2020
Fruit
   Apple
   Lemon
   Strawberry
Vegetables
   Beans
    Carrot
Other
    Tomato

Both the 1st group (fruit, vergetables, other) and the 2nd group (apple, lemon, etc.) are different attributes from different dimensions.
I would now like to change the "Other" to "vegetable" when the value is "Tomato".
In relational modeling this would be straightforward using if then else or case statements.
Is there any way this can be done on a dimensional source in the report itself (I cannot change the source cube).

Many thanks for your replies