Create WithHistory Table Views

About this task

WithHistory views are views that include data from History tables.

To create WithHistory 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 withHistory as mentioned below:
      <property name="type" value="WithHistory"/>
    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"/> and <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 IBM Sterling Selling and Fulfillment Foundation to IBM Sterling Warehouse Management System Business Intelligence, 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.