How to create actual vs budget and variance report?
We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two.
However, oracle support pointed us to documentation saying this is not feasible since FRWS does not draw information from budgetary control cube.
How To Compare Actual Scenario Vs Budget from control budget By FRS (Doc ID 2514267.1)
We have tried the subject areas Budgetary control - Transactions real time as well as balances real time but there is not option for defining parameters PTD and YTD.
Could someone suggest the appropriate reporting tools to use to achieve the two results depicted below?