Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
    Bumped by Community user
2 some formatting and generic tag
source | link

I have a cube built in SSAS that uses 3 facts and 8 dimensions. Some of the dimensions are shared across 3 facts.

When I process one of the dimension, it tries to process the underlying measure groups, however, as the other dimensions are not yet updated with the new data, the measure group processing fails saying the key doesn't exist.

How should we trigger a dimension process in such a case?

Illustration: Cube has 3
3 Fact Tables C1, C2, C3;
8 Dimensions D1, D2, D3, D4, D5, D6, D7, D8 C1

C1 is built on D1, D2, D3, D4 
C2 is built on D1, D5, D6 
C3 is built on D1, D2, D5, D7, D8 

Assume that I have made updates in the Dimensions D1 and D5 and trigger a Dimension process one after the other using AMOAMO.

When I process D1, it processes Dimension D1 and measure groups C1, C2 and C3. When it tries to process the measure group C2, it complains that the updated data in D5 is still not populated. When I Process D5 first, it processes Dimension D5 and measure groups C2 and C3. When it tries to process the measure group C3, it complains that the updated data in D1 is still not populated

Note: * Its SSAS 2012 * We are processing dimensions using ProcessUpdate and process using ProcessFull

  • It's SSAS 2012
  • We are processing dimensions using ProcessUpdate and process using ProcessFull

Please do let me know if you need any additional information.

Thanks,
Anil

I have a cube built in SSAS that uses 3 facts and 8 dimensions. Some of the dimensions are shared across 3 facts.

When I process one of the dimension, it tries to process the underlying measure groups, however, as the other dimensions are not yet updated with the new data, the measure group processing fails saying the key doesn't exist.

How should we trigger a dimension process in such a case?

Illustration: Cube has 3 Fact Tables C1, C2, C3; Dimensions D1, D2, D3, D4, D5, D6, D7, D8 C1 is built on D1, D2, D3, D4 C2 is built on D1, D5, D6 C3 is built on D1, D2, D5, D7, D8

Assume that I have made updates in the Dimensions D1 and D5 and trigger a Dimension process one after the other using AMO.

When I process D1, it processes Dimension D1 and measure groups C1, C2 and C3. When it tries to process the measure group C2, it complains that the updated data in D5 is still not populated. When I Process D5 first, it processes Dimension D5 and measure groups C2 and C3. When it tries to process the measure group C3, it complains that the updated data in D1 is still not populated

Note: * Its SSAS 2012 * We are processing dimensions using ProcessUpdate and process using ProcessFull

Please do let me know if you need any additional information.

Thanks,
Anil

I have a cube built in SSAS that uses 3 facts and 8 dimensions. Some of the dimensions are shared across 3 facts.

When I process one of the dimension, it tries to process the underlying measure groups, however, as the other dimensions are not yet updated with the new data, the measure group processing fails saying the key doesn't exist.

How should we trigger a dimension process in such a case?

Illustration:
3 Fact Tables C1, C2, C3;
8 Dimensions D1, D2, D3, D4, D5, D6, D7, D8

C1 is built on D1, D2, D3, D4 
C2 is built on D1, D5, D6 
C3 is built on D1, D2, D5, D7, D8 

Assume that I have made updates in the Dimensions D1 and D5 and trigger a Dimension process one after the other using AMO.

When I process D1, it processes Dimension D1 and measure groups C1, C2 and C3. When it tries to process the measure group C2, it complains that the updated data in D5 is still not populated. When I Process D5 first, it processes Dimension D5 and measure groups C2 and C3. When it tries to process the measure group C3, it complains that the updated data in D1 is still not populated

Note:

  • It's SSAS 2012
  • We are processing dimensions using ProcessUpdate and process using ProcessFull

Please do let me know if you need any additional information.

1
source | link

Problem with Processing Dimensions with Multiple Facts

I have a cube built in SSAS that uses 3 facts and 8 dimensions. Some of the dimensions are shared across 3 facts.

When I process one of the dimension, it tries to process the underlying measure groups, however, as the other dimensions are not yet updated with the new data, the measure group processing fails saying the key doesn't exist.

How should we trigger a dimension process in such a case?

Illustration: Cube has 3 Fact Tables C1, C2, C3; Dimensions D1, D2, D3, D4, D5, D6, D7, D8 C1 is built on D1, D2, D3, D4 C2 is built on D1, D5, D6 C3 is built on D1, D2, D5, D7, D8

Assume that I have made updates in the Dimensions D1 and D5 and trigger a Dimension process one after the other using AMO.

When I process D1, it processes Dimension D1 and measure groups C1, C2 and C3. When it tries to process the measure group C2, it complains that the updated data in D5 is still not populated. When I Process D5 first, it processes Dimension D5 and measure groups C2 and C3. When it tries to process the measure group C3, it complains that the updated data in D1 is still not populated

Note: * Its SSAS 2012 * We are processing dimensions using ProcessUpdate and process using ProcessFull

Please do let me know if you need any additional information.

Thanks,
Anil