Wednesday, January 9, 2013

Dynamics GP Analysis Cubes - How to Enable Budgets


  1. Download the manual for the Analysis Cubes setup here
  2. After you have deployed your cube, navigate to your Data Warehouse database in SQL Management Studio (default name is GPDataWarehouse or somehting)
  3. Find the dbo.GLBudgetsetup table
    1. Right click, edit 
    2. This contains a list of your GP budgets
    3. Find the correct budget you want to enable
    4. Update the BudgetForecast column to say "Budget"
    5. Update the UseForReporting column to say "Yes"
    6. Run your synchronization routine to refresh the Data Warehouse (the SQL server agent job)
    7. Run the cube population routine to refresh the Cube (the SQL server agent job)

No comments:

Post a Comment