Home » Fusion Middleware & Colab Suite » Business Intelligence » How to add New blank Column in OBIEE (10 G)
How to add New blank Column in OBIEE [message #319631] Mon, 12 May 2008 07:04 Go to next message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member

Hi

I am new to OBIEE . please tell how to add new column and formula to thish column in OBIEE.


Column1 Column2 Column3(Column1*Column2)
1 1 1
2 2 4
3 3 9


Regards
Sunil Kumar Gond
Re: How to add New blank Column in OBIEE [message #321184 is a reply to message #319631] Mon, 19 May 2008 06:23 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Add one of the columns-to-be-used-in-the-calculation once again, go to calculation and edit it there to include the other column in the equation.
Re: How to add New blank Column in OBIEE [message #321212 is a reply to message #321184] Mon, 19 May 2008 08:01 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
In PM:

Quote:
Hi

Thanks for reply. is there any process to add new row .

Is it necessary to reuse the column.


(next time please post your answer here and not in a PM, so others can benefit from it too).

Yes, it is necessary to reuse a column. However, you need the column for your calculation anyway, so it's just a variation on a button "add column", instead you use an existing one.

And no, you can not add an empty/new row, unless you do something like 'select ' ' from dual in a direct SQL and combine that with the existing request.

However, I see the need for a calculation, but why whould you need a new row?
Re: How to add New blank Column in OBIEE [message #321970 is a reply to message #321212] Wed, 21 May 2008 23:47 Go to previous messageGo to next message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member

Hi
Thanks for reply

My require ment is:

There are 2 row in my request A and B
And i want A/B in new row
so it should be
A
B
c
Re: How to add New blank Column in OBIEE [message #322019 is a reply to message #321970] Thu, 22 May 2008 03:12 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Sorry, I don't understand your requirments. Could you please try to explain it again in other words? Preferably with an example on what you currently have. And by the way, where is C coming from in your example output?
icon7.gif  Re: How to add New blank Column in OBIEE [message #361292 is a reply to message #319631] Tue, 25 November 2008 14:17 Go to previous message
monica365
Messages: 6
Registered: November 2008
Location: Argentina
Junior Member

You can add a new field from the left pane, edit the formula and write A/B.

Check Customs Headings option and put the name C.

Regards,
Monica
Previous Topic: XML Publisher : XSL:FO
Next Topic: How to use Procedure and function in OBIEE
Goto Forum:
  


Current Time: Tue Nov 26 22:03:28 CST 2024