September 28, 2007 at 12:01 pm
Okay, I have a MS 2000 Analysis Services cube and it's data source is an Oracle database. The cube is processed on a monthly basis.
When I drillthrough, is it reaching to Oracle to get that data then (on demand)? Or is all this data stored somewhere on my Analysis Services box (like my SQL server database) and this data is displayed when you drill through?
September 28, 2007 at 12:34 pm
Here is a good article:
http://www.databasejournal.com/features/mssql/article.php/10894_1963091_2
Drillthrough will - by default - drill into the data mart the cube is processed from. In you case, it sounds like you have an Oracle OLTP database, an MS SQL Data Mart, and are using AS 2000 OLAP.
This will mean that the default operations for drillthrough will drill into the SQL Data Mart (I assume some sort of star or snowflake schema).
This makes sense as your OLTP system would be constantly changing and would tend to cause the drillthrough information to be out-of-sync with your OLAP data. That would be confusing for a user. Your data mart is pretty likely to be populated just before your process your OLAP cubes so they would tend to match each other.
September 28, 2007 at 12:44 pm
Thanks for the article. I will check it out now. I think that it must be drilling through to Oracle - that is the only data source setup for the cube. Also, the basis for my question is I am having problems with my drill through through the analysis manager interface - I just noticed I am getting an Oracle error, so it must be Oracle! Thanks!
September 28, 2007 at 12:55 pm
Yup - if your datasource is Oracle, it drills through to Oracle.
Drillthrough is touchy about data being changed. It uses the key values from the dimensions associated with the cell you are clicking on to filter the data. If the data has changed since the cube was processed, it can throw errors.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply