Skip to Content

Light optimization with Zero Elimination Issue

Hi Experts,

I have created a copy of light optimize process chain and

Double click the Collapse process and change it to edit mode and select "switch on zero elimination" check box and saved the variant with a new name ZCPMB_LIGHT_COMPRESS.

Now i have create a new package in BPC and assigned this process chain and chnaged the tasks as below

However if i run the package it fails with error"Failed to analyze instruction /ZCPMB_LIGHT_COMPRESS,DTA_CUBE,%APPBINAME%"

Version BPC 10.0, BW730 0007.

Could you please help.

Thanks,

Srikant

capture.jpg (60.3 kB)
capture1.jpg (28.9 kB)
capture2.jpg (21.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 19 at 01:06 PM

    I prefer the following sequence:

    1. Copy Original chain

    Name: LIGHT_OPTIMIZE_ZE, Description: Lite Optimize Zero Elim

    Start process: Name:/CPMB/LIGHT_OPTIMIZE_ZE_START, Description: Lite Optimize Zero Elim start

    Collapse: instead of "=" select create using template:

    Name: /CPMB/LIGHT_COMPRESS_ZE, Description: Lite Optimize Zero Elim compress

    Other processes - not changed!

    Execute copy!

    2. Open new chain, open Collapse process. Change zero elim and number of requests to 0. Save process.

    3. Use advanced script for the new chain (LIGHT_OPTIMIZE_ZE):

    TASK(/CPMB/SWITCH_TO_LOAD,INFOCUBE,%APPBINAME%)
    TASK(/CPMB/SWITCH_TO_PLAN,INFOCUBE,%APPBINAME%)
    TASK(/CPMB/ROLL_UP,DTA_CUBE,%APPBINAME%)
    TASK(/CPMB/CREATE_STATISTICS,DTA_CUBE,%APPBINAME%)
    TASK(/CPMB/LIGHT_COMPRESS_ZE,DTA_CUBE,%APPBINAME%)

    Done!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 09:56 AM

    Copy the whole lite optimize chain and in the chain copy use variant with zero elimination!

    Also set to zero number of requests to collapse.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 12:06 PM

    Hi Vadim,

    Unable to reply your comment, so posting here.

    Collapse variant

    Please let me know if you require any other details.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded