Skip to Content
avatar image
Former Member

Problems with Distribution functionality since we upgraded to EPM SP29.2

Oct 17, 2017 at 06:57 PM | 48 Views

We have a few distributions PDBooks and Books which we have a problem since we upgraded from EPM SP22 to SP29.2. (we are on BPC 10 NW).

In our Books we have a "Home" sheet that contain EPMContextMember formulas in some cells which have a Range attached to them.

The "Home" sheet is then hidden because we don't want to show that sheet in the distributed reports created by the distribution. In the other sheets which contain reports there are some formulas that link to the Range of the Home sheet, to show the Costcenter as a title row for example.

Since we have upgraded to EPM SP29.2 the hidden Home sheet is not created in the distributed reports, so all of our formulas in the other sheets that are link to the Range of the Home sheet show #REF.

Is there a reason why we have this issue with SP29.2 ???

EPM Add-In for Excel
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Vadim Kalinin
    Oct 18, 2017 at 12:22 AM

    Can you create a simple test case (2 sheets, one hidden etc)?

    And post detailed screenshots of the issue?

    Add comment
    10|10000 characters needed characters exceeded