Bursting is a process of splitting data into blocks, generating documents/output for each block and delivering the documents/output to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a key value (e.g....
Read MoreStep 1: In the Administration page, Goto System Maintenance à Scheduler Configuration. In the Scheduler Configuration page that appears, click Test Connection in the Database Connection section to check if the scheduler is configured properly. This should display the following message indicating the connection was successful. Step 2: In the Administration page, Goto DeliveryàEmail. Click on Add Server. Step 3: Select the report...
Read MoreEvent Triggers in BI Publisher 11g give the facility to call a function in Oracle either before or after a data set is refreshed. The function must return a boolean (true/false), and if it returns false the data model will abort execution. In this article I...
Read MoreEvent triggers in BI Publisher allow code to interact with the database at run-time. Typically, they are used to perform any required pre- or post-processing on the data, perhaps checking data is valid, confirming security privileges, setting languages, updating ‘printed’ flags in tables or may...
Read MoreSomething came up this week that I was surprised hadn’t come up before. And I was looking around thinking there must be an obvious way to do this but I couldn’t find it. The idea was to use a single report that could be sent to...
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. 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 MoreInternet of Things (IoT) and Big Data are growing as at astronomical rate and this can open new horizons for business in terms of new business models, products design, intelligent operation and improved customer services - which is why they occupy places at or near...
Read More