One of the main problems of Narrative is the lack of drill options, what is called now "Navigate to BI Content". On the other hand, it can be easily achieved using basic scripts and GO URL. I will do a basic example, for more detail on...
Read MoreThere will come a point in the lifecycle of an OBIEE deployment when one user will need to access another user’s account. This may be to cover whilst a colleague is on leave, or a support staff trying to reproduce a reported error. Password sharing aside,...
Read MoreBursting 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
[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 More