Default Report missing from Report Connections

[Former Member]

Hi guys -

After I did some change to the input form template, found, the Edit Report option is grayed out. Also, at the same time, I noticed the Default Report from the Report Connections is missed if compared with the original version one which still visible - (please find the attachments for your reference).

Apparently, ALL the other BPC templates are working fine apart from the one I did some changes recently. I have tried all kind solutions until re-install the EPM application but the result still the same.

Since the changes have took me one working day so I am really hoping that someone have the similar problem and it have been resolved before.

Thank in advance for your all help. !

Thanks,

Hardip

[former_member186338 · Accepted solution]

Looks like some sheets on your workbook are not containing any EPM reports! The reports are corrupted and you have to recreate... or recover from a backup copy.

Vadim

[Former Member · Accepted solution]

Hi Vadim - Thanks for the feedback!

Not sure how but it's confirmed that some of the EPM formulas are deleted. I believe the formulas were removed by MS Excel when I tried to recovered it during the Excel crash. Although I'm using the MS Excel 2010 64bit but every time I open a BPC report quite often the BPC report will crash and something my computer will turn into a slow mode.

Solution: I have re-create those reports.

Thank you, everyone, for all your help!

Thanks,

Hardip

[Shrikant_Jadhav]

Hi Hardip,

I think your report is corrupted. Can you check in connection manger whether the connection is pointing to other model or server.

Also check VBA code for any connection related activity.

Shrikant 

[Former Member]

Hi Shrikant - Thanks for the feedback!

Do have any ideas how to check the VBA code for connection related activity?Currently, the report is consist of two macro of VBA code buttons which are the Refresh and Save. Sharing the codes as following as for Refresh its have the message prompts once the completed refresh;

Refresh:

Sub Refresh()

On Error GoTo CalcBack

Dim EPMObj As New FPMXLClient.EPMAddInAutomation

EPMObj.RefreshActiveWorkBook

CalcBack:

   If Err = 0 Then MsgBox "Refresh Complete!" Else MsgBox "Error during refresh" & vbNewLine & Err & ": " & Error(Err)

End Sub

SAVE:

Sub Save()

Dim EPMObj As New FPMXLClient.EPMAddInAutomation

EPMObj.SaveAndRefreshWorkbookData

End Sub

Thanks,

Hardip

[Shrikant_Jadhav]

Hi Hardip,

If this is the total code then there is no code related to connection.

Have you checked in name manager ?  (Formulas - > Name Manager )

Just for trial and error, activate member recognition and try to add new member.  

Shrikant

[Former Member]

Hi Shrikant -

I have tried to mapped the name manager links back to the original template and removed the unwanted one, unfortunately, it's still failed.

Also, looks like the Member Recognition option doesn't worked on the sheet. Maybe you are correct the report is corrupted. Errr.

Thanks,

Hardip

[Shrikant_Jadhav]

Hi Hardip,

Try one more thing, save this report on server and open it from other machine.

Other wise you have to re create it.

*While modifying report have you added new master data & used it in that report , and then deleted before you open the new report ? ( it happens sometime - non standard behavior )

Shrikant