Business Intelligence

Informatica being replaced by ODI in Oracle BI Apps

Posted by on August 1, 2013 at 6:00 pm

In a long anticipated move among both Fusion Intelligence and Oracle BI Apps customers, Oracle has released the first versions of its packaged business intelligence solution that replaces the third party tools of previous versions (IBM DataStage or Informatica Power Center) with Oracle Data Integrator as the back end ETL tool. You can find detailed […]

How to launch OBIEE Catalog Manager in 11g

Posted by on March 15, 2012 at 3:30 am

In secondary cluster node systems and versions before a shortcut to the OBIEE Catalog Manager was not created by the install utility, when running on a Windows Box you can easily solve this by running the runcat.cmd file on the Catalog Manager Path: <Middleware Home>\instances\instance<Instance Number>\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager An example of the this path on a […]

Oracle Business Intelligence is Generally Available!

Posted by on February 23, 2012 at 5:29 pm

Features include prompt autocomplete, optional apply button, favorites, full text search, and enhancements to: Mapview, Selections, Views, Scorecard and Strategy Managemnet….

Workaround: OBIEE compatibility issue with Firefox 10

Posted by on February 6, 2012 at 2:00 am

This work around is related to my previous post on OBIEE error: “Your browser is not supported by Oracle BI Presentation Services”

OBIEE error: “Your browser is not supported by Oracle BI Presentation Services” being triggered by automatic update to Firefox 10

Posted by on February 2, 2012 at 11:41 am

OBIEE is not compatible with Firefox 10 which is being rolled out to user desktop computers through automatic updates…

11g Bug: Issue with equality operator on content filters

Posted by on November 21, 2011 at 12:02 pm

I ran into an weird issue yesterday trying to troubleshoot data security for my current gig. What it came down to is the fact that for some reason the equality operator in the expression below wasn’t being resolved correctly by OBI: LOWER( TRIM(“Data Warehouse”.””.”SCHEMA_NAME”.”ALS_BI_SEC_USER_DEPT”.”EMAIL_ADDRESS”)) = ( LOWER( TRIM( VALUEOF(NQ_SESSION.”USER”)))) Even after toying with :USER, applying […]

Changing the value of a session variable at the session level

Posted by on November 12, 2011 at 4:03 pm

I recently needed to update the value of a session variable beyond a prompt’s scope, I played a bit with the NQSSetSessionValue() ODBC function

List of Bug Fixes Included In Oracle BI Publisher

Posted by on October 31, 2011 at 4:14 pm

List of Bug Fixes Included In Oracle BI Publisher following is a list of all bug fixes included in Oracle BI Publisher, grouped by type: Administration (ADMIN) * Bug 9381019 XMLP ROLES NOT HONORED WITH SSO ENABLED FOR AD SYNCHED USERS. * Bug 9934771 UNABLE TO LOGON TO PUBLISHER USING SECURITY MODEL EBS: […]

Troubleshoting Error: unable to get file lock, will retry …

Posted by on July 21, 2011 at 4:00 am

Troubleshooting error BEA-141281 unable to get file lock, will retry …

Installing the Oracle Business Intelligence 11g ( Client Tools

Posted by on May 30, 2011 at 8:00 am

Overview This is a brief installation guide for those currently working on their OBIEE installation. Please post commnents if you have any questions or run into issues installing OBIEE 11g, we will try to fix them and can document their resolution for future reference. Pre-requisites Download the installer from OTN to your windows machine […]

Configuring WebLogic Automated Startup Credentials

Posted by on May 26, 2011 at 2:00 pm

After reading this post you should be able to configure the file to provide the WebLogic server with startup credentials, a necessary step when configuring the server for automated startup …The WebLogic server does not start automatically, it is prompting for a user name and password    WebLogic not reading file

Commentary: Oracle releases OBIEE

Posted by on May 10, 2011 at 7:10 pm

Oracle releases native SAP BW BAPI adapter and iPad/iPhone support in release of OBIEE

Linux Environment variables to simplify your life – OBIEE 11g System Administrator Edition

Posted by on April 19, 2011 at 7:18 pm

As I spend a lot of time switching between a very well defined set of directories in the Oracle Middleware home for OBIEE 11g I have been developing a list of variables that I like to use in my scripts and configure in the servers that I most commonly work with. They have proven to […]

OBIEE Repository Reporting

Posted by on December 25, 2010 at 6:00 pm

Extracting lists of OBI repository objects

Issues with DB Connection when creating the Informatica Power Center Repository

Posted by on October 22, 2010 at 5:30 pm

“An Exception has occurred. The database connection detail for service INFA_REPO_SVC are invalid. Please check log for details”

PeopleSoft EPM Dimension NULL records

Posted by on June 11, 2010 at 6:00 pm

How to handle cases where configuration tables like PS_GVT_POI_TBL or other feature sets that don’t apply to your company are not being implemented. In many cases complete dimensions will be empty and look-ups in fact jobs will fail.

PeopleSoft Enterprise Performance Management Warehouse Schema Naming Standards

Posted by on June 2, 2010 at 6:00 pm

The nicest thing about PeopleSoft after the whole PIA Metadata-driven interface and its impact on data quality is how meticulous PeopleSoft engineers are about documentation and sticking to naming standards, here’s a simplified diagram of the wharehouse architecture and the naming standard for objects in each section of the schema:

Leverage PeopleSoft EPM Data Lineage Spreadsheets

Posted by on February 28, 2010 at 6:00 pm

Not having to do all the leg work necessary to arrive at table-level data lineage in the PeopleSoft EPM Warehouse is a great testimony to good documentation and a great culture back there at big PS….

Don’t go too fast about rolling out your EPM 9.0 OWS jobs if your source system is HCM 9.0

Posted by on January 10, 2010 at 6:00 pm

Peoplesoft EPM ETL Configuration