SSAS Large Dataset

I have an oracle table feeding a fact table in ssas. 3 days of data is over 18,000,000 records and i have over 2 years of data to load. 2 Years of Date is about 450 Million records

I am in the development stages and I am wondering how to do my initial load to the cube

Any help would be appreciated.

more ▼

asked Mar 22, 2012 at 04:10 PM in Default

avatar image

1k 82 88 93

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Hope you have an Enterprise version and properly partitioned measure group for that fact table.

Then you have basically two possibilities.

  1. Process the cube as a whole (but this processing can be relatively long).

  2. Process the cube per partition - process one partition at a time.

In general it depends what load you can make on the source system and how you would like to have the cube available. Using the per partition processing and starting with the latest one and going toward older one you can make the latest data available earlier and make all the data available in stages.

more ▼

answered Mar 22, 2012 at 07:49 PM

avatar image

Pavel Pawlowski
22.7k 10 15 26

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 22, 2012 at 04:10 PM

Seen: 909 times

Last Updated: Mar 22, 2012 at 07:49 PM

Copyright 2018 Redgate Software. Privacy Policy