Forum Discussion

Putra_Bala's avatar
Putra_Bala
Copper Contributor
Jan 29, 2020

Microsoft Office Implicit Intersection Operator "@" impacting TM1 "DBRW" Database Write Back Formula

Here is the link on Microsoft support page with regards to the implicit intersection operator (i.e. @ and {}) being automatically added to old Excel files created in older version(i.e. MS O365 32-bit Ver 1907) when opened in a newer Excel version(i.e. MS 0365 32-bit Ver 1912).

Although it states clearly in the Microsoft Support site that this change will not impact the functionality, but it does for TM1’s IBM Planning Analytics Local and Client Version 2.0.7 “DBRW” formulas with multi cells array especially during write backs to TM1 database

(i.e. “=@DBRW(T$21,T$22,$I$46,$I$47,$H65,T$23,T$24,T$25,T$26,T$27,T$28,T$29,T$30,T$59,T$60)”).

 

https://support.office.com/en-gb/article/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34

 

Any thoughts on how this can the default automatic implicit intersection operator "@" can be disabled on MS 0365 32-bit Ver 1912?

7 Replies

    • Putra_Bala's avatar
      Putra_Bala
      Copper Contributor

      SergeiBaklan 

      So how will TM1/IBM Planning Analytics DBRW formula work to write back to the database?

      Are there no other organization facing similar issue? How do they work around this? Any interim solution? 

       

Resources