You are here: Blog
Cache is the most important feature used for obtaining an optimized report and dashboard performance. However when managed poorly, it might lead to stale data appearing in reports. Hence cache must be purged at intervals based on the right perception. E.g. cache must be deleted after ETL has completed the…
NOTE: This exercise must be done on rpd’s which are deployed with the BI server is running  Aggregate persistence is used to automate the creation and initial population of aggregate tables, persist them in backend datawarehouse schema and configures the rpd file to use them wherever its appropriate.  This is…
In this blog I am going to explain how to generate Table of Contents with links to their respective page in RTF template dynamically. BI Publisher provides the ability to create dynamic section headings in your document from the XML data. You can then incorporate these into a Table of…
In this blog I am going to explain how we can use links in BIP report to open another BIP report with dynamic values. For example: Report1: In this report we have purchase details of goods in all states in a country. Report2: Displays City level purchase details for a…
Using some arithmetic along with the mod() and floor() functions, you can calculate the quarter of a fiscal year based on a given date. The calculation we will use assumes that the fiscal year begins on the first of the month, and not some other day. We will first demonstrate this for a fiscal…
As we display the measures as columns in a table, we can also modify this display structure in output to display these measure columns as rows. Consider below XML <GROUP_PERCENTAGE>     <PERCENTAGE>                 <DEPARTMENT>CSE</DEPARTMENT>                 <CRETERIA>PASSPERCENTAGE</CRETERIA>     …
Objective: Demonstration of Relational and URL Based Drill through Reports using Essbase Studio Tool [11.1.2.1] with the presumption that the reader having basic understanding on Essbase Studio Tool Overview of Drill-Through Reports Creating Relational Based Drill-Through Reports Displaying the results using Smart-View Tool Creating URL Based Drill-Through Reports    …
Objective: Import the Essbase Cube Data from Essbase Administration services console (EAS) to OBIEE and generate the dashboards with the presumption that the reader having basic understanding on Hyperion and OBIEE Tools 1. Overview of Essbase and OBIEE Integration 2. Create a Essbase Datasource into Repository 3. Create Business Model…
Page 4 of 8