How to install Business Analytics for Navision

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.

Print | posted on Monday, July 04, 2005 9:47 PM

Comments on this post

# Navision Business Analytics: a thing to remember.

Requesting Gravatar...
Left by STEFANO DEMILIANI WeBlog on Jul 27, 2005 2:41 AM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
thank you for this, spent few hrs @ mbs but had to resort to google to get this info. saved me thrashing my computer. there are still some good folks around.
Left by joe maz on Aug 25, 2005 11:27 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
I suggest MS to hire you
Left by Carlo Audisio on Oct 04, 2005 12:59 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
Thanks guys
Left by Stefano Demiliani on Oct 04, 2005 2:30 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
I am a problem when create the BD with aplicattion baconfigure40.exe:

The message say that one ilegal caracter is in baconfigurator40.exe -tsql etc etc.

I´m bored with this problem.
Left by juan antonio on Nov 08, 2005 1:40 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
What do you mean with "BD"? Can you report the error message please?
Left by Stefano Demiliani on Nov 08, 2005 2:08 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
-The file name "c:\program files\..\baconfigurator40.exe" -tsql -s"lab010" -d"Navision" -c"Cronus" -w -lESP contain a ilegal character." when Star Configurator happen of update XML.
Left by juan antonio on Nov 08, 2005 2:36 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
The error message is:
The file name "C:\Program Files\Bus....\BAConfigurator40.exe" -tSQL -s"DIMITRIS" -d"Cronus"
-c"CRONUS" -w -lENU contains a character that may not be used.
Please check the file name. You can find additional information on file
names in the documentation for your operating system.
Left by juan antonio on Nov 10, 2005 10:53 AM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
HOw does Navision know what the liecence file is called? *.flf but what goes in place of the star?
Left by Steve on Mar 01, 2006 12:44 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
fin.flf is the standard name.
Left by Stefano Demiliani on Mar 01, 2006 6:55 PM

# Navision Business Analytics on SQL Server 2005

Requesting Gravatar...
Left by STEFANO DEMILIANI WeBlog on Mar 08, 2006 2:40 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
Stefano, tnx for this article.

One question, I can't connect with BA Enterprise Manager to server from machines other then server itself - I can't configure client on client machines, I always get "Login failure".

When instaleld on server machine, client works great.

Do you have any hints ?
Left by Joe Kabash on Mar 15, 2006 1:06 PM

# how to get flf file

Requesting Gravatar...
I want to create flf file.
Left by mariyappan on Mar 07, 2007 4:42 AM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
Hi all,

If i trying to start the configurator, it showing some error as "Error During initialization" "Access violation at address in module BAConfigurator.Exe"

Please do the needful.

Left by Divya on Jun 18, 2008 1:13 PM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
getting error in installation of BA configuratior while ""create sql server agent job"" and the error is :::: ""executenonquery failed for database 'msdb'."".

Please do the needful..

Thanks in advance..

lokesh.sharma47@gmail.com
Left by lokeshsharma on Oct 18, 2008 8:44 AM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
I am having problems, only one cube has come through to Business Analytics, how do I get all the cubes through? Is there something I have to do to open these from within BA?

Kind regards

Andrew
Left by Andrew Cooper on Oct 01, 2009 9:46 AM

# replica jewelry

Requesting Gravatar...
I am having problems, only one cube has come through to Business Analytics, how do I get all the cubes through? Is there something I have to do to ope
Left by replica jewelry on Apr 29, 2010 5:22 AM

# chanel logo earrings

Requesting Gravatar...
Anyone who watches Reality TV knows Heidi Klum's tagline in Project Runway-- "In fashion one day you're in, the next day you're out". <h2>louie vitton</h2> But a look at what is happening at London Fashion week will prove that Fashion is moving a lot faster than what Miss Heidi has anticipated. <h2>Links of London Pink Drops Bracelet</h2> Thanks to digital and social media, reactions to what's hot and what's not pile up to millions by the time your minute rice comes to a boil.
Left by jewellery earrings on May 11, 2010 4:35 AM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
Hello,
When start Configurator in MS Dynamics Nav 2009, the windows "BA Configurator" check for Analysis Services 2005 -->Error.

Help, please!!.

Thanks.
Juan.
Left by Juan on Jul 12, 2010 11:58 AM

# re: How to install Business Analytics for Navision

Requesting Gravatar...
If i trying to start the configurator, it showing some error as "Error During initialization" "Access violation at address in module BAConfigurator.Exe"
Left by C++ Source Code Directory on Jan 14, 2011 1:25 PM

Your comment:

 (will show your gravatar)
 
Please add 6 and 4 and type the answer here: