Home > OBIEE, Oracle > Variables in Oracle OBIEE 11g

Variables in Oracle OBIEE 11g

Variables in Oracle OBIEE 11g

There are basically 4 different types of variables in OBIEE 11g.

  1. Session Variables
  2. Repository Variables
  3. Presentation Variables
  4. Request Variables.

Session Variables:

  1. As the name suggests, session variables are created during the creation of session i.e., as soon as a user logs into the BI server.  So, Every login has its own session variable.
  2. There are two types of session variables
    1.  System (which are defined by OBIEE and are reserved)
    2. Non-System which are defined by developers.
    3. Session Variables can be created only through Oracle BI Administration Tool.

Referencing session variable:

For displaying session variables, we should use @{biServer.variables['NQ_SESSION.VariableName']} .

For using session variables in expression, we should use VALUEOF(NQ_SESSION.“VariableName”).

Repository Variables:

  1.  A repository variable is a variable that has a single value at any point in time.
  2. There are two types of repository variables
    1. Static (which changes only if admin or developer changes it value)
    2. Dynamic ( value is refreshed using a query)
    3. Repository variables can be created only through Oracle BI Administration Tool.

Referencing repository variable:

For displaying repository variables, we should use @{biServer.variables.VariableName} or @{biServer.variables['VariableName']}.

For using repository variables in expression, we should use VALUEOF(“VariableName”) for static variable and for dynamic variable VALUEOF(“Dynamic Initialization Block Name”.“VariableName”).

Presentation Variable:

  1. A presentation variable is a variable which can be created as a part of creation of dashboard prompts. Dashboard prompts must be either Column Prompt or Variable Prompt.
  2. The value of presentation variable is set by the prompt for which it is created (upon user selection).

Referencing presentation variable:

For displaying presentation variables, we should use either

  1. @{variables.VariableName}[Format]{DefaultValue}  or
    1. Format and DefaultValue are optional
    2. Format is useful to format the data for e.g., for Date, format can be MM/DD/YYYY. Note: Default Value is not formatted.
    3. @{scope.variables['VariableName']}.
      1. Scope should be used if you create variables with same name.
      2. Scope can be analyses, dashboard etc.
      3. Order of precedence is analyses, dashboard pages, dashboards.

For using presentation variables in expression, we should use @{“VariableName”}{DefaultValue}. Default value is optional.

Request Variable:

  1. Request Variable is used to overwrite the value of session variable and it happens only during request initiation to the database from column prompt.
  2. Can be created only during the creation of column prompt.

Referencing request variable:

Same as presentation variable.

 

References:

Please refer to Oracle site for more details.

About these ads
  1. June 22, 2012 at 9:53 am | #1

    Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. WordPress Seo Plugin

  2. June 30, 2012 at 5:32 am | #2

    Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. WordPress Seo Plugin

  3. Galo Escob
    November 8, 2012 at 1:40 pm | #3

    Hello.
    I need show/print “is prompted” values in subreport/subanalysis.

    Any idea please ?

  4. OBIEE Consultant
    December 23, 2013 at 7:10 am | #4

    I want to show in my column title as @{PROMPT_YEAR}-1 , one year minus from the promt, but it is not evaluating the expression in column header title. what should i do.

  1. No trackbacks yet.

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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: