Event 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 MoreWhere You Are Now OBIEE 12c has been out for some time, and it seems like most folks are delaying upgrading to OBIEE 12c until the very last minute. Or at least until Oracle decides to put out another major version change of OBIEE, which is understandable. You've...
Read MoreI 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 More