Business Analytics - problem with native DB

Doomhammer

Hi.
I am trying to set up and run BA. But I am lamer, so I am looking for some documentation, how to set up it. Best will be some which will guide me step by step through entire process.

Please, can anybody tell me, where to find informations?

And other thing - which version of BA will be the best fo NAV 4.0 SP2?

Thanks in advance.

Doomhammer

I'll describe my prob:
I set up virtual machine with WinXP SP3, SQL 2005 developer edition and client for NAV 4.0 SP2 and NODBC, Business Analytics downloaded from partner source and, of course, BA configurator. I am using native DB server, which runs on other machine.
Following whitepapper instructions, I created some OLAP definition, I updated XML and then, I clicked on Run Configurator. Configurator was executed with this results:
http://img91.imageshack.us/img91/754/bacnz9.jpg
Configurator did not find SQL server and analytics services so nothing of processes described in whitepaper (creating OLAP cube and SQL Agent job) are not executed...

Where can be problem?

vyanku

The requirnment for BA on Nav 4.0 sp1 or sp2 is as follows

Microsoft Windows NT 4.0 Service Pack 6a, Microsoft Windows 2000, Microsoft Windows XP, or Microsoft Windows Server 2003
Microsoft SQL Server 2000 Service Pack 3
Microsoft Analysis Services Service Pack 3
Microsoft Business Solutions - Navision 4.0
Native Navision option Microsoft Navision N/ODBC

For NAV 4.0 SP3 microsoft released new BA version.

Doomhammer

I tried older version of BA too. Same problem

SQL 2005 is not supported or what?
Now, I am running latest version of BA downloaded from partner source

vyanku

have you tried on SQL 2000 SP3 with older version of BA?

Doomhammer

no, I did not... only SQL2005.
But in whitepaper supplied with BA installation, there is screenshot of configurator with SQL2005 services

vyanku

But in whitepaper supplied with BA installation, there is screenshot of configurator with SQL2005 services

yes because you are using BA which is for NAV 4.0 SP3.
But you are using NAV 4.0 SP2. Just Try it on SQL 2000 SP3.

Doomhammer

Thanks. I tried NAV 4.0 SP3 and it worked. I tried it with Cronus. Hope now I'll get on next step

vyanku

Gr8 \:D/

Doomhammer

more trouble...
I created some simple OLAP definition in NAV. I tried to execute configurator, but it fails on executing DTS package.
When i tried to run SSIS package from Sql Management studio, I got this error message:
http://img20.imageshack.us/img20/1692/ssiserror1at1.jpg
does anybody know, where can be problem?
thx in advance

vyanku

Have you take posting date in dimensions 2 or more times in different tables?
If u r repeating the same field with same name more than 2 times then it will show error.

Doomhammer

hey, man, I owe you some beers I think. once again, you helped me. thanks a lot \:D/