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 MoreThe Layout Editor First, you have to choose a predefined layout from the Create Report Interface. As you can see in the following screenshot, this interface displays a list of predefined layouts: You can add your own predefined layouts to this list and make them available for your...
Read More
[embeddoc url="http://ids-sol.co.uk/wp-content/uploads/2016/12/Advanced-RTF-Template-Techniques.pdf" download="all"]...
Read MoreMicrosoft SQL Server 2008 Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting you design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases....
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