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 […]
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 […]
(English) Features include prompt autocomplete, optional apply button, favorites, full text search, and enhancements to: Mapview, Selections, Views, Scorecard and Strategy Managemnet….
(English) This work around is related to my previous post on OBIEE error: “Your browser is not supported by Oracle BI Presentation Services”
(English) OBIEE is not compatible with Firefox 10 which is being rolled out to user desktop computers through automatic updates…
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.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: […]
(English) Troubleshooting error BEA-141281 unable to get file lock, will retry …
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 […]
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
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
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 […]
Extracting lists of OBI repository objects
“An Exception has occurred. The database connection detail for service INFA_REPO_SVC are invalid. Please check log for details”
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.
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:
(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….
Peoplesoft EPM ETL Configuration