Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ssas partitioning Expand / Collapse
Posted Tuesday, July 1, 2008 8:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 10:44 AM
Points: 8, Visits: 84

I have been tasked with ensuring that when my products dimension is changed ie.the data team either adds, edits or deletes data in the underlying rdms table (that the product dimension is made up of) the new changes is reflected in the cube without taking the cube offline. Its a priority that users must be able to keep quering the cube at all times and the updated product dimension changes must be reflected in the cube.

The fact table data is partitioned (MOLAP) while the dimension data is stored in a relational database. From my research iam assuming that 1st a Process Update will be done on the products dimension. Then the partition will have to be processed - will this be a Process incremental ? And in the process incremental wizard what is the Source table or query - is that my product dimension ?

If anyone can shed some light it would be much appreciated.

Post #526686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse