I came across this sometime back now. The “Goal” value in the Profitability Analysis report on RoleCenterpage pages does not show the budgeted values.
Going through the KPI underneath the Report I found:
-The general ledger KPIs in the analysis database does not take into account any budget defined in AX Client as the goal of the KPIs. Instead however they shows the goal as being a fixed percentage (99% for COGS) of the last period (or 0 when the last period is empty) (You can open the general Ledger cube in BIDS/VS and on the KPI tab verify the Goal expressions for each KPI defined in the General Ledger cube)
- Discussing these findings with my Financial Escalation Engineer we concluded the reason for using these fixed values is because Budgeting is not required for accounts and without, these KPIs would always show a 0 goal value.
Having a fixed value based on the previous period appears we could apply a simple workaround to this to show budgeted values:
Reverse engineering the Profitability report for the COGS KPI we submit the following MDX query (Demo data with Fiscal Year 2006-07-1 period 2006-08-01 (Currency USD))
The Value expression of this COGS KPI is defined as below where it can be found we’re getting the [Master Amount - Ledger] measure for Ledger account category “35” (COGS)
With this expression it’s easy to formulate the budgeted COGS the value Expression for this will be
Through replacing current COGS KPI Goal expression with budgeted COGS value (from above) and saving the modified KPI, the KPI (and profitability analysis report) shows you the Budgeted COGS as the Goal value.
Repeating the similar steps for each KPI defined in the general Ledger account groups where you’re budgeting makes your budgets show up a the goals value in the KPI / Profitability report.
Further Information:For testing the expression with the Contoso demo data I used the Query below
Disclaimer: This programming example is for illustration purposes only. Microsoft disclaims all warranties and conditions with regard to use of the programming example for other purposes. Microsoft shall not, at any time, be liable for any special, direct, indirect or consequential damages, whether in an action of contract, negligence or other action arising out of or in connection with the use or performance of the programming example. Nothing herein should be construed as constituting any kind of warranty.