I recently received a requirement to produce XLS output for one of the custom reports at a client.Initially I had difficulty in designing the report, but realized it was actually easy after a bit of research and trial and error. I want to share my...
Read More
[embeddoc url="http://ids-sol.co.uk/wp-content/uploads/2016/12/Advanced-RTF-Template-Techniques.pdf" download="all"]...
Read More
Usage Tracking in OBIEE 11.1.1.7.0 (11g) Why Usage Tracking: Usage Tracking is used to monitor system and ad-hoc query performance and to provide input on usage trends for use in billing users and departments for resources. Usage tracking is particularly useful in determining user queries that are...
Read More
1. RPD Editing Mode [supsystic-tables id='3'] 1.1. Modifying the Oracle BI Repository You can modify and extend the Oracle BI repository (RPD). This section provides information about RPD modification tasks. For some tasks, links to additional documentation are provided. Task: Open the Oracle BI Administration Tool The Oracle BI Administration...
Read MoreI recently was asked by one client the difference between BI Publisher and OBIEE reports. To them, BI Publisher is either a 'different Feature' within OBIEE, or it's a completely different Application who competes with OBIEE in 'reporting business'. BIP BI Publisher was originally a different application,...
Read More
1. SET WEBLOGIC LDAP Log on to the WebLogic Console as the weblogic adminsitrator account: http://[BI SERVER]:7001/console Navigate to the following screen “Security Realms > myRealm”: Click on the “Providers” tab and then click on the “Lock and Edit” button: Click on the link for “DefaultAuthenticator”: Set the...
Read More
1. Oracle BI Server Query Cache Configure the Oracle BI Server to maintain a local, disk-based cache of query result sets (query cache). The query cache enables the Oracle BI Server to satisfy many subsequent query requests without accessing back-end data sources, thereby increasing query performance. As...
Read More
Create Audit Schema with RCU Here are the steps: Go to $RCU_HOME/bin and execute the ‘rcu’ command Choose Create at the starting screen and click Next. Enter your database details and click Next. Choose the option to create a new prefix, for example ‘BIP’, ‘KAN’, etc. ...
Read More
1. Please follow instructions given in How to fix “Unable to Sign in. An error occured during Authentication" error when a user logs in OBIEE 11g (Doc ID 1302924.1) step by step, for those steps you have done, please double check and make sure what you've...
Read MoreOVERVIEW Apache Hadoop is an open source software platform for distributed storage and distributed processing of very large data sets on computer clusters built from commodity hardware. Hadoop services provide for data storage, data processing, data access, data governance, security, and operations. A BRIEF HISTORY AND BENEFITS HISTORY The...
Read More