Forum Discussion
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
- SergeiBaklanDiamond Contributor
I don't think it can be disabled, implicit intersection doesn't work in silent mode any more.
- Putra_BalaCopper Contributor
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?
- JimGeraciCopper Contributor
Putra_Bala Did you ever find an answer to this? Did you open a case with IBM?