KPI Partners Blog

Installing and Configuring BI Composer for Oracle BI EE

Posted by KPI Partners News Team on Fri, Sep 30, 2011 @ 03:10 PM

By Harisha Pattela

To install and configure BI Composer for Oracle BI EE, use the following steps as a guide:

Step 1

Extend a Web Logic Server domain & to install BI Composer runtime implementation shared libraries:

    1. Stop the Web Logic Server.
    2. Launch the Configuration Wizard.
    3. Select Extend an existing Weblogic domain, and then click Next.
    4. Select the domain folder (for example, <mw_home>/user_projects/domains/bifoundation_domain), and then click Next.

 

 

Read More

Tags: Harisha Pattela, Oracle BI, Blog

What To Do When OBIEE Fact Tables Do Not Join to All Dimension Tables?

Posted by KPI Partners News Team on Wed, Sep 28, 2011 @ 10:16 PM

By Kurt Wolff

When I read the questions people ask about data modeling on OBIEE forums, one that seems to come up frequently is what to do when you have fact tables that do not join to all dimension tables.

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Writeback in OBIEE

Posted by KPI Partners News Team on Tue, Sep 27, 2011 @ 12:45 PM

By Kurt Wolff

“Writeback” – presenting an Answers interface so that users can update data in database tables or insert new rows – first appeared in version 7.8.4. To use OBIEE’s writeback capabilities, there are several set up steps. While each one is simple and fairly straightforward, it’s easy to forget all the steps and where each one is located. This document contains the instructions in case you find yourself forgetting them. Since many people like to demo using Excel as a data source, it focuses first on using Excel. Later, an example using an Oracle table is discussed.

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Handy Date Session Variables in OBIEE

Posted by KPI Partners News Team on Sat, Sep 10, 2011 @ 09:20 PM

By Kurt Wolff

It is often convenient to set a number of session variables to capture date values that you use repeatedly in your queries. For example, if you have weeks that end on Saturday, you might want to have the date of the most recent Saturday in a session variable, called perhaps PREVIOUSSATURDAY. You can then use that session variable as the default date value in your queries – for example, “Periods”.”Date” = VALUEOF(NQ_SESSION.PREVIOUSSATURDAY).

Read More

Tags: Kurt Wolff, Oracle BI, Blog