CODEWITHSUNDEEP
sql-server-2012ssascubeolap-cubessas-2012
Zerotoinfinity
Zerotoinfinity

Reputation: 6540

Process update is taking longer than Process full

I have a cube which has few big dimensions. It is currently taking 2 hours to Process Full. I have now partitioned the cube and followed below strategy:

  1. Process Update dimensions
  2. Process data Partition (only needed partition)
  3. Process index cube

Because I had few rigid relationship in some dimensions so I wan't able to do Process update. I made all of them as flexible now. But after that processing time of my cube increased to 2 hours 40 min.

Now, my question is why Process update here is taking such a long time? and how can I make it process faster? I am just processing 2 partition at a time out of 34. Here is the breakdown:

  1. Process update all dimensions - 2 hours 20 min
  2. Process data 2 partition - 10 min
  3. Process index - 10 min

Upvotes: 11

Views: 1186

Answers (1)

Kfir Dahan
Kfir Dahan

Reputation: 1

First I would try to delete unnecessary Dimension Attribute, Additionally it is possible to save processing time by setting the AttributeHierarchyOptimizedState to NotOptimized for Attributes that the users don't use often.

Upvotes: 0

Related Questions