locked
Cube process crashes after changing to dimension updates RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi guys,

    I have an ETL script to process my cube

    1) Process update on dimensions that are linked with the fact table SALES

    Process full on other dimensions

    2) Process full on all measure groups apart from Sales

    3) Process Sales by script (partitioned over years from 2011 to 2015). The script is made so that only 2015 partition gets processed

    4) Process index on all partitions

    However, since I changed my process dimensions from full to update the cube crashed on error : cannot find SK_PROD XXX in partition SALES 2015.

    When I query the datamart on sales joined with the date 2015 the SK_PROD XXX is found...

    Anyone could imagine this scenario why cube crashes?

    Tuesday, April 14, 2015 8:54 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    1) Process update on dimensions that are linked with the fact table SALES

    Process full on other dimensions

    Hello,

    When you perform a "Process full" on at least one dimension it removes all fact data from your cube, therefore you have to process all measure groups, also all partitions of measure group "sales" and not only the latest one.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Visakh16MVP Wednesday, April 15, 2015 5:51 AM
    • Marked as answer by Yvanlathem Wednesday, April 15, 2015 11:52 AM
    Wednesday, April 15, 2015 5:30 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    1) Process update on dimensions that are linked with the fact table SALES

    Process full on other dimensions

    Hello,

    When you perform a "Process full" on at least one dimension it removes all fact data from your cube, therefore you have to process all measure groups, also all partitions of measure group "sales" and not only the latest one.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Visakh16MVP Wednesday, April 15, 2015 5:51 AM
    • Marked as answer by Yvanlathem Wednesday, April 15, 2015 11:52 AM
    Wednesday, April 15, 2015 5:30 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Olaf,

    I will try to do a process update on ALL dimensions than. That should solve the issue!

    Thanks in advance I didn't know it removed all fact data I thought it only was the related fact tables.

    Wednesday, April 15, 2015 5:57 AM