Skip to Content

Worksheet generation

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    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

  • 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