Yesterday I've spent a day to test Microsoft Business Analytics for
Navision (BA) with Elena Bianchi (MS). I've talked in the
past about this tool on my blog and here I want to signal a little problem that
could occour during your work with BA.
After a cube creation from Navision, you've to launch the
Configurator (BAConfigurator40.exe) to export the
cube definition to your OLAP database: this tool does this for you via XML.
However, if you launch this update phase multiple times (and this is normal
if you want to modify your cubes definition) you can impact on this error:
The message here is in italian language (sorry) and it says essentially
that is impossible to remove the Business Analytics OLAP database and the cube
creation can't be done. To solve this problem, simply you have to stop the
Business Analytics Server process:
The process is called ANTserver (there's also
a Daemon called ANTDaemon but normally you don't
need to stop it). Stop it, launche the Business Analytics Configurator and when
the cube configuration is finished restart the process.
Now you're ready to work with your new cube! 