Saturday, February 25, 2012

Cube Partitions Setup

I have use the cube partitions in AS2000. It allows us to use the data slice to define the subset of the cube data. However, I don't see this in AS2005. If I partition the cube in monthly basis, then how AS2005 to handle the query. Is it look through all the partitions since it don't have the data slice setup?

In AS2005 partition slices are defined bit differently.

To define what data should go into partition you can define partition binding. You can change source for your partition to define restriction on the data coming into Analysis Services.

As for Anlaysis Services, it will detect the slice automatically. ( this is MOLAP case)

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment