Business Analytics for navision 4.0

Neha_Marwaha
Neha_Marwaha Member Posts: 31
edited 2009-01-30 in NAV/Navision Classic Client
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

Comments

  • jlandeen
    jlandeen Member Posts: 524
    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?
    Jeff Landeen - Sr. Consultant
    Epimatic Corp.
    http://www.epimatic.com
  • Neha_Marwaha
    Neha_Marwaha Member Posts: 31
    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
    jlandeen Member Posts: 524
    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
    Jeff Landeen - Sr. Consultant
    Epimatic Corp.
    http://www.epimatic.com
  • jlandeen
    jlandeen Member Posts: 524
    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).
    Jeff Landeen - Sr. Consultant
    Epimatic Corp.
    http://www.epimatic.com
  • Neha_Marwaha
    Neha_Marwaha Member Posts: 31
    Thanx for your reply.

    Business Analytics is configured again :D ..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

Categories