How to get multiple hard coded values in a report column

Chandra kanth

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.

cesar.advincula.o

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.

Chandra kanth

Hi,

Please let me know how to write a query to get two values.

regards,

CK

cesar.advincula.o

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,

[Deleted User]

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.