Home » Fusion Middleware & Colab Suite » Business Intelligence » Create a dummy (blank) column in OBIEE (OBIEE 10G)
Create a dummy (blank) column in OBIEE [message #670662] Tue, 17 July 2018 22:34
ayla
Messages: 1
Registered: July 2018
Junior Member
Hi experts,

Need help on creating a dummy (blank) column in OBIEE 10g, this works in OBIEE 11g based on this link. bifuture.com/create-a-dummy-blank-column-in-obiee

I need to union two set of records with the same subject area. Basically i used filter, into this two policy number V12345 and V23467 . It is confirm that benefits has a varchar(30) data type and total premium has a double data type.
Below are what i tested but it doesn't work.

Trial 1 :
Policy No. | Benefits | Total Premium
UNION
Policy No. | '' | 0


Trial 2 :
Policy No. | Benefits | Total Premium
UNION
Policy No. | CAST(NULL as VARCHAR(30)) | 0


Expected Results:

Policy No. | Benefits | Total Premium
V12345 | Breakage in W/Screen | 252.00
V23467 | | 0.00

Please assist. how could i produce the expected result in OBIEE 10g.

Appreciate your hints and assistance.
Thank you in advance
Previous Topic: OBIEE 12c URL of WebLogic Console is not working
Next Topic: OBIEE12c_Syetem Session Variable EMAIL not seen
Goto Forum:
  


Current Time: Sat Dec 14 18:09:46 CST 2019