OraFAQ Forum: Business Intelligence

Home » Fusion Middleware & Colab Suite » Business Intelligence » Variables in OBIEE

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

Variables in OBIEE [message #313186]

Fri, 11 April 2008 00:36

amritaseema
Messages: 47
Registered: January 2008

Member

Hi All,
I m new to OBIEE,Can any one please give me a clear description about the different types of variables and the uses.
particularly i want to know about Presentation varibale,the uses and how to use it in dasbord.
Can any one explain these,if possible with any example then it will be helpfull for me.

Thanks in advance

Seema.

[Updated on: Fri, 11 April 2008 00:37]

Report message to a moderator

Re: Variables in OBIEE [message #313197 is a reply to message #313186]

Fri, 11 April 2008 01:14

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

That's a bit too much to explain on a forum. Did you check the documentation?

[Updated on: Fri, 11 April 2008 01:16]

Report message to a moderator

Re: Variables in OBIEE [message #313202 is a reply to message #313197]

Fri, 11 April 2008 01:19

amritaseema
Messages: 47
Registered: January 2008

Member

Hi,
I Checked bt i m not getting and confused also.
If u have time then plzz help me out.

Thanks
Seema

Report message to a moderator

Re: Variables in OBIEE [message #313207 is a reply to message #313202]

Fri, 11 April 2008 01:27

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Perhaps you could share with us what you found confusing? I mean, I can copy/paste the whole documentation text here, but that doesn't make much sense, does it?

Report message to a moderator

Re: Variables in OBIEE [message #313219 is a reply to message #313207]

Fri, 11 April 2008 01:56

amritaseema
Messages: 47
Registered: January 2008

Member

Actually i am new to OBIEE because of that i am confused.
Can u plzz give me the breif description in your own words regarding the varibales in OBIEE.
As far as i knw "Presentation variable defined in the presentation layer and their scope is within the dashbord"
Bt i am nt getting how to create the presentation variable in Presentation layer.can u please tell me the steps to create it.

Thanks in advance

Seema

Report message to a moderator

Re: Variables in OBIEE [message #313225 is a reply to message #313219]

Fri, 11 April 2008 02:25

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Perhaps this blog entry can help you:
http://majendi.blogspot.com/2007/07/catching-up.html

Another good example of the use of presentation variables:
http://oraclebizint.wordpress.com/2008/02/21/oracle-bi-ee-101332-presentation-variables-in-top-filter/

PS could you please write in plain, full English next time? IM speak like 'u', 'plzz' etc, is hard to understand for non-native English readers (like me).

[Updated on: Fri, 11 April 2008 02:26]

Report message to a moderator

Re: Variables in OBIEE [message #437163 is a reply to message #313186]

Thu, 31 December 2009 06:59

usman.fawad
Messages: 1
Registered: December 2007
Location: lahore

Junior Member

Respectable!

I am new to OBIEE. It becomes a challenge for me to pass variables from dashboard prompts and to catch their value in Answer's Request.

I would like to illustrate it with an example.
Request based on the following SQL statement

Select NAME, AGE, CITY, ADDRESS
From emp
Where DOB = '@{p_date}'

Now DOB is in TIMESTAMP format,
it looks like '11/1/2009 12:00:00 AM'.

Dash board Prompt also depends upon the same column and have also same TIMESTAMP format.

In next step
I created a dashboard page
Place prompt and report there
Saved the dashboard
Now I select a date from prompt list and press go button
It shows no result.

I tried several combinations in @{variable_name} syntax e.g.

Where DOB = '@{p_date}'
Where DOB = '@{p_date}{1-nov-2009} '
Where DOB = cast(to_char(@{p_date}, 'dd-mmm-yyyy') as date)
.........................
And many other combinations

I am looking for any help/tips in this regard

Thanking in anticipation

Usman Fawad

Report message to a moderator

Re: Variables in OBIEE [message #445425 is a reply to message #313186]

Mon, 01 March 2010 16:06

SatishkGoud
Messages: 6
Registered: March 2010
Location: USA

Junior Member

Seema

Did you get any good doc on this ....

Thank YOu
satish

Report message to a moderator

Re: Variables in OBIEE [message #450564 is a reply to message #313225]

Thu, 08 April 2010 00:05

intcor
Messages: 20
Registered: April 2010

Junior Member

may be instead of using presentation variables , try using repository variables for date .

Report message to a moderator

Re: Variables in OBIEE [message #472331 is a reply to message #450564]

Thu, 19 August 2010 23:57

ramktp
Messages: 1
Registered: August 2010
Location: Bangalore

Junior Member

Hi,

can u please let me know what is the diff b/w siebelanalytics and obiee.

Report message to a moderator

Re: Variables in OBIEE [message #472877 is a reply to message #472331]

Tue, 24 August 2010 09:53

heedtheball
Messages: 6
Registered: August 2010

Junior Member

A company called NQuire created the application back in teh late 90s. It was originally designed around Ralph Kimballs ideas of Data Warehousing and was originally designed to be used with a database application known as Siebel, although it could use various data sources.

In the early 00s Siebel purchased the product from NQuire, but you will notice lots of traces of its original routes such as NQServer.log etc. At this point it became called Siebel Analytics.

In the mid 00s Oracle puchased Siebel as the centre piece of its CRM offering to become central to Oracle Fusion. They didn't realise that they also acquired Siebel Analytics with it, which has proven a stroke of luck. They have relabelled it Oracle Business Intelligence.

You can buy the platform which allows you to build a datawarehouse and on top of that you can buy BI Apps which provides out of the box solutions for both Siebel Apps and Oracle Apps (now).

In summary they are both the same thing Surprised

)

John Lamont Watson
Business Decision Systems

Report message to a moderator

Previous Topic:	Installation of OBIEE in Unix hangs and don't complete
Next Topic:	obiee startup and shutdown

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 18:20:51 CST 2025