Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘Session Variables’ Category


Posted by Santosh Kumar Gidadmani on November 12, 2010

It identifies the default dashboard the user sees when logging in (the user can override this preference after logged on here: Settings → My Account → Preferences → “Default Dashboard”).

Steps to create PORTALPATH system session variable

Find the path of the dashboard where you want to default it for every user.

You can find it in Oracle Business Intelligence – Catalog Manager

Open in online mode, provide the answer URL path

Provide the Administrator user and password

The catalog will open the current catalog folder list.

Navigate to shared folder, open the dashboard folder group and open the dashboard page which you want to default the page.

Copy the path above

Create a system session variable with initialization like below

Give the statement as select ‘/shared/India/_portal/Santosh_New’ from dual

Single quote is mandatory.

Create the variable target as PORTALPATH (can’t give any other name as it is reserved)

Test it

Save and close the Admin tool

Logon to Answers (presentation services) with any users, the default page will open as given in the variable.

The users can change it on the settings – my account to set any default page.

– Santosh

Posted in OBIEE 10g, OBIEE 10g RPD, Session Variables | Tagged: | 2 Comments »

%d bloggers like this: