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.
"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!
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.
It's a standard VBA for Excel sheet copy! Google "VBA Excel sheet copy" :) Nothing to do with EPM API!