Hi Ryan
Many thanks for the reply - Hubert must be on holiday.
I have converted your example to binary, since presumably this is like the DisplayInfo that you get on an Axis-Tuple-Member, which comes back as a 4 byte integer, with the bits representing different things. I have also included the Decimal since that is what displays in JavaScript
I have put in the two values which I get back when the cell is updateable. The only difference between these two cells is that one has a picklist.
Would you mind confirming that what I think you mean by the 29th bit is correct? From what I have seen, things that are not updateable tend to return a very high value, but I have not had time to experiment as yet. I am really only bothered about the updateable side at the moment..
The other question is how did you find this out? I couldn't find it in any of the documentation.
@IBM The name of the property 'Updateable' is confusing. CellInfo might have been better.
It would be useful to get a further explanation of what is meant by some of these values, eg
TM1_CELL_UPDATE Is this just the opposite of the 29th bit where a 1 means it is updateable?
TM1_CELL_NOT_ENABLED_SECURE does this mean that the user does not have security access?
TM1_CELL_DIFFERS_FROM_BASE Does this mean that a consolidation has been overridden by a rule?
TM1_CELL_NOTUPDATEABLE Is my guess at the official constant name for this correct?
I will also do some checks on TM1_CELL_RULEDERIVED to see if it is any better than the RuleDerived Property which return True even if the Rule returns STET.
Regards
Paul
------------------------------
Paul Simon
------------------------------
Original Message:
Sent: Mon June 28, 2021 01:54 AM
From: Ryan Clapp
Subject: REST API - Cell Updateable Values?
29th bit indicates if it is updatedable, and the following tells you why
------------------------------
Ryan Clapp
Original Message:
Sent: Sun June 27, 2021 01:38 PM
From: Paul Simon
Subject: REST API - Cell Updateable Values?
Hi Sean or Jozsef
Do you know where this link is now, as IBM have got rid of developerworks. The links is no longer valid. The only help you get is to be directed to the Business Analytics Community. As Jozsef found, Google does not help. All the IBM Documentation tells you is that it is an Int.
Regards
Paul SImon
------------------------------
Paul Simon
Original Message:
Sent: Mon October 21, 2019 09:31 AM
From: József Buzás
Subject: REST API - Cell Updateable Values?
Wow Sean. Thank you for the quick reply.
I have no clue why Google wasn't my friend this time.
------------------------------
József Buzás
Original Message:
Sent: Mon October 21, 2019 09:27 AM
From: Sean McDowell
Subject: REST API - Cell Updateable Values?
See here: https://www.ibm.com/developerworks/community/forums/html/topic?id=134b7119-d1a1-4e7c-976b-0f2fc452dfeb
------------------------------
Sean McDowell
Original Message:
Sent: Mon October 21, 2019 08:11 AM
From: József Buzás
Subject: REST API - Cell Updateable Values?
Hi All,
Does anyone know, what are the valid values (and what does them mean) if you select the "Updateable" property of a Cell via REST API request?
Unfortunately, it does not work like the CellIsUpdateable in TI.
------------------------------
József Buzás
------------------------------
#PlanningAnalyticswithWatson