RSS

Oracle BI EE Variables Overview

02 Oct

Hi all,
Now it is possible to use all types of variables in the title.It has been acknowledged as a defect with bug no.:6019292.The effective solution they have provided is as follows:
For session variables:
@{biServer.variables[‘NQ_SESSION.variablename’]}

For repository variables:
@{biServer.variables[‘variablename’]}

For your reference this is the overview of OBIEE Variables Chart:(From http://siebel-essentials.blogspot.com/2008/09/oracle-bi-ee-variables.html))

 

 

Advertisements
 
19 Comments

Posted by on October 2, 2008 in OBI EE

 

19 responses to “Oracle BI EE Variables Overview

  1. Dhaduvai

    October 4, 2008 at 11:00 pm

    Shiva,
    Very useful post. Thanks for this overview. I had a lot of questions on OBIEE variables which have been answered with this overview.

    Regards,
    Dhaduvai

     
  2. Rajat

    October 22, 2008 at 8:48 pm

    Shiva,

    How did you get the demo2 user assigned to region “East”.

    Reply
    Rajat

     
  3. Shiva Molabanti

    October 23, 2008 at 11:00 am

    Rajat,
    Use datalevel security concept for your Region table.

    Thanks
    Shiva

     
  4. Geoff Smith

    January 7, 2009 at 3:50 pm

    If I use @{biServer.variables[‘staticvariablename’]} for a static repository variable in a title field I just get the code used to set the value. A dynamic repository variable displays fine.

     
  5. Rittman borges

    January 22, 2009 at 9:46 pm

    Hi Shiva

    Very good posts

    Shiva can you give us an overview of presentation variables and how to use them in answers
    also if you can share your views on briefing books it will be nice for us.

    Can you also let us know the shared logon feature in connection pooling and why its used

    Looking forward

    Borges

     
  6. Jogesh

    March 25, 2009 at 2:49 pm

    Thanks for the Post.It helped.

    🙂

     
  7. Sethu

    June 16, 2009 at 3:53 pm

    Hi Shiva,

    Thanks for the post, it is useful information.

    There are 2 prompts on a dashboard, the first prompt sets a presentation variable (PV) and the second prompt is populated based on the 1st prompts’ PV value. This is coming up fine, however, we need the default value also to be populated based on the PV value. The version we are using is 10.1.3.3.2. Please suggest a workaround/solution if you have come across this issue.

    Thank you,
    Sethu

     
  8. Senthil

    December 1, 2009 at 7:30 pm

    Hi Shiva,

    I have a requirement where on selecting a value from a drop down (filter) a quivalent unique key (primary key) needs to be used as part of the query used by OBIEE.

    For eg:
    I have Region Names shown as part of drop down (filter).
    Now when the user selects North America, the associated id say 7 has to be used in the query by OBIEE insetead of Select … From .. Where regionName = ‘North America’ it has to use Select … From .. Where regionId = 7.

    Is this achievable in OBIEE? If yes, do help me.

    thanks,
    Senthil

     
  9. Usman

    January 1, 2010 at 2:17 pm

    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 create 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 @1 syntax e.g.

    Where DOB = ‘@{p_date}’
    Where DOB = ‘@{p_date}{1-nov-2009} ’
    Where DOB = cast (@{p_date} as date)
    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

     
  10. Subhash.T

    January 6, 2010 at 12:56 pm

    Hi

    Small Requirement.
    By default in OBIEE we will have Sub Total and Grand Total

    Now I wan to change according to the prompt I want to select.

    i.e, In stead of sub total I want total for that value which ever I select in prompt

    For example: If I select a in prompt then
    Sub total should display like total for a and if i select b it should display total for b and if select both in multi select then I should get both

    how can we achieve that in OBIEE

    Thanks

    Subhash

     
  11. Subhash.T

    January 6, 2010 at 12:57 pm

    Hi

    Small Requirement.
    By default in OBIEE we will have Sub Total and Grand Total

    Now I wan to change according to the prompt I want to select.

    i.e, In stead of sub total I want total for that value which ever I select in prompt

    For example: If I select a in prompt then
    Sub total should display like total for a and if i select b it should display total for b and if select both in multi select then I should get both

    how can we achieve that in OBIEE

    Thanks

    Subhash

     
  12. Lemon

    January 25, 2010 at 11:56 am

    Hi Shiva,

    I was wondering if there is any way to use presentation variables in calculated items in the pivots? I tried using the variables using the syntax @{variable_name} but to no success.

    Hope you can shed some light.

    Thanks,
    Lemon

     
    • Willie

      May 6, 2011 at 1:52 pm

      Hi Lemon,
      I saw your post :

      Posted by Lemon on January 25, 2010 at 11:56 am

      Hi Shiva,

      I was wondering if there is any way to use presentation variables in calculated items in the pivots? I tried using the variables using the syntax @{variable_name} but to no success.

      Hope you can shed some light.

      Thanks,
      Lemon

      …I am wondering if you ever got a solution to this problem as I am also facing this issue.

      Thanks.
      Willie

       
  13. sujithaallada

    January 25, 2010 at 12:11 pm

    hi shiva,

    very glad to meet u..

     
  14. Abdulla Kazim

    May 25, 2010 at 7:03 am

    Shiva,

    I am new to Oracle BI and both the online documentation and the help documents don’t have the right syntax to display the repository variable in the title.
    Your solution helped me.

    Appreciated.

     
  15. SUMAN

    August 19, 2010 at 10:35 am

    hi passing request variable frm dashboard and it go to the RPD and pass this variable value in to our physical query in physical yaar.how it is possible ..plz replay me…

     
  16. ravi

    June 17, 2011 at 7:13 am

    hi
    how can i display my name in column wise
    ex:
    ravi as

    r
    a
    v
    i

     
  17. MuRam

    August 16, 2012 at 5:33 am

    In version-10.1.3.3.1, its not working… Its it something with the version ?

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: