Hi All,
I have deployed the Microsoft Financial Cube, but GL Budget - Amt is always coming zero even though there is data in GL00201. Let me know what can be done.
Thanks,
Attiqe
*This post is locked for comments
My first post talks about that the field needs to be updated to Budget or Forecast. Budgeting in Analysis Cubes works very specifically so you should really read the documentation to understand what you want for a value in these fields - Budget or Forecast. You also need to switch the UseForReporting column to Yes for the budgets you want to use.
Thanks Kirsten, can you give me a sample value for that?
The BudgetForecast column needs to be manually updated. I would recommend reading the documentation on budgets for Analysis Cubes to be sure you get this table updated correctly to get data into your cubes.
Kristen,
I am not sure I am following up so I am attaching the image of the GLBudgetSetup table, let me know what to do next.
Thanks,
Attiqe
e
Have you Specified your budget ID's: Specify budget IDs for Budget and Forecast values
The GLBudgetSetUp table in the data warehouse database includes the budget IDs for the Microsoft Dynamics GP companies that you selected to import data from.
After you install Analysis Cubes, you must use SQL Server Management Studio to specify the budget IDs in the GLBudgetSetUp table that will be used to calculate various Budget and Forecast values in the cubes. You must select budget IDs for each fiscal year.
To specify that a budget ID will be used for Budget values, enter Budget in the BudgetForecast column for the budget ID. To specify that a budget ID will be used for Forecast values, enter Forecast in the BudgetForecast column for the budget ID. For each budget ID that you specify to be use for Budget or Forecast values, you also must enter Yes for that budget ID in the UseForReporting column.
After you make changes in the GLBudgetSetUp table in the data warehouse database, you must run the master Integration Services packages and the OLAP processing package for changes to be reflected in the cubes. If you scheduled the packages, the data warehouse and the cubes will be updated at those times. See Populate the data warehouse database and Process the cubes for more information.
And ran the DynamicsGP_<source_db>_to_<warehouse_db>_Run_GL_Budgets_Master package?
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
