Skip to Content
avatar image
Ram Krishna

Worksheet generation

Apr 13, 2017 at 06:32 PM | 272 Views

I have EPM report with 5 sheets, which has one report per sheet. Customer needs to do worksheet generation for 15 cost centers which will be selected at random out of 500 cost centers. Once seelcted the sheet generation need to happen for all
5 reports for the same 15 cost centers. Means 5 reports and 15 sheets 75 will be generated. Now customer want to selected the cost centers only once for work book, rather than one each for report and generating. Is it possible to achieve this with standard features of BPC? Appreciate inputs.

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

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Vadim Kalinin
    Apr 13, 2017 at 06:37 PM

    "Now customer want to selected the cost centers only once for work book...

    Is it possible to achieve this with standard features of BPC?" - No!

    Use VBA to perform worksheet generation!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Ram Krishna
    Apr 17, 2017 at 03:40 PM

    Is there standard BPC API macro that can be used for sheet generation. If so can you give the name. I was searching but could not locate one in this regard.

    Add comment
    10|10000 characters needed characters exceeded