Business Intelligence

Informatica being replaced by ODI in Oracle BI Apps 7.9.5.2

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

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
Share

In secondary cluster node systems and versions before 11.1.1.5 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 11.1.1.6.0 is Generally Available!

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

(English) 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
Share

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

Warning: 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
Share

(English) 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 (spanish)

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

Spanish

Como modificar el valor de una variable de sesion globalmente

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

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 11.1.1.5.0

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

List of Bug Fixes Included In Oracle BI Publisher 11.1.1.5.0The following is a list of all bug fixes included in Oracle BI Publisher 11.1.1.5.0, 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
Share

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

Installing the Oracle Business Intelligence 11g (11.1.1.5) Client Tools

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

Overview This is a brief installation guide for those currently working on their 11.1.1.5 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
Share

After reading this post you should be able to configure the boot.properties 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 boot.properties file

Nota de Interes: Oracle anuncia version 11.1.1.5 de OBIEE

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

Oracle anuncia un adaptador BAPI con conectividad nativa a SAP BW, adicionalmente OBIEE 11.1.1.5 permite a usuarios de iPad e iPhone consumir dashboards y reportes facil e intuitivamente

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

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

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
Share

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
Share

“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
Share

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
Share

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
Share

(English) 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
Share

Peoplesoft EPM ETL Configuration