Hello Gurus,
Today has been more of a learning experience when it came to working in BPC, for the first time.
I had a series of doubts and rather than posting it one by one, I thought I will bring them all together into one single discussion.
(1) Is it possible to have a Variable Screen / User Prompt for a BPC report.
(1.1) If yes, How do I maintain the Variables for the Variable Screen
(1.2) Where do I maintain them
(2) I have a report that has been setup with Forecast values, and this report is run at the end of every month
Account Forecast Month1 Forecast Month2 Account1100
200 Account2 110 210 Account3 120 220At the end of the month, when the report is run, the report will have data updated for that month.
Report run at the end of Month1 - where Actual data is posted into the report
Account Actual Month1 Forecast Month2 Account1 456789 200 Account2 123456 210 Account3 789123 220Kindly provide guidance how to come around this output, I understand for the month end - we need to run the load, but how is it that we can overwrite the Column value Forecast Month1 - Actual Month1, based on the output from the data load; Basically the data in the columns should be overwritten, it could be a Bonus if possible you could tell me how to overwrite Header values as well.
(3) I would like to publish the BPC reports; can we publish BPC excel reports? How can I publish BPC reports?
I look forward to your expert opinions and responses.
Thank you.
Leonel Sachin
Sorry, but really hard to understand!
What do you mean by "Variable Screen / User Prompt"???
We use 12 forecast versions to prepare at the beginning of each month.
FC01-FC12
At the beginning of February we copy (using DM) Jan from Actual and the rest months from budget
Then users are able to correct FEB-DEC
Ater correction it's the final version of FC01
At the beginning of March we copy (using DM) Jan-FEB from Actual and the rest months from FC01
...
Vadim
Add a comment