Post reply

Partition Processing issue with Process Update

  • December 5, 2014 at 12:44 pm

    #150255

    Hi,

    I have a cube with 5 partitions. When I full process there is no issue. But when I run the Process update , two of those partitions don't get updated. Only full processing updates them.

    What would be different between process update and process full? Please suggest

    Thanks,

    Veena

  • December 8, 2014 at 1:26 am

    #1763204

    Process Update is for dimensions only, not facts. I take it you are talking about facts since you can't partition dimensions.

    I'm on LinkedIn

  • December 8, 2014 at 1:36 pm

    #1763371

    Oh I didn't know process update was only for Dimensions. I was actually talking about partitions. I had typo on the name of my partition. And the SSIS package script task looked for a specific phrase in the partition name and processed only those with the name like %INCREMENTAL%. Since I had the typo in some of my partitions , they never were processed.

    Actually if there is no process update for facts, how do we just process new data and not do a full processing on partitions?

    Thank you.

  • December 8, 2014 at 1:49 pm

    #1763376

    You need to use a process incremental. If you are doing this from SSIS you can use variable expressions to build XMLA to process only new data.

    I'm on LinkedIn

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply