SAP Business Objects XI R3 Universe Designer : How to use CASE WHEN expression on multiple columns?

[Former Member]

Hi all,

I am trying to create a Dimension object based on 2 columns of 2 tables. Here is the syntax, it should probably be more explicit than a long sentence :

CASE

WHEN "Table1"."Column1" = 'Value1' THEN 'Dimension Value1'

WHEN "Table1"."Column1" = 'Value2' THEN 'Dimension Value2'

WHEN "Table1"."Column1" <> 'Value1' AND  "Table1"."Column1" <> 'Value2' AND "Table2"."Column2" <> NULL THEN "Table2"."Column2"

WHEN "Table1"."Column1" <> 'Value1' AND  "Table1"."Column1" <> 'Value2' AND "Table2"."Column2" = NULL THEN 'Autres'

END

The Parsing result for this expression is : Parse failed : Exception: DBD, The multi-part identifier "Table2"."Column2" could not be bound.State:  S0001.

I think this is because Case expression can not be used with 2 different columns but I can't find any other way to create my dimension.

Would someone be able to help me on this issue?

Best Regards.

Yacine.

[former_member182521 · Accepted solution]

Hi Yacine,

This seems to be an issue at database level rather than at Universe level.

does your Table2 is an alias of Table1?

Have a look here.

http://www.sql-server-helper.com/error-messages/msg-4104.aspx

Regards

Mani

[Former Member · Accepted solution]

Hi Mani,

Thank you very much for your help. It was very helpful! I had to add Table2 to the list of tables of my dimension object!

Thank you very much!