KPI Partners Blog

Using WITH in Physical Tables ("Opaque Views")

Posted by KPI Partners News Team on Mon, Nov 28, 2011 @ 11:54 AM

by Kurt Wolff

Common practice is to use derived tables (sometimes referred to as “inline views”) when creating a physical layer “Select” table.

Read More

Tags: Blog, Oracle BI, Kurt Wolff

OBIEE Multi-Select Prompt With an 'All Values' Choice

Posted by KPI Partners News Team on Fri, Nov 18, 2011 @ 11:03 AM

by Kurt Wolff

Here’s a not uncommon scenario. You are designing a dashboard page with a report such as sales by customer. To show sales by customer, you design a report containing the CustomerName column so that facts are grouped by customer. You provide a multi-select prompt to allow the user to select which customer data to view. But you also want to provide the ability to view the data for all customers as a total, without grouping by customer.

Read More

Tags: Blog, Oracle BI, Kurt Wolff

KPI Partners Releases Manufacturing Analytics for Oracle BI & E-Business Suite

Posted by KPI Partners News Team on Thu, Nov 17, 2011 @ 07:00 AM

KPI Partners has developed a pre-built analytic application specifically designed for manufacturing and costing processes.

Minneapolis, Minnesota – November 17, 2011 -- KPI Partners today announced the introduction of Manufacturing Analytics for Oracle BI, a solution developed for use with the Oracle Business Intelligence platform and the Oracle E-Business Suite Manufacturing modules. KPI’s Manufacturing Analytics enable any organization to monitor and analyze the manufacturing processes and costing details that exist within an organization.

Read More

Tags: Oracle BI, News, Oracle BI Applications, Manufacturing Analytics, ERP

Setting OBIEE Join Columns With Request Variables

Posted by KPI Partners News Team on Tue, Nov 15, 2011 @ 11:01 AM

by Kurt Wolff

Here is a technique for enabling the user to set join columns with a dashboard prompt.

Read More

Tags: Blog, Oracle BI, Kurt Wolff

Comparing Arbitrary Time Periods in OBIEE

Posted by KPI Partners News Team on Thu, Nov 10, 2011 @ 11:07 AM

by Kurt Wolff

The Ago() “time series function” can be used to show data for a  previous time period, as long as the previous time period corresponds to a level that has been defined in the period hierarchy. A typical period hierarchy containing day, month, quarter, and year levels would allow you to use the Ago function to construct measures showing data for day ago, month ago, quarter ago, year ago (or N days ago, N months ago, etc.).

Read More

Tags: Blog, Oracle BI, Kurt Wolff

Need Selected Date + 30 Days Data - Siebel Analytics/OBIEE

Posted by KPI Partners News Team on Tue, Nov 08, 2011 @ 11:05 AM

by Kurt Wolff

Someone asked a question on a “Siebel Analytics” email group a few days ago that I thought was worth discussing briefly here. The question posed was how to put a date prompt on a dashboard and return data for that date and the next 30 days. The solution could not involve presentation or report variables, since these were introduced only in a later version of Siebel Analytics that the person who posed the question did not have.

Read More

Tags: Blog, Oracle BI, Kurt Wolff

Visually Presenting Data in Tables and Pivot Tables

Posted by KPI Partners News Team on Thu, Nov 03, 2011 @ 11:39 AM

by Kurt Wolff

There are times when you might want to visually present data directly in tables or pivot tables rather than create a chart view. For example, you may have too many values to show in a chart. Or the number of values returned by the query might vary, making the size of the chart sometimes too small to accommodate them all, sometimes too large. Or you may want to visually scroll up and down a table to compare values and would like a visual representation right there in the table.

Read More

Bookings, Billings, and Backlogs Webinar Available On-Demand

Posted by KPI Partners News Team on Tue, Nov 01, 2011 @ 10:56 AM

The team of Sid Goel, Kusal Swarnakar, and Sid Singh collaborated on a webinar last week that covered the much misunderstood subject of Bookings, Billings, and Backlog Analysis.

Read More

Tags: Blog, Oracle BI Applications, Events, Webinar