Process does not update updateable cell

Post Reply
TMinorK
Posts: 3
Joined: Fri Aug 04, 2017 10:52 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2 RTM
Excel Version: 2013 Pro

Process does not update updateable cell

Post by TMinorK » Fri Aug 04, 2017 12:26 pm

I bump into the following issue occasionally in TM1 10.2.2. RTM: it happens that some processes, though terminating without any errors, do not update some target cells. The corresponding cells are updateable and in most of the cases they are actually updated when the process is executed.
A couple of days ago it happened even while using an AttrPutS command to assign an alias to a dimension element (i.e. in this case the cell in the related }ElementAttributes cube was not updated).
Do you have any idea?

User avatar
jim wood
Site Admin
Posts: 3492
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Process does not update updateable cell

Post by jim wood » Fri Aug 04, 2017 1:36 pm

I think we'll need more detail than that. I've some funnies over time when specifying the elements for every dimension in a source view but I'm not sure if these are related.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

Drg
Posts: 62
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Process does not update updateable cell

Post by Drg » Fri Aug 04, 2017 1:43 pm

turn on logging on this cube and run you process. check transaction log after.
or use textoutput(),LOGOUTPUT() function on your process to find your error.

TMinorK
Posts: 3
Joined: Fri Aug 04, 2017 10:52 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2 RTM
Excel Version: 2013 Pro

Re: Process does not update updateable cell

Post by TMinorK » Mon Aug 07, 2017 7:05 am

The "main" problem is that the non-updating happens apparently randomly: usually the process updates the cell as desired, but then (after several successful executions) it does not. When (if) we notice the error and run the process again, it works. We've been facing this for about a year, previously it never happened.
We experienced the problem with several processes, and it effected both numeric and string cells. I have no idea about how to localize the "bewitched" processes or how to reproduce the phenomenon intentionally.

Drg
Posts: 62
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Process does not update updateable cell

Post by Drg » Mon Aug 07, 2017 9:23 am

use textoutput() function on your process to create snapshot of action on the TI script.

Check rule on cell where you don't see you data(maybe on some action of users cell lock's CellIsUpdateable etc...).

Faced in same trouble wheen copy data from version to version.
We check al ldata flow and find rule on cube A who lock cell on Cube B if in cube C cell null.
then change load data sequence first load Cube C then Cube A then Cube B
As an option why it might be...

Edward Stuart
Community Contributor
Posts: 191
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester

Re: Process does not update updateable cell

Post by Edward Stuart » Mon Aug 07, 2017 9:45 am

Is this a last values wins scenario?

If you know there are target cells that are not updating, then you can ASCIIOUTPUT/ TEXTOUTPUT for those cells only and check if they are being written/ overwritten/ being targeted as required

Has the code in the processes changed? Does the data source change? Have you upgraded? etc.. etc..

Post Reply