KPI Partners Blog

Beware What You Read On The Web About OBIEE

Posted by KPI Partners News Team on Thu, Dec 27, 2012 @ 04:45 PM

by Kurt Wolff

It may be strange to be writing this with the intention of posting to a blog, but I thought someone should step back a minute and issue a few words of warning about information that can be found on the web about Oracle BI EE.

Read More

Tags: OBIEE, Mobile BI, Oracle, Kurt Wolff, Oracle BI, Oracle BI Applications, Jeff McQuigg, Blog

Top 12 Most Read Oracle BI Articles of 2012

Posted by KPI Partners News Team on Wed, Dec 26, 2012 @ 01:14 PM

Lets take a look at the most read Oracle Business Intelligence articles of 2012...

Read More

Tags: OBIEE, Endeca, Awards, Big Data, Oracle, Business Intelligence, Kurt Wolff, Abhinav Banerjee, Oracle BI, Exalytics, Book, Blog

Datetime Pairs in Oracle BI (OBIEE) - Days, Hours, Minutes, Seconds

Posted by KPI Partners News Team on Thu, Jun 14, 2012 @ 12:47 PM

by Kurt Wolff

Suppose you have a series of datetime pairs in Oracle BI... The problem is to display the differences between DATE1 and DATE2 in days, hours, minutes, and seconds.

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Creating an Alias vs. Duplicating a Physical Table (SQL & OBIEE)

Posted by KPI Partners News Team on Thu, May 31, 2012 @ 09:17 PM

by Kurt Wolff

When you duplicate a table, you create a new physical table with a new name. If this table is involved in a query, the SQL FROM clause will list this table. If the table does not exist in the database, then an error will occur.

Creating an alias creates a copy of the metadata table object that will be referenced in SQL with a new alias name. The alias name in SQL, as it is for all tables, will be derived its metadata ID.

To see the table IDs in OBIEE metadata, use the Oracle BI Query Repository utility. Here are some physical tables (and aliases) in a repository that I’ve created. It’s the last five digits of the ID that will be used to create the table aliases in SQL.

Read More

Tags: Data Warehousing, Kurt Wolff, Blog

Complex Row Level Security in Oracle BI (OBIEE)

Posted by KPI Partners News Team on Thu, May 17, 2012 @ 07:58 PM

by Kurt Wolff

Row level security (constraining a user’s view of the data to rows which meet pre-defined criteria) is a common requirement in OBIEE. This post will explore this topic, using a simple schema with a single fact table and three dimension tables, built around the theme of retail sales.

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Defining and Assigning Web Group Variables in OBIEE

Posted by KPI Partners News Team on Thu, May 03, 2012 @ 09:05 PM

by Kurt Wolff

Suppose you have a dashboard with three pages (tabs). Suppose further that not every user should see all three tabs. Most users will see a limited set of the tabs – some will see two, some will see only one. You want to define web groups to cover all the possible combinations. How many web groups would you have to create?

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Structuring Web Catalog Folders for Analytic Applications

Posted by KPI Partners News Team on Thu, Apr 19, 2012 @ 07:23 PM

by Kurt Wolff

If you have tried to develop dashboards or coherent sets of reports as an analytic application, you have had to think about how best to structure a web catalog.

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Bullet Graphs in Oracle Business Intelligence (OBIEE)

Posted by KPI Partners News Team on Thu, Mar 08, 2012 @ 11:06 AM

by Kurt Wolff

Stephen Few designed the Bullet Graph as a way to display measurements vs. goals or other benchmarks. The screen shot below shows bullet charts in the column “MTD & Proj Comp MAgo” (Month to Date and Projected Expense Compared to Month Ago).

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Prompting For One Month - Displaying A Range of Months in OBIEE

Posted by KPI Partners News Team on Thu, Feb 16, 2012 @ 08:13 AM

by Kurt Wolff

An OBIEE dashboard designer recently asked how to turn a prompt for a single month into a filter for a range of months. For example, if the user selects “Aug” in the prompt, the results should include not just August but also the three months preceding and following August (i.e. May through Nov).

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Don't Overstate Data

Posted by KPI Partners News Team on Tue, Feb 14, 2012 @ 08:12 AM

by Kurt Wolff

One of the tricky things for users of relational databases is forming queries without overstating (or understating) results as a consequence of table joins.

Read More

Tags: Business Intelligence, Kurt Wolff, Oracle BI, Blog