Is there a way to create an object in a universe that is based off four other fields? For example, I want to have a field that can have four different values -- A, B, C, D. It will be a string format. The value that populates is based off upto four other existing string fields. Using basic If Else statement, it would look like this:
If
Field1<>"Z" Then "A"
Else
If Field1="Z" AND Field2<>"Z" Then "B"
Else
If Field1="Z" AND Field2="Z" AND Field3<>"Z" Then "C"
Else
If Field1="Z" AND Field2="Z" AND Field3="Z" AND Field4<>"Z" Then "D"
Is this possible within Designer? It's built off SAP BW. If not, what would be the best way to go about it.Thanks.