Business Analytics - problem with native DB

Doomhammer
Doomhammer Member Posts: 211
edited 2008-07-09 in NAV/Navision Classic Client
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.
Martin Bokůvka, AxiomProvis

Comments

  • Doomhammer
    Doomhammer Member Posts: 211
    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?
    Martin Bokůvka, AxiomProvis
  • vyanku
    vyanku Member Posts: 791
    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
    Doomhammer Member Posts: 211
    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
    Martin Bokůvka, AxiomProvis
  • vyanku
    vyanku Member Posts: 791
    have you tried on SQL 2000 SP3 with older version of BA?
  • Doomhammer
    Doomhammer Member Posts: 211
    no, I did not... only SQL2005.
    But in whitepaper supplied with BA installation, there is screenshot of configurator with SQL2005 services
    Martin Bokůvka, AxiomProvis
  • vyanku
    vyanku Member Posts: 791
    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
    Doomhammer Member Posts: 211
    Thanks. I tried NAV 4.0 SP3 and it worked. I tried it with Cronus. Hope now I'll get on next step
    Martin Bokůvka, AxiomProvis
  • vyanku
    vyanku Member Posts: 791
    Gr8 \:D/
  • Doomhammer
    Doomhammer Member Posts: 211
    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
    Martin Bokůvka, AxiomProvis
  • vyanku
    vyanku Member Posts: 791
    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
    Doomhammer Member Posts: 211
    hey, man, I owe you some beers I think. once again, you helped me. thanks a lot \:D/
    Martin Bokůvka, AxiomProvis

Categories