Search code examples
ssascube

will processing cube be affected by other cubes?


In my ssas project, I created two cubes(A and B). There are 1,000 data in cube A, and 20,000,000 in B. When I process cube A, it will not be completed to process sometimes. In my idea, only 1,000 data will never cause SSAS crashed, so maybe cube B caused.

Does anyone know the affection between cubes when processing cube?

Thanks,


Solution

  • There is no connection between different cubes except for possible common dimensions.

    Dimensions can be used by several cubes. If Cube A has one or more dimensions in common with Cube B, Cube B might be set as unprocessed when Cube A and its dimenions have been reprocessed.