Business Analytics for navision 4.0

Neha_Marwaha

I have configured Business analytics for navision 4.0 successfully, but when a new entry is generated in navision it will not be updated in business analytics.

for example:when a new customer is created in Navision 4.0,it should also be visible in the reports of business analytics,but it will not get updated.

Please help me to know:
How the data of navision get updated in business analytics.

Neha Marwaha

jlandeen

There should be some DTS packages in SQL that execute to update the analsysis servcies cubes (SQL 2000). In SQL 2005 this is all managed through Integration Services.

Have you run (or scheduled) any thing to run and update the cubes with Data from Navision?

Neha_Marwaha

Thanx for your reply.

I configured Business Analytics successfully,but now when I created new cube and run the configurator,it display an error:
"Configurator.exe has encountered a problem and need to be closed".
I am not able to resolve it.

Log:
********************** Started: Wednesday, January 28, 2009 4:58:34 PM **********************
Language: w1
Database: new-database
4:58:34 PM: Initialize
Read XML
4:58:34 PM: Check for SQL Server 2005
4:58:35 PM: Check for Analysis Services 2005
4:58:36 PM: Installation started
4:58:36 PM: Build Internal Representation
Companies
Enumerations
Shared Dimensions
Cubes
Reference Dimensions
Virtual Cubes
Transfer
Period Table Tasks
4:58:43 PM: Install Custom SSIS Tasks
Uninstalling
Installing
4:58:47 PM: Create SQL Server Database
Drop database "BA for MBS Navision"
Create database "BA for MBS Navision"
Create table "eIncome_Balance"
Create table "eEntryType"
Create table "eItemLedgerEntryType"
Create table "eValueEntryEntryType"
Create table "eOpportunityEntryActive"
Create table "nGen_BusinessPostingGroup"
Create table "nGen_ProductPostingGroup"
Create table "nSourceCode"
Create table "nJob"
Create table "nPhase"
Create table "nStep"
Create table "nTask"
Create table "nResource"
Create table "nG_LAccount"
Create table "nItem"
Create table "nLocation"
Create table "nG_LBudgetName"
Create table "nCustomer"
Create table "nCountry"
Create table "nTerritory"
Create table "nVendor"
Create table "nSalesperson_Purchaser"
Create table "nCampaign"
Create table "nCampaignStatus"
Create table "nOpportunity"
Create table "nSalesCycle"
Create table "nSalesCycleStage"
Create table "nContact"
Create table "nInventoryPostingGroup"
Create table "wADDepartment"
Create table "wADProject"
Create table "wADCustomerGroup"
Create table "wADArea"
Create table "wADBusinessGroup"
Create table "wADSalescampaign"
Create table "wIsClosingDate"
Create table "nOpportunityEntry"
Create table "nDimensionValue"
Create table "nLedgerEntryDimension"
Create table "nG_LBudgetDimension"
Create table "nG_LEntry"
Create table "wLedgerEntryDimensionG_LEntry"
Create table "nG_LBudgetEntry"
Create table "wG_LBudgetDimensionG_LBudgetEntry"
Create table "nDetailedCust_Ledg_Entry"
Create table "wLedgerEntryDimensionDetailedCust_Ledg_Entry"
Create table "nDetailedVendorLedg_Entry"
Create table "wLedgerEntryDimensionDetailedVendorLedg_Entry"
Create table "nItemLedgerEntry"
Create table "wLedgerEntryDimensionItemLedgerEntry"
Create table "nValueEntry"
Create table "wLedgerEntryDimensionValueEntry"
Create table "nJobLedgerEntry"
Create table "wLedgerEntryDimensionJobLedgerEntry"
Create table "nRes_LedgerEntry"
Create table "wLedgerEntryDimensionRes_LedgerEntry"
Create table "wLedgerEntryDimensionOpportunityEntry"
4:59:18 PM: Create SSIS Package (Part 1)
Create sequence "Initialize"
Create Data Flow "Transfer" (CRONUS India Ltd.)
Create pump Gen_ Business Posting Group
Create pump Gen_ Product Posting Group
Create pump Source Code
Create pump Job
Create pump Phase
Create pump Step
Create pump Task
Create pump Resource
Create pump G_L Account
Create pump Item
Create pump Location
Create pump G_L Budget Name
Create pump Customer
Create pump Country
Create pump Territory
Create pump Vendor
Create pump Salesperson_Purchaser
Create pump Campaign
Create pump Campaign Status
Create pump Opportunity
Create pump Sales Cycle
Create pump Sales Cycle Stage
Create pump Contact
Create pump Inventory Posting Group
Create pump Opportunity Entry
Create pump Dimension Value
Create pump Ledger Entry Dimension
Create pump G_L Budget Dimension
Create pump G_L Entry
Create pump G_L Budget Entry
Create pump Detailed Cust_ Ledg_ Entry
Create pump Detailed Vendor Ledg_ Entry
Create pump Item Ledger Entry
Create pump Value Entry
Create pump Job Ledger Entry
Create pump Res_ Ledger Entry
Create sequence "Post Process"
4:59:30 PM: Execute SSIS Package
Execute package "BA for MBS Navision"
5:10:00 PM: Create SSIS Package (Part 2)
Create sequence "Process Cubes"

I tried several time to run configurator,but it always display the above error when it successfully completed the installation of "Create SSIS package(Part 2)".

Please help me

Neha Marwaha

jlandeen

I haven't experienced this error before, but I've done more work with the older DTS based version of business analytics then the SQL 2005 version.

However it does look like you're not the first person to experience something like this. Check out the support article on Partnersource: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYXUPYZQPOUXNXSPSYOMPRYORVUYTULPMRPKZYYSYSPXLSLZKM

jlandeen

Actually it looks like there have been quite a few issues logged in Partnersource with Business Analytics, and I think quite a few of them are to deal with the SSIS portions of the solution.

In general I find that Business Analytics is a great idea but it's implementation can be difficult. This is because in general I find that customers have very different customizations to their base Navision modules and it's that customized data that really needs to be extracted, transformed and massaged into cubes for analysis. Those tasks and processes aren't as easily to generalize and thus it can be more cost effective to build your own processes to move data from the trasaction system (i.e. Navision) to the Datawarehous (i.e. SQL Analysis Services) and then just use the Business Analytics front end to analyze the cubes in the datawarehouse (and there are some powerful views and tools in that front end).

Neha_Marwaha

Thanx for your reply.

Business Analytics is configured again ..and data also get updated,but I have one issue in it.
Whenever I generate a new customer or any other entry in navision it will not automatically get updated in BA.
I always have to run Configurator and then Configurator.exe to give the license program folder path and database.

Its a manual task.

Is there is any way to update data automatically in BA?

Neha Marwaha