August 1, 2013
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 […]
Tags: BI Apps, Informatica, ODI, Product Review
Posted in Business Intelligence, E-Business Suite, ETL, Featured, Fusion Intelligence, Oracle BI Apps, Oracle Data Integrator (ODI) |
November 21, 2011
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 […]
Tags: bug, content filter, data security, equal, in, OBIEE 11g, row level security
Posted in Business Intelligence, OBIEE, Technical, Tips, Troubleshooting |
November 12, 2011
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
Tags: linkedin, NQSSetSessionValue, OBIEE 11g, presentation, prompt, Repository, scope, session, variable
Posted in Business Intelligence |
July 21, 2011
Troubleshooting error BEA-141281 unable to get file lock, will retry …
Tags: BEA-141281, Error, troubleshoting
Posted in Business Intelligence, Featured, Infrastructure, Technical, Uncategorized |
June 9, 2011
After reading this post you should be better prepared to smoothly export and import Linux virtual machines from your Oracle Virtual Box servers by being ready to correct any disk device reference issues in fstab and grub.conf
Tags: install, Linux, openSUSE, SuSE, Unix, Virtualization, Virtual_Appliances, Virtual_Machines
Posted in Featured, Infrastructure, Install and Configuration, Technical, UNIX/Linux |
May 26, 2011
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
Tags: install, OBIEE, OBIEE 11g, sysadmin, troubleshooting, WebLogic, WLS
Posted in Featured, Fusion Intelligence, OBIEE, Technical |
November 14, 2010
Create some basic variables in your OBIEEE Linux server
Tags: environment, Linux, OBIEE, variables
Posted in Featured, OBIEE, Tips, UNIX/Linux |
October 22, 2010
“An Exception has occurred. The database connection detail for service INFA_REPO_SVC are invalid. Please check log for details”
Tags: Informatica, install, install_biapps, install_infa, Power Center
Posted in Informatica PowerCenter, Oracle BI Apps, Oracle Database, Technical |
Shangye Zhineng RSS Feed