Case Select

system · August 11, 2009, 8:50am

Is there a way of using similar to a case select statement in Infoview on WebIntelligence XI?

At the moment we are producing a report that has so many if statements within one variable that the thing is getting difficult to read to identify if all is correct. It would be much easier to have a case select statement to make it nice and neat.

Cheers

gattaca (BOB member since 2009-08-11)

system · August 11, 2009, 8:51am

No, you are stuck with the IF logic in WebIntelligence, but I would recommend putting that logic if possible in the ETL layer to populate your data warehouse with the values.

Andreas (BOB member since 2002-06-20)

system · August 11, 2009, 2:05pm

If the ETL change is not a possibility, you can define your case logic in your Universe

AnthonyJ (BOB member since 2006-06-30)