Light optimization with Zero Elimination Issue

[former_member247531]

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

[former_member186338 · Accepted solution]

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!

[former_member247531]

Hi Vadim,

Unable to reply your comment, so posting here.

Collapse variant

Please let me know if you require any other details.

Thanks.

[former_member186338]

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.

[former_member247531]

Hi Vadim,

Thanks for the reply.

I have copied the lite optimize process chain and i have used the variant with zero elimination.

And now I have set to zero number of requests to collapse .

However i got the issue while running the Data manager package.

Below are the tasks for my new Data manager package.

Do I need to change any other things?

Regards,

Srikant

[former_member186338]

Detailed new chain screenshots, please!