Tags

bics installation OBIEE obiee 11g installation guide Oracle

Categories

mobile logo

Blog

20
February

Scheduling a Report in BIP 11g

February 20, 2017
In BI, OBIEE, RTF, Tips & Tricks
By admin

Step 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 More
20
February

Event Trigger BIP 11g

February 20, 2017
In BI, OBIEE, RTF, Tips & Tricks
By admin

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 More
20
February

BI PUBLISHER 12C – EVENT TRIGGERS

February 20, 2017
In BI, OBIEE, RTF, Tips & Tricks
By admin

Event 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 More
20
February

OBIEE 12c REPORT BURSTING

February 20, 2017
In BI, OBIEE, RTF, Tips & Tricks
By admin

Something 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
19
February

Upgrading to OBIEE 12c

February 19, 2017
In BI
By admin

Where 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 More
29
December

Excel Template for BI Publisher

December 29, 2016
In BI, OBIEE
By admin

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 More
29
December

Oracle BI Publisher 11g: XPT format

December 29, 2016
In BI
By admin

The 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
25
December

SSAS 2008 R2 Creation Steps

December 25, 2016
In BI, SSAS
By admin

Microsoft 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
a
23
December

Usage Tracking in OBIEE 11.1.1.7.0 (11g)

December 23, 2016
In BI, OBIEE
By admin

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