Oracle announces the general availability of Oracle Business Intelligence Enterprise Edition (OBIEE) release 11.1.1.6.0. The new release adds more enhancements, additional certifications, and bug fixes among other features. This release delivers a BI platform specially designed to leverage:
KPI Partners Blog
Oracle Announces Release of OBIEE 11.1.1.6.0
Prompting For One Month - Displaying A Range of Months in OBIEE
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).
Tags: Kurt Wolff, Oracle BI, Blog
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.
Tags: Business Intelligence, Kurt Wolff, Oracle BI, Blog
Recording of Manufacturing Analytics Webinar & Demo Now Available
On January 10th, KPI Partners broadcast a webinar which took a deep dive into their exclusive pre-built solution for Manufacturing Analytics. Pavan Nanjundaiah, KPI's resident expert on the subject, demonstrated how this solution can help existing customers of Oracle BI Applications further extend their decision support capability.
Tags: Webinar, Pre-Built Solutions, Oracle BI, Oracle BI Applications, Manufacturing Analytics, ERP, Blog
Statistical Analysis Using Linear Regression in OBIEE
by Kurt Wolff
Linear regression is a statistical technique for drawing a line through a set of data points that “best fits” the data. It is a useful and standard technique for quantifying trends.
Tags: Kurt Wolff, Oracle BI, Blog
5 New Webinar Recordings on Oracle BI Posted To Archive
The experts at KPI Partners have completed a marathon schedule of webinars from the end of October through December. In the event you missed an event, a recording from each of the webinars have been posted to the KPI Partners webinar archive.
Tags: Webinar, Pre-Built Solutions, Case Study, Oracle BI, Oracle BI Applications, Blog
Oracle BI Partner Offers 50% Off Training To Public
KPI Partners extends limited time offer to enroll in any training course at 50% off.
New York, NY – December 21, 2011 -- KPI Partners today announced the launch of a new campaign offering 50% off course fees for any scheduled 2012 Oracle BI training course through KPI University, the company's center for education and training.
Tags: KPI University, Training, News, Oracle BI, Oracle BI Applications
by Kurt Wolff
One of the questions that comes up over and over again is how to show all periods in a query when facts don’t exist for all periods or how to show all products when facts don’t exist for all products.
Tags: Kurt Wolff, Oracle BI, Blog
Advanced Relationship Modeling in OBIEE - N:N Fact
by Kurt Wolff
[Note: the following discussion is based on OBIEE version 10.1.3.4.0 and Oracle XE version 10G, both running on Windows. The behavior of other versions of OBIEE could be different.]
Tags: Kurt Wolff, Oracle BI, Blog
OBIEE Multi-Select Prompt With an 'All Values' Choice
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.
Tags: Kurt Wolff, Oracle BI, Blog