In my previous post about Business Analytics for Navision 4 (BA), I've explored some features of the product and I've showed how it's really powerful for data analysis.
However, before start working with the product there's the installation step to pass and it's not so easy as you can imagine (it's really easy to install the product itself but not to interact with Navision).
First, you need a SQL Server machine with Analysis Services installed (but this is the requirement). Then you've to launch the Business Analytics Autorun setup and (after the language choice) select the Server menu and then Business Analytics Basic or Business Analytics Advanced (the only difference is that if you select the Advanced option you can install Server and Client components together). For a stand-alone installation you have to install server and client components.

After the Server installation, you'll find a new Configurator folder that contains the executable application used from BA for cube creation (BAConfigurator40.exe) and the Common folder:

Remember that the default installation folder is C:\Program Files\ Business Analytics and it's always created, also if you choose a different folder.
The next step is to install the Client application:

If you select a Custom setup, you'll see that the components that must be installed are these:

You have to start the installation process with the selected components and at the end you'll see the folder below:

and two OCX files are installed on the Common Files folder of your machine:

The simple part is finished, now arrives the tricky part (hard because it's not documented)...
Open your Navision 4 and select the Administration menu, under Application Setup, General, Business Analytics Setup. Press the Lookup button near the Name field, as in the figure below:

The Database BA window will appear. Here is where you have to setup the Configurator path (BAConfigurator40.exe):

and after that you've to update the XML file that contains the cube structure by pressing the Function button and select Update XML:

The next step is to create (or update) the BA database and to do this you've to select Function and then Start Configurator. Now start a big task where a database is created and cubes are evaluated and elaborated. If the creation process is good, you'll obtain a message like this:

The warning only tells you that the SQL Server Agent is not in use and you need to use it to schedule the data mart update. No problem, all is correct! 
After this step, if you open your SQL Server with Enterprise Manager you'll see a new database called BA for MBS - Navision 400, with a SQL Server Agent job and 4 DTS:
- BA for MBS-Navision 400 – Initialize
- BA for MBS-Navision 400 – Post Process
- BA for MBS-Navision 400 – Process Cubes
- BA for MBS-Navision 400 – Transfer – [companyname]
and a new folder in C:\Program Files\Business Analytics called Custom DTS Tasks with these files:

Now you've to configure the BA service to use this new database and to use the navision license (that must contain the BA granules). To do this, from the BA installation menu simply select Server --> Business Analytics Advanced --> Configure Business Analytics Advanced:

The installation checks the DB and prompts you for the Navision executable path (where you've to place the Navision license):

Now you're ready to go and the installation ends with this window:

The setup process is finished. Now if you start your Business Analytics you'll find that it's connected to the new database (empty). You're ready to start work and interact with Navision.

Simple?
Unfortunately (and I don't know why) there's no documentation available for lots of this MBS tool and sometimes it's very tricky to find solutions. I hope that this little post could be a guide and an help for all that will want to try this new (and powerful) tool. I want to thank my friend Elena Bianchi (MS) for her helps on the configuration.