Create WithoutHistory Table Views

About this task

WithoutHistory views are views that do not include data from History tables.

To create WithoutHistory Views:

Procedure

  1. Edit the yna_master_db_script.xml file located in the <YNW_ANALYTICS_HOME>/bin directory as follows:
    1. Set the appropriate path for the DB driver directory in the dir attribute of the fileset element, for example, <fileset dir="/db/lib">.
    2. Set the value of the type property to withoutHistory as mentioned below:
      <property name="type" value="WithoutHistory"/>
    3. If the IBM® Sterling Selling and Fulfillment Foundation and IBM Sterling Warehouse Management System Business Intelligence are installed on the same server, set the file attribute in the property element to point to the jdbc.properties file, sandbox.cfg file, and noapp.properties file, for example, <property file="<INSTALL_DIR>/properties/jdbc.properties"/>, <property file="<INSTALL_DIR>/properties/sandbox.cfg"/>, and <property file="<INSTALL_DIR>/properties/noapp.properties"/>

      If the IBM Sterling Selling and Fulfillment Foundation and IBM Sterling Warehouse Management System Business Intelligence are installed on different servers, copy the jdbc.properties file and the sandbox.cfg file from the IBM Sterling Selling and Fulfillment Foundation server to the IBM Sterling Warehouse Management System Business Intelligence server, and set the file attribute in the property element to point to the copied jdbc.properties file, sandbox.cfg file, and noapp.properties file, for example, <property file="<INSTALL_DIR>/properties/jdbc.properties"/>, <property file="<INSTALL_DIR>/properties/sandbox.cfg"/>, and <property file="<INSTALL_DIR>/properties/noapp.properties"/>.

  2. Execute the following script in the <YNW_ANALYTICS_HOME>/bin directory:
    ant -f yna_master_db_script.xml

    The system prompts to enter the IBM Sterling Selling and Fulfillment Foundation version number. Based on the version number, the IBM Sterling Warehouse Management System: Business Intelligence views will be created in the IBM Sterling Selling and Fulfillment Foundation database.

    If you have a multischema enviroment in the IBM Sterling Warehouse Management System: Business Intelligence, views will be created for all the colonies of the IBM Sterling Selling and Fulfillment Foundation version number.