Optimize Light not work Zero Elimination

[Former Member]

Hi good day,

I have the following records in my Infocube:

Negative 1 record and a positive record that gives zero result

/CPMB/LIGHT_OPTIMIZE runs Succeeded but not wor zero elimination.

in the process Collapse is actived zero elimination

The version BPC is 10.1NW SP09 on Hana

how can I solve that?

[Former Member · Accepted solution]

Hi David,

Make the number of requests to 1 or 0 depending upon the no. of requests you see in your cube now...and run again.

Hope it helps....

Regards,

JP

[Former Member · Accepted solution]

Thanks JP

[Former Member · Accepted solution]

Hi JP,

Number of request  = 0 is not advised for any DB. For example, if you use it for Oracle DB data loads will be slow after LO since no stats are available on the table.

If author is using HANA then number of requests = 0 is fine.

For all other DBs I'd suggest talking to DBA before changing this setting.

Regards,

Gersh

[Former Member · Accepted solution]

Hey Gersh,

Thanks for the info! But what in case of BPC 10/10.1 with normal BW and not HANA??? Will having number of requests equal to 0 have any effects??

Regards,

JP

[former_member186338 · Accepted solution]

Looks like it's OK with MS SQL engine....

[Former Member · Accepted solution]

Hi JP,

As I said, it depends on the DB you use. For Oracle it has negative effect because F table becomes empty and doesn't have statistics. Therefore no INSERTs are going to use indices. In such case it's advisable to load first a small number of records, refresh statistics and then run bigger loads.

Not sure about other DBs.

Regards,

Gersh

[former_member186338]

Number of requests=0

[former_member186338]

And please read also

[Former Member]

Thanks Vadim.