Multiplying with ZERO values in script logic

[Former Member]

Hi  Friends,

I need to multiply with zero value after being entered.  Multiplication through expression statement works well other than ZERO values. Means when I change any value to  zero  in input sheet and  go for recalculation then calculation doesn't happen. I am not sure that from scoping level system doesn't consider  zero values ( considers aggregated one , although in cube  we are having  + value &  - value  corresponding to that particular zero entry ) or I need to write expression statement differently . Please help if there is any other way to do it.  

Thanks in advance

Suvendu

[former_member186338]

"I need to multiply with zero value after being entered. " - why to enter values at all

*REC(EXPRESSION=0)

will do the job!

If you want more comments - please provide your script in line with:

Vadim

[Former Member]

Hi Vadim,

My requirement is  like following .

I have 2 dimension Account and material.

I enter value in account A in my sheet  against  material  10000 .

Then I run the package based on following rule.

*XDIM_MEMBERSET  ACCT = A

*REC(EXPRESSION = %VALUE%*1000,ACCT = B)

After running the package I found that  by mistake i entered value in material 10000. So I made it ZERO.

Now if I re run the package then  ACCT = B with material = 10000 will be cleared.

Is it possible in script logic ?

Thanks in advance

Suvendu

[former_member186338]

Sorry, but absolutely not clear!

Please read once again:

And provide the detailed explanation!

Vadim

[Former Member]

Hi Vadim,

I am rephrasing  statement  technically .

In Expression statement , can system consider value = 0  or  system will ignore zero values at the time of pulling data from database ?

*REC(EXPRESSION = %VALUE%*10000)

Thanks

Suvendu

[former_member186338]

"In Expression statement , can system consider value = 0  or  system will ignore zero values at the time of pulling data from database ?"

- what do you mean by"consider"?

When the records are selected only existing records are selected, even records containing zero.

If you perform light optimization with zero elimination -  all zero records will disappear - no zero records selected.

But please, instead of theory, it's better to explain your case step by step with full details! Or it's a waste of time...

[Former Member]

Hi Suvendu,

Yes, if you enter value = 0 in your input template it will be processed by that script and Account B will be cleared.

Is that what you were asking?

Regards,

Gersh