Showing posts with label BI Publisher. Show all posts
Showing posts with label BI Publisher. Show all posts

Sunday, 5 February 2017

Difference between OBIEE and BI Publisher?

If you have OBIEE Suite licence, BI Publisher comes along with the suite as a package. Whereas, you can purchase BI Publisher's licence alone with minimal cost than OBIEE Suite. To consider this, below are the basic differences between two of the Oracle's reporting tools. When your reports are more pixel oriented then BIP is preferable whereas if you are looking more for analytics, graphs, interactive reports, dashboards, etc. then OBIEE is preferable.
Some of more basic differences are as,

OBIEE
OBIEE
For canned and ad-hoc reports
For canned reports only
Fully interactive
Non-interactive unless integrated with OBIEE
Not meant for a real time reporting
Meant for real time reporting
More for trends, analytics, dashboards, etc.
Mainly for fixed format, pixel perfect reports
Drill down is possible
Drill down is not possible
Need DWH/OLAP
OLTP is also preferable

Happy bloggin.. :-)

Wednesday, 26 February 2014

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.