When: Thursday, Dec 13, 2012 at 9:00am PST / 12:00pm EST / 6:00pm CET.To attend: Sign up here.
If you use a business intelligence tool such as IBM Cognos, Microstrategy or SPA BusinessObjects Analysis that uses XMLA to connect to multidimensional data sources, check out (more...)
Beginning with Oracle BI 18.104.22.168, the Oracle BI Administration tool has the ability to import Oracle cubes, dimensions and hierarchies into the Physical layer of the Oracle BI repository. This provides an alternative to the Oracle BI plug-in for Analytic Workspace Manager. Each method works (more...)
I've posted a series of three videos introducing Oracle OLAP. This is a great series for people how are interested in learning about what Oracle OLAP is and what it's used for. I suggest starting viewing these in order. Here are the links:
Oracle OLAP Overview: Part (more...)
If you have ever wanted to report on the total of two or more dimension members you have probably done so using in SQL using SUM ... GROUP BY.
Let's look at an example using the OLAPTRAIN schema. Suppose you want the total of the states in the northeastern (more...)
If you are like most people, you probably use the LOAD_AND_AGGREGATE cube script that is automatically created by Analytic Workspace Manager. Fine tuning the update process simply involves filtering the fact table for new or changed rows.
With a little bit of effort, you can improve update times by writing (more...)
A question that I often get is "what is the difference between using ODBC and the MDX Provider for Oracle OLAP (from Simba Technologies) to query Oracle cubes"? Given that the Oracle cube is easily queried with SQL, it's a reasonable question.
The answer really boils down to leveraging meta (more...)
For a great paper on Oracle OLAP running on Exadata, see:http://www.oracle.com/technetwork/database/options/olap/olap-exadata-x2-2-performance-1429042.pdf
The Executive Overview section of this paper provides an introduction:
This paper describes a performance demonstration of the OLAP Option to the Oracle Database running on an X2-2 Exadata Database Machine half rack. It shows (more...)
Note - This blog post was updated on Nov. 14, 2012 with a new script. This as been simplified a bit and includes half year.
One of the more common requests I get is a script for creating time dimension tables for Oracle OLAP. The following script will create (more...)
One of the more common questions I get is about how cubes are processed, in particular how and when Oracle cubes are processed incrementally. Here is a short summary of how the cube refresh process works, a few scenarios and some suggestions on being smart about solutions.
- The cube (more...)
I recently returned from a trip to Germany where visted a Bissantz, a relatively small company in Nürnburg that develops and markets an interesting reporting and data visualization tool named DeltaMaster that works with Oracle OLAP (and other data sources). I was very impressed with this tool. There are few things that I really liked about it:
- It's very good at displaying a lot of information within a single report. One of the ways that it does this is by mixing graphical representations of data with numerical representation (they are very big on something called 'Sparklines'). This makes it very (more...)
I was working on an application last week that required time series analysis at Hour, Day, Month, Quarter and Year levels. Two interesting things came out of this application.
First, a little implementation detail. The data was supplied in the fact and dimension tables at the Hour level with a TIMESTAMP data type. As you might expect then, there were time periods at the hour level such as:
02-JAN-10 10.00.00.000000000 AM
02-JAN-10 11.00.00.000000000 AM
02-JAN-10 12.00.00.000000000 PM
02-JAN-10 01.00.00.000000000 PM
02-JAN-10 02.00.00.000000000 PM
In my (more...)
While I was teaching a workshop in Moscow recently a student asked about parallel execution of OLAP DML. Their cube processing included the usual loading and aggregation, which are automatically parallelized, but they also have some assignments into the cube which are done using an OLAP DML program. They noted that this was slow because it was single threaded on one CPU. I told the student that Oracle OLAP supports a multi-write attach mode that can be used to update multiple objects in parallel using separate sessions. I checked the documentation, but didn't find a clear explanation of how this (more...)
I've run into this a few times recently, so here's a quick tip related to using Excel with Oracle OLAP (via the Simba MDX Provider for Oracle OLAP, of course).
Here's a situation that's been reported as a bug, but you really just need to know the right Excel Pivot Table option to choose. Consider a cube that has measures that do not aggregate but is dimensioned by a dimension with a hierarchy. In this case, there is a cube with a Store dimension with levels Store > Store Type > All Stores. The stores are located in different countries (more...)