Planning Analytics with Watson

Expand all | Collapse all

REST API - Cell Updateable Values?

Jump to Best Answer
  • 1.  REST API - Cell Updateable Values?

    Posted Mon October 21, 2019 09:07 AM
    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.

    Cell Updateable
    For example: Ordinal 0 with Updateable 268435716 is now a rule calculated String, The rest are simply writable string.
    (TM1 Build Number: 11.6.00000.14)





    ------------------------------
    József Buzás
    ------------------------------


  • 2.  RE: REST API - Cell Updateable Values?
    Best Answer

    Posted Mon October 21, 2019 09:27 AM
    See here: https://www.ibm.com/developerworks/community/forums/html/topic?id=134b7119-d1a1-4e7c-976b-0f2fc452dfeb

    ------------------------------
    Sean McDowell
    ------------------------------



  • 3.  RE: REST API - Cell Updateable Values?

    Posted Mon October 21, 2019 09:32 AM
    Wow Sean. Thank you for the quick reply.
    I have no clue why Google wasn't my friend this time.

    ------------------------------
    József Buzás
    ------------------------------



  • 4.  RE: REST API - Cell Updateable Values?

    Posted Sun June 27, 2021 01:38 PM
    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
    ------------------------------



  • 5.  RE: REST API - Cell Updateable Values?

    Posted Mon June 28, 2021 01:55 AM
    29th bit indicates if it is updatedable, and the following tells you why



    ------------------------------
    Ryan Clapp
    ------------------------------



  • 6.  RE: REST API - Cell Updateable Values?

    Posted Wed June 30, 2021 09:40 AM
    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
    ------------------------------