Data returned in BIOVue is not up to date in Microsoft Dynamics SL


Symptoms


Consider the following scenario in Microsoft BIO Vue and Microsoft Dynamics SL:
  • You log on to BIO Vue, and you select a view.
  • You review the data that is returned in the view.
When you do this, you notice that the data that is returned in the view is not current. You expect the data to match the data in Microsoft Dynamics SL.

Resolution


To resolve this problem, re-create and rerun the Microsoft BIO DTS package. To do this, follow these steps.

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
  1. Truncate the BIOFact, BIOStepLog, and BIOLog tables in the Microsoft BIO database in Microsoft SQL Server Management Studio. To do this, open a new query window, and then run the following SQL statements against the Microsoft BIO database:
    Truncate table biofact
    Truncate table biosteplog
    Truncate table biolog
  2. Re-create the DTS package in the Microsoft BIO application. To do this, follow these steps:
    1. On the View menu in Microsoft BIO, click Administration, and then select Data Extract.
    2. Click the Recreate button.
  3. Run the DTS package from the Microsoft BIO application on the Data Extract tab.
  4. To manually process the Cubes, follow these steps:
    1. Click Builder on the Microsoft BIO menu.
    2. Select Cube Catalog.
    3. Select the first cube on the list.
    4. In the Cube Catalog window, click Next on the Cube Wizard tab until you are prompted to process the cube. Make sure that the following check boxes are selected before you continue:
      • Fully Process Cubes
      • Update Shared Dimensions
      • Process Related Cubes
    5. Click Process.
    6. Repeat steps A through E for each cube.