Hi,
I am able to write a query using
Case when 1=0 Then "- Product"."Product Type" else ''metallic 123' end
for one value. I am in need of two values ...how to achieve this.
regards,
Chandra kanth.
OBIEE doesnt create "values", OBIEE the objective is to obtain data, not create data, the values coming from Datawarehouse/ data source, if you hope to get two value in that statement that you wrote, OBIEE cant do it.
Please let me know how to write a query to get two values.
CK
Again, you cant in an only one CASE cus OBIEE doesnt create data,
but if you want to force to it, you could:
1. Use both of this, and use UNION ALL.
Kind Regards,
I think we're getting a bit ahead of ourselves here...
@Chandra kanth : WHY do you want that? What's the actual requirement? What are you trying to achieve?
I think there's something else to this and a quick-shot "solution" from the hip might be counter productive.
