Unauthorized Access: Either you do not have the privilege, or you have not signed in.

While getting started with Oracle BI Publisher, you may face this problem saying
"Unauthorized Access: Either you do not have the privilege, or you have not signed in." even if you have logged in as weblogic user.

This is because, the weblogic user is not having permission to access root folders bisystemuser and My Folders. So, we are modifying the permission of those folders as below.

1. Stop all BI Services.
2. Open Catalog Manager in offline mode.
3. Select User Folders.
4. Right click on bisystemuser  and give full control to weblogic user.
5. Right click on My Folders and give full control to weblogic user.
6. Restart the BI Services.
7. You are the in to BI Publisher.

Unable to select Connection pool when creating init block in OBIEE 11g

Problem:
In Administration Tool, when i tried to create an Initialization Block, I found I couldn't select the connection pool option, is disabled.

Note:
By default, the first connection pool under the database object in the Physical layer is not available for selection. This behavior ensures that you cannot use the same connection pool for initialization blocks that you use for queries.

Good Practice:
Make sure that, every time you import new connection, you have duplicated connection pool dedicated to use in initialization block.

Solution:
1. Open Admin Tool,
2. Go to Tool > Options
3. On the General tab, select "Allow First Connection for Init Blocks"
4. Select Ok.
5. Save changes you have made.
6. You are ready to deal with Initialization Blocks.

Happy stay.. :-)
Sagar Tippe

Limiting number of rows to display per page while exporting the report in OBIEE 11g

Hi,
While using OBIEE v11.1.1.7. In Analysis, you may need to set the row limit per page to 25 but while exporting it to pdf or Excel, its displaying more than 25 records per page.

How to set the row limit per page, while exporting the report?

Go to,
EM > Capacity Management > Performance.
Here, you can set,

User Session Expiry,
Maximum Number of Rows Processed when Rendering a Table View,,
Maximum Number of Rows to Download,
Maximum Number of Rows Per Page to Include

Set the values as per your choice, apply the changes. Activate changes and Restart the BI services.

You are done..!! :-)

nQSErrors: Cause and Actions

Hi intelligent folks......

I always wondered with every nQSError i have faced soo far.. Every time i need to ask for solutions to our most favorite GOOGLE uncle.. But we are independent now. ;-)
Yes, here's the link from Oracle Corporation, to list out every possible error that can occur while dealing with Siebel Analytics.

Please have your own copy of this all-in-one doc.
http://download.oracle.com/otndocs/products/bi/bi-ee/docs/784/AnyMsg.pdf

Happy blogging. :-)

Different Logging levels in OBIEE 11g

Logging Level	Logging Level Information
Level 0	No Logging
Level 1	Logs everything logged in Le Logs everything logged in Level 1. Additionally, for each query, Logs the repository name, business model name, presentation catalog name which is called as Subject Area in Answers. Logs the SQL for the queries issued against physical databases. Logs the queries issued against the cache. Logs the number of rows returned from each query against a physical database and from queries issued against the cache, and the number of rows returned to the client application
Level 2	Logs everything logged in Level 1. Additionally, for each query, Logs the repository name, business model name, presentation catalog name which is called as Subject Area in Answers. Logs the SQL for the queries issued against physical databases. Logs the queries issued against the cache. Logs the number of rows returned from each query against a physical database and from queries issued against the cache, and the number of rows returned to the client application
Level 3	Logs everything logged in Level 2 Additionally, Adds a log entry for the logical query plan, when a query that was supposed to seed the cache was not inserted into the cache, when existing cache entries are purged to make room for the current query, and when the attempt to update the exact match hit detector fails
Level 4	Logs everything that logged in level 3. In addition to this, logs query execution level.
Level 5	Logs everything logged in Level 2. Additionally, logs intermediate row counts at various points in the execution plan.
Level 6 & 7	For future use

Oracle Business Intelligence Virtual Boxes in Online too..

Its a Great News for beginners of OBIEE Consultants and developers too.. 

Oracle is providing Oracle Business Intelligence Virtual Boxes in Online also..

The Sample Application (SampleApp) for Oracle Business Intelligence Suite Enterprise Edition Plus (EE) is a comprehensive collection of examples designed to demonstrate Oracle BI capabilities and design best practices.

It brings together several integrated Oracle BI products & technologies and illustrates how they can seamlessly work together in solving functional problems. These examples include latest OBIEE 11g functionalities (enhanced visualizations, Action Framework, BI Publisher, Scorecards, Mobile) and also OBIEE core architecture examples (Semantic layer modeling, Multi-source federation, Integration with products such as Endeca, Essbase, ORE, Oracle OLAP, ODM, TimesTen, and more).

Disclaimer: The SampleApp contents and its code are distributed free for demonstrative purposes only. It is neither maintained nor supported by Oracle as a licensed product.


OBI EE 11.1.1.7.1 Samples Application Index
http://slc02okm.oracle.com:7780/analytics/saw.dll?BIEEHome&startPage=1

OBI EE 11.1.1.7.0 Samples Application Index:
http://slc02ojq.oracle.com:7780/analytics/saw.dll?bieehome&startPage=1