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 February, 2012

OBIEE11g – Table View

Posted by Santosh Kumar Gidadmani on February 28, 2012

Let us understand different Analysis (Answers) Views in OBIEE11g. There will be series of post on different Views in OBIEE11g Analysis (Answers).

How to Create a Simple Table View
New > Analysis > Subject Area
This will take you to the analysis criteria section. This section contains three sub sections, subject area, selected columns, and filters.

Select the required columns from the subject area and click on results. This will create the default table View in compound layout.

Important features: Schedule Agent, Table View Properties, Create Compound layout etc.
Click on the Edit Title view and provide required details, like report title, sub title, report run date, logo etc.

Click on the Edit Table View to edit table view layout.

On the table view edit section, rearrange the columns as per the report need. You can create prompt section and exclude columns from the table view.

Above is the Table View property. Paging Controls: Where you want to place the paging controls, by default it will be at bottom, you can change it onto top. Rows Per Page: By Default only 25 rows it will display, you can change it. Enable alternative row green colour etc.

– Santosh

Posted in OBIEE 11g, OBIEE 11g Analysis | Leave a Comment »

OBIEE11g Error – Unable to Obtain Lock on Adminserver.lok

Posted by Santosh Kumar Gidadmani on February 13, 2012

If you are getting the below error when starting the OBIEE11g service.
“Unable to obtain lock on adminserver.lok”

This could be because of two reasons, Weblogic server is already running or Weblogic server did not stop correctly.
When Weblogic server starts, it automatically creates a file called AdminServer.lok under the below path folder


How to fix it:
1. Stop the OBIEE11g Services.
2. Go to the above tmp folder and delete the file “AdminServer.lok”
3. Start the OBIEE11g service.

The Weblogic server will work now.

– Santosh

Posted in OBIEE 11g Errors | 3 Comments »

%d bloggers like this: