Process only certain partitions of cube

Question

I have a cube that is partitioned by year. I want to do a full process to only the last couple of years, as only data from this period can have changed, been added or deleted. I am unable to figure out how to choose that only certain partitions should be processed. Can anyone help me with this?

SebTHU · Accepted Answer · 2016-12-16 11:56:06Z

1

Partitions are defined on a Measuregroup. If your entire cube is time-partitioned, that sounds as though every measuregroup that's sliced by the Time dimension is time-partitioned. (You may have only one measuregroup in your cube, though).

You can see partitions in the "Partitions" tab of the Cube design window. You can process partitions here (manually, at the dev stage), or from SSMS, or by generating an XMLA script to be run on a scheduled basis. Essentially what you do is process the partition rather than the entire measuregroup.

answered Dec 16, 2016 at 11:56

SebTHU

1,4032 gold badges12 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

buck · Accepted Answer · 2016-12-29 20:53:10Z

-1

If you use SSIS, there is a task called Analysis Services Processing Task. In the Processing Settings of this task you can select the kinds of objects you want to process, including one or more partitions for a table.

answered Dec 29, 2016 at 20:53

buck

2052 silver badges9 bronze badges

Collectives™ on Stack Overflow

Process only certain partitions of cube

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related