How to add New blank Column in OBIEE [message #319631] |
Mon, 12 May 2008 07:04 |
|
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 #321212 is a reply to message #321184] |
Mon, 19 May 2008 08:01 |
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 #322019 is a reply to message #321970] |
Thu, 22 May 2008 03:12 |
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?
|
|
|
|