OraFAQ Forum: Business Intelligence » Create a dummy (blank) column in OBIEE

Home » Fusion Middleware & Colab Suite » Business Intelligence » Create a dummy (blank) column in OBIEE (OBIEE 10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	OBIEE 12c URL of WebLogic Console is not working
Next Topic:	CLEAR Button in OBIEE12c

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 12:07:31 CST 2024