Skip to Content
0
Former Member
Oct 16, 2013 at 08:20 PM

BPC Web reporting issue

55 Views

We have been running BPC v10 (MS) for several months. We just recently started using the BPC-Web reporting functionality (mainly use BPC-Excel). I have noticed right away that some formulas in BPC-Web reports do not show up on my reports. And, it appears to be random. For instance, the calculation of gross margin (margin/sales) works fine in BPC-Excel. However, when i create a report in BPC-Web for the display the same data, the figure is often not displayed. I have accounts in my rows, and category in columns. I do see data for my actual column of data, but nothing in plan or forecast. Yet, I have verified data exists by running BPC-Excel reports with same parameters. To make matters more confusing, when the 'chart and report' option is selected in BPC-Web, the chart accurately reflects the proper data, it is just not shown on the report.

for example, my report in BPC-Excel shows this

GM%

act pln fcst ly

widgets 8% 9% 10% 19%

However, the same report created in BPC-Web shows this:

act pln fcst ly

widgets 19%

However, the chart in the BPC-Web report accurately reflects the proper percentages of 8%, 9% ,10%, 19%

The GM% is a simple formula calcation mantained in the stat accounts in the account dimension.

Anyone have any ideas how to correct this in the BPC-Web reports?

TIA,

Todd