Business Analytics problems

afarr

I have been trying for the last several days to run Business Analytics on a Nav 4.0 SP3 database. I have read several posts about BA, as well as documentation, and I still have problems.
Here is what I am doing:

• I have a Navision 4 SP3 demo database (Cronus), installed on SQL Server 2000 on my local machine.

• I got the latest BA files for SQL 2000 from Partner Source (most of them dated 23/01/2007 or 28/02/2007), and I ran the following files:
BusinessAnalyticsSuite.msi
BusinessAnalyticsNET.msi
CustomDTSTasksBAforMBS40.msi

• In Navision, I specified the path to the configurator.

• When I click on Start Configurator, it uses Database authentication, and gives the following error:

Error during initialization.
Login failed for user ‘afarrugia’.


• I modified the configurator to use Windows authentication, and got a similar error:

Error during initialization.
Cannot open database “NAV_400_BUS_ANALYTICS” requested by the login. The login failed.


• I also have a separate Nav 4 SP3 database installed on SQL 2005. I managed to run the SQL 2005 configurator successfully; but then I couldn’t log in to Business Analytics (Server not found).

Do you know what I can do to get BA to work?
Any help would be very much appreciated.

Regards,
Alastair

kine

You are not doing it correctly.


After you installed the BA server, you need to generate the database for it. It means to go into NAV and generate some cube from there. The configurator (you need to install it) will generate the needed database on the MS SQL Analysis services. After that you need to run the configurator as separate process and it will configure BA server to use this new generated database, will change and set the authentication etc.

afarr

Thanks for your reply Kine.

I have created one or two simple cubes, and exported to XML, but I still get the same login problem.
(It doesn't seem to remember the location of the xml, and "Update XML" doesn't seem to be writing to any file; I don't know if this is part of the problem.)

You said that I need to install the configurator. I ran the following 3 installation files, the only ones I could find for BA - do I need to run some other file as well, or do something else?

BusinessAnalyticsSuite.msi
BusinessAnalyticsNET.msi
CustomDTSTasksBAforMBS40.msi

Thanks,
Alastair

kine

You need the BA Configurator. see page https://mbs.microsoft.com/partnersource ... page=false on partnersource. There are all downloads you need.

You are missing BAConfigurator_MSSQL2000.exe or BAConfigurator_MSSQL2005.exe based on which SQL you are using. This must be run from the NAV (Run Configurator) - generate XML is just generating the XML into Blob which is than used by the configurator.

afarr

Some progress - I found that by hardcoding the correct host name (as Kine had suggested in a different post), it logs in successfully, but now I get another error message:

Access violation at address XXXXXX in module BAConfigurator40.exe. Read of address ZZZZZZ.

I'll start working on that one now.
Thanks for the help so far.

afarr

I forgot to mention before -
I hadn't mentioned BAConfigurator_MSSQL2000.exe or BAConfigurator_MSSQL2005.exe because they're self-extracting files, rather than installation files, but yes I had downloaded and run them.
In the BA Databases window I put the path to the configurator, and then I went to Functions - Start Configurator, and got the message "Login failed for user afarrugia".

I have now solved that, and I hardcoded the SQL server as suggested by Kamil at http://www.mibuso.com/forum/viewtopic.php?t=16063
but I still get:
Configurator Error Querying SQL server

I will keep on trying, and post if there are further changes.

afarr

Following another suggestion of Kamil, in some other post, I have now used the configurator for SQL 2005 (even though the database is on SQL Server 2000), and finally the configurator is running.

Thanks Kamil.

kine

You are welcome! Happy that you solved it.

And the version of Configurator must be selected regarding the target server version, not NAV DB server version. It means, that if you are running NAV on MS SQL 2000 but you want to generate cube on MS SQL 2005, you need to run 2005 version of Configurator.

jabetanc

Hi, everybody.

I have a similar problem, when i am trying to start confiturator from NAVISION , it returned me the follow message
index and length must refer to a location within the string. parameter name length. NAVISION.

Thanks for your help

afarr

I'm afraid I never managed to get Bus. Analytics working properly, and haven't worked on it in over 18 months.
My general impression is that SQL Server Reporting Services is recommended for business intelligence, particularly because it's already part of SQL Server 2005, and because it will be easier to use with NAV 2009.