Business Analytics Help?

McWolf

I want to install Business Analytics for Navision 4.0. I have a Demo Script from Partnersource Site, but could you tell me, there is any other places, where can I find any information, manuals or help about Business Analytics. Yes, I know I can buy manual from Microsoft, but I don't want spend money, because I don't have enough .

vivektaurian

Hi,

For installing Business Analytics you should have the Analysis Services of SQL with service pack 3 or more.

You Follow the following guide lines to install the BA.

1.Create the cubes in Navision.If you dont want to create then for demo purpose you can import the fob file from BA_Fob folder from CD the table no 700.

2.Start the BA CD or setup,select the server install the basic version of it.

3.Open the BA overview in Navision look up the database (which will be default is you imported fob) selct the active and in the path to configure give the path BA Configurator.exe where u installed the BA.

4.Now Function--->update xml
Again Function---> start Configurator,after starting this it will ask for password which is ur SQL password.it will start configurator and take some time (You Will be lucky if u dont get any error if u get then do let me know).

5.After this instal the advance version of this from the server option only.It will install the client.

6.Now start configure BA Advance it will ask for the license give the path where ur license is there.or give the path to the client folder where the Navision is installed.

After successful completion of this you can use BA.If there is some error you face then you can post here..

So All the best

Do let me know wether u r successful or not.

McWolf

Thx, everything's great. I have installed MS SQL 2000, MS SQL 2000 Analysis Services, Service Packs for both, MS SQL 2000 Option for Navision and Navision Client. I had some problems importing Cronus database to MS SQL Server, but I've done it. I've created a cube, run configurator and BA. When I've tested BA, my notebook crashed :-(. And I must wait until it'll be repaired.

ycobos

Hello
I have seen you are an expert about Navision with SQL Server database. I'm working now with that option, and I want to export a created cube to XML and then import it to another database. I have been trying it and I execute againg the configurator, but any change appear. I don´t know how I can solve it. Please help me!
Thank you very much.
Yolanda Cobos.

vyanku

Thats great McWolf =D> .Did u got any errors in running configurator.?
How could u importing Cronus database to MS SQL Server? :-k :-k
Please tell me.

ycobos

No, no, I haven´t got any errors but either data nor objects appear. So that functionality dow not work, I think so.

vyanku wrote:

Thats great McWolf =D> .Did u got any errors in running configurator.?
How could u importing Cronus database to MS SQL Server? :-k :-k
Please tell me.

vyanku

In Business Analytics Enterprise maneger .
Can u ceate new database?
When i want to do it that option is desible?
I think it is problem of BA License.

ycobos

No, I can't. I don't agree with you about the problem of BA license, because I have the developer license and it's the biggest one. But what I'm sure is that i don't know waht the problem is, but sure not the license. If you get something, tell me please.

vyanku wrote:

In Business Analytics Enterprise maneger .
Can u ceate new database?
When i want to do it that option is desible?
I think it is problem of BA License.

vyanku

I think U have Developer License of Navision.D u have BA developer License?
I am talking about BA License.
Is the option of create new Database in Enterprise maneger is Enable for U?

ycobos

oooohhhh, that´s true. I have developer license fo Navision, but in BA Enterprise Manager I can't nos create a new database, so, which license do I need to perform that? Do you know???

vyanku wrote:

I think U have Developer License of Navision.D u have BA developer License?
I am talking about BA License.
Is the option of create new Database in Enterprise maneger is Enable for U?

vyanku

Standard NFR license includes granules for BA. Users needs BA Basic granule for using the Navision part (creating cube) and BA Advanced to be able to use ANTServer (BA Server and client).

ycobos

And do you know which are the numbers of that granules?? I think the basic one is 7020 and the advanced is 7021. Is that rigth???

vyanku wrote:

Standard NFR license includes granules for BA. Users needs BA Basic granule for using the Navision part (creating cube) and BA Advanced to be able to use ANTServer (BA Server and client).

vyanku

sorry I dont know exact granuals It required .U may be correct.

kine

Yes, 7020 and 7021 are the correct granules.

M-a-r-t-y

ycobos wrote:

Hello
I have seen you are an expert about Navision with SQL Server database. I'm working now with that option, and I want to export a created cube to XML and then import it to another database. I have been trying it and I execute againg the configurator, but any change appear. I don´t know how I can solve it. Please help me!
Thank you very much.
Yolanda Cobos.

Did you manage to export a BA database from NAV and import it to another NAV database? I would like to just backup my BA database created in NAV and to be able to import it back again but the standard XML export/import does not work. It actually does not do anything. Any help would be appreciated.

kine

M-a-r-t-y wrote:

Did you manage to export a BA database from NAV and import it to another NAV database? I would like to just backup my BA database created in NAV and to be able to import it back again but the standard XML export/import does not work. It actually does not do anything. Any help would be appreciated.

Do not mix XML Export/Import with transfering data between NAV tables. It will just transfer the XML with cube description and after importing it into other DB and running configurator, same cube will be created. You cannot run "Update XML" in this case because there is nothing from which can the system update the XML. The whole string is:

NAV Tables -> XML -> Configurator -> Cube

Transfering the XML will do just the rest of the chaing. You need to create Dataport for the BA tables if you want to transfer NAV cube definition.