Tuesday, December 15, 2015

The forecast has not been generated. The Database with 'Name' = Demand Forecast initial Test' doesn't exist in the collection.




Hi There!

I hope everyone is having a good week so far.
 
On another note, I have been working on a few issues around demand forecasting in AX2012 R3 CU8, and after our infrastructure team installed the Analysis services, users were getting the following error:

"The forecast has not been generated. The Database with 'Name' = Demand Forecast initial Test' doesn't exist in the collection."

The actual solution is pretty simple, but I thought the resolution from LCS was too general and it did not provide the details I was looking for. If you access LCS Issue Search for this specific issue (https://fix.lcs.dynamics.com/Issue/Solution/834451?bugId=1703068&qc=70e497218e943038e1e3d5bb836399fc9cfcbd2e3447897bcbd793236dcf12fd), you will see the following statement:

"Add the AOS service account to the OLAP Database Roles."
 
Great!, pretty straight forward, but which role and database? The following are the steps that will hopefully help someone save some time on this.

STEPS

A user runs the Demand Forecast in AX and gets the following error message - The forecast has not been generated. The Database with 'Name' = Demand Forecast initial Test' doesn't exist in the collection.


 


To solve the problem these are the steps to be followed:



1.Go to the Analysis Server and look for the Demand Forecast Initial Database and Expand the Roles node.
2.Right click in the Production Planner and go to properties.
3.Go to Membership and click Add.
4.Add the AOS AX Service account.



That's all for now. Have a great week!