We are upgrading from BPC 7.5 MS to 10 MS. I am facing several issues with Excel reports. Dynamic Report Templates which were created in the old version are not expanding in the new version.
1. The EXPAND button is disabled.
2. The "Row Expansion" property in the Expansion Settings is invalid.
3. When clicking the "Expand" command button in the template, the error message is displayed "Cannot run the macro 'MNU_ETOOLS_EXPAND'. The macro may not be available in this workbook or all macros may be disabled".
I tried with EPM macros "Refresh" and "Expand" after referencing FPMXLClient in VBA. My code is pasted below. But it is not expanding. Could you help me please.
Dim EPMObj As FPMXLClient.EPMAddInAutomation
Set EPMObj = New EPMAddInAutomation
Set EPMObj = Nothing End Sub
I have attached a screen shot also for your ref.
Thanks in advance