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