- Download the manual for the Analysis Cubes setup here
- After you have deployed your cube, navigate to your Data Warehouse database in SQL Management Studio (default name is GPDataWarehouse or somehting)
- Find the dbo.GLBudgetsetup table
- Right click, edit
- This contains a list of your GP budgets
- Find the correct budget you want to enable
- Update the BudgetForecast column to say "Budget"
- Update the UseForReporting column to say "Yes"
- Run your synchronization routine to refresh the Data Warehouse (the SQL server agent job)
- Run the cube population routine to refresh the Cube (the SQL server agent job)
Wednesday, January 9, 2013
Dynamics GP Analysis Cubes - How to Enable Budgets
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment