ssas - How do I process an individual cube partition -
i've got cube set number of partitions - 1 each year of data in fact table. i'd process partitions on individual basis. possible? if so, how go this?
thanks
the easiest way process individual partition manually sql server management studio, can right-click partition , select "process". guess not want.
how process cube in first place? if use ssis instance, use script transformation generate xmla script processes individual partition. in simplest form script take existing xmla , replace name of partition correct value. have done in project , works well. generated script can executed ssis xmla task well.
if explain requirements in more detail maybe can better.
nicolas
Comments
Post a Comment