Running Sample Content Packs

Before you customize reports, it is suggested you run the following content pack examples in your test environment.

  1. Run the following command on Linux to ensure that $VDW_HOME is configured correctly:

    Echo $VDW_HOME

    If $VDW_HOME is correctly configured, the directory that you have Vertica for PPM content pack installed returns. For example,

    /VDW_HOME

    Otherwise, add $VDW_HOME as a system environment variable and point it to the Vertica for PPM content pack directory.

  2. Unpack the Vertica_Reporting_Customization_Samples.zip file.

    Two content pack folders are included: CUSTOMIZATION_PPM.cp and CUSTOMIZATION_TARGET.cp.

    For instructions on obtaining the sample content packs, see Obtaining Sample Content Packs for Customization.

  3. Place the CUSTOMIZATION_PPM.cp and CUSTOMIZATION_TARGET.cp files in the <VDW_HOME>/Content directory.

  4. Run the ContentManager.sh script under the <VDW_HOME>/bin directory to deploy the CUSTOMIZATION_TARGET.cp:

    sh ContentManager.sh --instruction install --cpname CUSTOMIZATION_TARGET;

    You can find the following message from ContentManager.log under <VDW_HOME>/logs if the content pack is deployed successfully:

    The content of package CUSTOMIZATION_TARGET was successfully installed

    After you run the command, the following tables are generated:

    • The DIM_ CUSTOMIZATION_CONTACTS table is generated for extending dimension entities.
    • The FACT_CUSTOMIZATION_RESOURCE_DEMAND table is generated for extending fact entities.
    • The DIM_CUSTOMIZATION_TIME_SHEETS table is generated for creating new dimension entities.
    • The FACT_ CUSTOMIZATION_TIME_ACTUALS table is generated for creating new fact entities.

  5. Run the ContentManager.sh script under the <VDW_HOME>/bin directory to deploy CUSTOMIZATION_PPM.cp:

    sh ContentManager.sh --instruction install --cpname CUSTOMIZATION_PPM;

    You can find the following message from ContentManager.log under <VDW_HOME>/logs if the content pack is deployed successfully:

    The content of package CUSTOMIZATION_PPM was successfully installed
  6. Run the ExtractorEngine.sh script under the <VDW_HOME>/bin directory to extract data from the PPM database to flat files:

    sh ExtractorEngine.sh --streamname <Stream_Name> --instancename <PPM_Instance_Name>

    You can find the following message from ExtractorEngine.log under <VDW_HOME>/logs if the content pack is deployed successfully:

    Extractor was successfully executed. The BATCH ID is: <Batch_ID>.

    You also need to make sure that no warning messages are displayed in the command line interface.

    • Replace <Stream_Name> with the following depending on the sample content packs you use:

      • CUSTOMIZATION_CONTACTS_STREAM for extended dimension entities
      • CUSTOMIZATION_RESOURCE_DEMAND_STREAM for extended fact entities
      • CUSTOMIZATION_TIME_SHEETS_STREAM for new dimension entities

      • CUSTOMIZATION_TIME_ACTUALS_STREAM for new fact entities
    • <PPM_Instance_Name> is the PPM instance name you specified when installing the Vertica for PPM content pack.
  7. Run the FlowEngine.sh script under the <VDW_HOME>/bin directory to process ETL:

    sh FlowEngine.sh --batch <Batch_ID> --streamname <Stream_Name> --instancename <PPM_Instance_Name>

    You can find the following message from FlowEngine.log under <VDW_HOME>/logs if the content pack is deployed successfully:

    ETL process was executed successfully

    • <Batch_ID> used in this command is the batch ID that was generated in Step 6.
    • Replace <Stream_Name> with the following depending on the sample content packs you use:

      • CUSTOMIZATION_CONTACTS_STREAM for extending dimension entities
      • CUSTOMIZATION_RESOURCE_DEMAND_STREAM for extending fact entities
      • CUSTOMIZATION_TIME_SHEETS_STREAM for new dimension entities
      • CUSTOMIZATION_TIME_ACTUALS_STREAM for new fact entities

  8. Connect to the Vertica database and check whether the data has been loaded successfully:

    select * from <Target_Schema>.<Table_Name>
    • <Target_Schema> is the name for the schema that contains target data and tables for reporting.
    • Replace <Table_Name> with the following for different sample content packs:

      • DIM_ CUSTOMIZATION_CONTACTS for extended dimension entities
      • FACT_CUSTOMIZATION_RESOURCE_DEMAND for extended fact entities
      • DIM_CUSTOMIZATION_TIME_SHEETS for new dimension entities
      • FACT_CUSTOMIZATION_TIME_ACTUALS for new fact entities

For more information about these scripts, refer to "Administration Tasks" of the Vertica for PPM Administrator Guide for Content Pack 1.0.