Overall Satisfaction with SAP BPC (Business Planning and Consolidation)
We use BPC for consolidations and eliminations for SEC filings as well for projections and forecasting. It allows for one source of the truth for month end reporting. Only accounting and finance employees have a BPC license. Financial statements and other reporting is pushed to our field users (GMs, VPs, etc).
- Accounting and finance users love this tool because reports are built using native Excel. If commands such as EPMCopyRange are utilized it can further the use of native Excel.
- Compared to BPC 7.5 our elimination and consolidation logic runs in a fraction of the time. Processes that would take multiple days can be accomplished within hours.
- Powerful and dynamic reports can be built to help business leaders make decisions and see trends.
- There is missing functionality on the ability to use the dynamic filter on apply a property when using the excluded members tab of the report editor. We are currently running SP30 BPC 10.1 and the ability existed in previous service packs. We now have to manually exclude some dimensions. We use member exclusions on our income statement tabs to help clean up the multiple total lines that appear when having two dimensions in the row running on member and descendants.
- In SP 30 and some of the later BPC 10.1 service packs, when a user searches for a dimension member, it displays the dimension member the number of times it shows up in another hierarchy. In previous service packs, when searching for a dimension, it would display the dimension member within the first hierarchy it appears in and then if the user clicked next, it would jump down to show the dimension member within the next hierarchy it is a part of.
- BPC is not able to handle to calculated member formulas in a report. For example, if a calculated profit center and a calculated datasource are used in a column of the report, BPC is not able to correctly compile and display the correct value for both calculated members.
- We are able to arrived at our post consolidated/elimination figures much quicker than in years past. We are able to rerun logic packages now rather than book topside entries because the packages run so much faster than BPC 7.5.
- One area that we are struggling with is the ability to run all of our income statements down to a profit center level and effectively distribute them to non-BPC users.
This decision was made as we were previously Outlooksoft customers.