PM49653: SANDBOX VALUES INCORRECT

Post bug reports and the status of reported bugs
Post Reply
csjean
Posts: 40
Joined: Mon Mar 01, 2010 2:53 pm
OLAP Product: TM1
Version: 9.5 9.5.1 9.5.2
Excel Version: 2007

PM49653: SANDBOX VALUES INCORRECT

Post 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.
Cheers!

--
Claude-Sebastien Jean
Senior Consultant in Information Technology
Keyrus Canada
www.keyrus.ca
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: PM49653: SANDBOX VALUES INCORRECT

Post by jim wood »

Is this 9.5.2 only or is it cross version?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
csjean
Posts: 40
Joined: Mon Mar 01, 2010 2:53 pm
OLAP Product: TM1
Version: 9.5 9.5.1 9.5.2
Excel Version: 2007

Re: PM49653: SANDBOX VALUES INCORRECT

Post 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.
Cheers!

--
Claude-Sebastien Jean
Senior Consultant in Information Technology
Keyrus Canada
www.keyrus.ca
Post Reply