Page 1 of 1

PM49653: SANDBOX VALUES INCORRECT

Posted: Fri Oct 14, 2011 2:50 pm
by csjean
This one comes from SR65372 077 649: TM1 Sandbox deletes unmodified values when logging out / logging back in when fed and FEEDSTRING in rules (which IMHO has a better title ;-) ).

It's very easy to reproduce:

When a user changes a value in a sandbox, logs out and then logs back
in, UNCHANGED values are erased (put at 0).

This happens when:
  • There are rules of the cube.
  • Those rules have feeders and that the unchanged value is fed by the changed one

    Code: Select all

     for example, QTY, PRICE and TOTAL where 
           TOTAL = N:QTY * PRICE but:   
           PRICE =  C:TOTAL \ QTY;                                           
                                                                            
         FEEDERS;                                                           
         QTY => PRICE;                                                      
         QTY => TOTAL;                            
  • Those rules have a FEEDSTRING;
In the case above, if you change QTY in the sandbox, TOTAL will be
updated.
Log out and log back in and QTY will still be changed but PRICE will be
0 and TOTAL will still be changed.

The test case RUX file (and for that matter my test case cube with dims) is available on request.

Re: PM49653: SANDBOX VALUES INCORRECT

Posted: Fri Oct 14, 2011 2:53 pm
by jim wood
Is this 9.5.2 only or is it cross version?

Re: PM49653: SANDBOX VALUES INCORRECT

Posted: Fri Oct 14, 2011 5:48 pm
by csjean
jim wood wrote:Is this 9.5.2 only or is it cross version?
Hi Jim,

I originaly reported it for 9.5.2 but the person from support told me he could reproduce the problem
in 9.5.1 and said he would try to do it in 9.5 (no news on that).

The PM is tagged with 9.5.2 only on the IBM site.