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.


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!


Saturday, January 24, 2015

TFS Online - Creating and Connecting to TFS Online with AX2012


Hi There,
I hope everyone is having a great weekend so far, and that you are ready for a great post about TFS Online and how to connect to it.
Before continuing with the step-by-step directions on how to connect to TFS Online, I wanted to share a few links that I think will of interest to you if you are looking to go with this option in your Microsoft Dynamics AX implementation. In addition, really soon I'll post my view on branching and what might work best for a big implementation. Also, I'll be posting information on how to use the Scrum template. This is creating features, backlog items, sprints, associating sprints with backlog items, and these with features, etc.
What is visual studio online?
Visual Studio Online Pricing
With the above out of the way, let's jump into creating a new visual studio online project, and connecting to an instance of AX2012R3. In the following steps I'm assuming you already have a Visual Studio Online account, and that you have your repository and branching implemented (although I will cover this topics very, very soon).
  • Go to https://YOURPROJECTNAME.visualstudio.com/DefaultCollection

  • Go to control panel, and click DefaultCollection. Once there go to administration tasks and choose the option create new team project as shown below.
  • Give your project a name and choose a process template. In my case I chose an Scrum template. For more information on process templates go to this link.
  • Once you create your new Visual Studio Online project, you should see the following.
  • At this step is where you would have to create your branches, and local server (or workstations) repositories. The following is a quick guide to branching, simple but very effective, click this link to open it.

  • After your branching and repositories are good to go open a development work space in AX2012R3 (or earlier), and go to Version Control / Version Control Parameters
  • Under General fill out the following information:

a.     Version Control Status = Enable
b.    Version Control System = Team Foundation Server
c.     Repository Folder = [Choose a local repository]
d.    Mark the two check boxes (as shown below)

  • Under Team Foundation Server fill out the following information

a.     Team Foundation Server URL = https://YOUR-PROJECT-NAME.visualstudio.com/DefaultCollection
b.    Team Foundation Project Name = YOUR PROJECT NAME
c.     Branch Folder = YOUR BRANCH (i.e. Development, QA, UNT, etc)

  • If you are using the Visual Studio 2010 SP1, you'll be fine. If not you'll get the following error
  • To resolve this, please follow the steps:

b.    Download and install the KB2662296

  • Once you have installed the above KB, restart your AOS and open AX2012R3 again. You'll see the following screen, which means that after signing in, you are ready to start enjoying the benefits of TFS online.
This is all for now. Remember to check my blog for updates on how to use (in my own way that is) the ALM features that TFS online offers.

Have a great week ...