TM1 add in is up and running however, I’m having issues with Custom and Dynamic reports where DBRW formulas are not working. They are showing #NAME? instead of the values. Interestingly this is only for Custom Reports and Dynamic Reports. Explorations and Quick Reports work fine. Any ideas please?
G’day Sam. You need to make sure you have all three of the Planning Analtycis for Excel addins active. Please check the addins and make sure they are active per the following screenshot.
Go to Excel, Option > Add-Ins > Manage/ Check the list of ticked addins. IBM Cognos Office Reporting TM1 Addin needs to be active for Custom and Dynamic Reports to work. Without it, you will get #NAME? in your reports.