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...
BI & Data Analysis
excel
Formulas and Functions
Macros and VBA
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 30, 2020

Putra_Bala 

I don't think it can be disabled, implicit intersection doesn't work in silent mode any more.

  • Putra_Bala's avatar
    Putra_Bala
    Copper Contributor
    Jan 30, 2020

    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? 

     

    • JimGeraci's avatar
      JimGeraci
      Copper Contributor
      Jun 09, 2020

      Putra_Bala Did you ever find an answer to this?  Did you open a case with IBM?

      • Putra_Bala's avatar
        Putra_Bala
        Copper Contributor
        Jun 12, 2020

        Hi JimGeraci ,

         

        Yes, I got this resolved. Apparently you can do a find "@" and replace with "" on the impacted Excel report sheet/workbook. This was the solution provided by IBM.

        I did open a case with Microsoft as well and did have some discussions with them about this.

        They informed that they have switched-off the implicit Intersection Operator from being default in the future releases of Microsoft updates(Version 2003 - End of March 2020 onward).

         

        Regards,

        PB

Resources