EPM Local Members Go Away After Refresh Report

[former_member595001]

Hello,

I created a custom report for one of my co-workers and everything seems to be fine but all of a sudden the two local members I created delete (vanish) when I refresh the report when I change months, but stays when I change entities for the current month I have set up in context. The two local formulas I'm using are an EPM Comparison formula and an normal excel calculation showing the variation as a percentage.

All my other tabs with local members don't have this problem. They're in my formatting sheet and everything, so I'm quite confused on what is happening.

I'm on version 10.0 SP 30 Patch 2 .Net 4.5 x64. I'm on the MS version of BPC, not NetWeaver and I'm using MS Office 365 ProPlus.

Thanks,

Will

[former_member595001 · Accepted solution]

I figured out the problem. For some reason the variance local member was fixed to the one month instead of being dynamic with context.

[former_member595001]

Hello Harsha,

The check sum is a row formula that makes sure the P&L matches to make sure there's no accounts missing. It's the variance local member formula is the problem I'm having. I don't think the check sum is causing the issue.

Thanks,

Will

[former_member399404]

Hi Will,

What's your formula for Account's check sum?

Thank you

Regards,

Harsha