The efficient way to repair broken EPM report

[Former Member]

Hi experts,

I'm looking for the efficient way to repair broken EPM report.

In following cases, the relevant EPM reports are broken and I can't push "Edit report" (gray out) and lose connection to model...

i) In removing dimension from a model (ex. rename dimension ID, add & delete it)

ii) in removing member which is located on page axis of EPM report.

To avoid the situation, I make a point of taking following measures:

i) - clean up the dimension that I want to delete from axis of EPM report before remove it from relevant model

ii) - clean up the member from EPM report before removing it.

However these measures terribly bothered me if number of relevant EPM reports is too large... If these reports can connect to model or be able to "Edit report", the work will be more efficient.

Do you mind if you tell me a good idea?

Regards,

Masa

[Former Member · Accepted solution]

Hi Massayoshi,

Try add the member back, change the member in your sheet to another member. then try delete the member again.

Andy

[Former Member · Accepted solution]

Hi Andy,

Thanks for your help. I succeed to repair broken EPM reports by the way you informed.

Thank you again !

best regards,

Masa

[Former Member · Accepted solution]

Hi Masa,

My pleasure, glad to help.

Andy

[former_member186338]

Hi Masa,

Not very clear, can you provide some simple test case?

With screenshot and some explanation!

Vadim

[Former Member]

Hi Vadim,

Here's the example in appearing issue ii).

No i) is my misconception, sorry...

in opening the broken EPM report:

This dialog appears if the member that has already removed is located in pase axis. Unfortunately, this broken report isn't able to execute "Edit Report".

My question is how I can repair the report by something to do. Please help me...

Best regards,

Masa

[former_member186338]

Hi Masa,

Just tried to recreate an issue.

1. New member created in CATEGORY dimension.

2. New report created with CATEGORY in the page axis and the new created member selected as a page axis member.

3. Report refreshed saved and closed.

4. Logged off from BPC.

5. The new member deleted in the admin interface, dimension processed.

6. Logged on to BPC in Excel.

7. Open the saved file with the deleted member in the page axis.

8. Refresh - no issues. Edit report - no issues.

EPM SP18 Patch 2 NET 4

Vadim

P.S. The deleted member is replaced by some existing member in the context....

[Former Member]

Hi Vadim,

Thank you for your help! In our environment, the error occurs at procedure 7, because of our  EPM version is 10.0 SP16 patch1 NET3.5??

I'll try to upgrade EPM support package level.

Best regards,

Masa

[former_member186338]

Try to upgrade EPM - easy procedure without risk! You can always return to the old version with complete uninstallation.

Vadim