Skip to Content
0
Dec 09, 2013 at 11:25 AM

Dynamic Report Templates not expanding in BPC 10 MS

58 Views

Dear Experts,

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

EPMObj.RefreshActiveSheet

Set EPMObj = Nothing End Sub


I have attached a screen shot also for your ref.


Thanks in advance

Roy Sebastian

Attachments