Why OLAP?

Introduction An effective OLAP solution solves problems for both business users and IT departments. For business users, it enables fast and intuitive access to centralized data and related calculations for the purposes of analysis and reporting. For IT, an OLAP solution enhances a data warehouse or other relational database with aggregate data and business calculations. In addition, by enabling…

Read More

The Value of Visualization

The notion of data visualization has been around for years. Visualization provides a means by which you can gain insight into your data. For some, visualization can be a report that appears in their email inbox or on a web page. For others, it could be a grid of numbers with a chart in Excel. The key is…

Read More

PBCS Data Management Error: Cannot insert NULL

Every month Oracle releases a Readiness document to their PBCS customers, notifying them of the latest updates and fixes, along with dates of when these changes will be applied to their environments. Oracle applies the updates to the test environments 2 weeks prior to applying it to the production environments. This allows the customers to…

Read More

Using FDM for Essbase drill-through

Often when developing Essbase reporting applications with FDM, there are additional levels of granularity of the data that are not needed in Essbase, but exist in FDM.  For example the “Invoice #” or “PO #” may be needed when drilling into detail from Essbase, however that same data does not need to reside in the…

Read More

Looking Back at 2012, the Year of Big Data

The end of a year always brings the inevitable flood of lists. Best of 2012 lists. Worst of 2012 lists. Influential songs, YouTube videos, even people that sum up the year in review, like Lady Gaga or Barack Obama. These lists stick to politics and pop culture for the most part and rarely does a…

Read More