8 Innovation Workbench

The Innovation Workbench tables follow this convention: RSE prefix is used for core tables, PRO prefix is used for Promotion and Markdown Optimization tables, and PRO_REG prefix is used for Regular Pricing Optimization tables.

The following validation and result tables that are applicable for optimization are exposed in read-only mode. You can rearrange and analyze the results table for reporting purposes and examine the validation table to determine why a particular run has ended in Failed status. The tables are:

  • PRO_RUN_SANITY_CHECK_RES_VW contains information on the errors/alerts/warnings generated.

  • PRO_RUN_RECOM_OPT_RESULT contains all the results associated with lifecycle pricing: promotions, markdowns, and targeted pricing recommendations.

  • PRO_REG_RUN_RECOM_OPT_RESULT contains all the results associated regular pricing recommendations.

  • PRO_REG_RUN_SANITY_CHECK_RES_VW contains all the errors/alerts/warnings that were generated for the run.