Price Guidance Analytic

Overview

The Price Guidance analytic that provides the ability to evaluate historical or optimization-based values to guide users on the appropriate and permitted discounts or prices for Commerce Transactions and Transaction Line documents. The Price Guidance analytic populates Commerce attributes with pricing guidance values for discount percentages or net prices. For example, a Starting, Target, and Maximum Discount can be defined for a type of quote or product to guide sales users on discounts that should be offered to the customer. After set up is complete, the guidance values can be displayed to sales users on the Transaction UI using attribute values or the Price Guidance Gauge.

Beginning in Oracle CPQ 20B, the "Last Price Paid" functionality is implemented using the Price Guidance feature.

To implement Last Price Paid functionality, refer to Setup Last Price Paid Using Price Guidance Analytic

Administration

ClosedCreate a Price Guidance Analytic From Historic Data

  1. Navigate to the Process Administration page.

    Admin > Commerce and Documents > Process Definition

  2. Select Analytics from the Navigation drop-down menu, then click List.

  3. Scroll through the filmstrip to the Price Guidance option, then click Create.

    Analytic wizard - Price Guidance

    The Price Guidance wizard opens and guides administrators through the analytic creation process.

  4. Define the following parameters:

    • Name - The name for the analytic.
    • Variable Name - The variable name for the analytic.
    • Description (optional) - The description for the analytic.

    Click Data icon

  5. Click on the Data icon to proceed to the next page.

    Data page

  6. Select the Commerce Document from the drop-down menu. (e.g. Transaction or Transaction Line)

  7. Select Learn from Historic Pricing Data from the Data Source drop-down menu.

    Refer to Create a Price Guidance Analytic Using Trained Price Optimization to create an analytic from a trained price optimization.

  8. Define time range filters (optional).

    Define time range filters

    • Set Filter data by time range to Yes.
    • Select the Date Attribute from the drop-down menu.
    • Select the date Range from the drop-down menu.

  9. Define additional data filters (optional).

    Define additional data filters

    • Set Additional Data Filters to Yes.
    • Click the "+" icon to add a filter.
    • Specify the following criteria: Query Attribute, Operator, Transaction Attribute, and Specified Value.

  10. Click on the Output icon to proceed to the next page.

    Click on the Output icon

  11. Select one or more modify actions as Trigger Actions.
    When a sales user invokes a trigger action on the Commerce UI, the price guidance calculation is executed and the calculation result is stored in the Output Attributes, which are also defined on this page.

    Select Trigger actions

    Notes:

    • The price guidance calculation is executed after "Formula", but before "Advanced Modify - After Formula" BML.

    • When a Transaction action is selected for a Transaction Line price guidance Trigger Action, the trigger action will invoke the Transaction Line price guidance against all line items of the current quote. If a quote contains a large number of line items, performance must be validated before deploying to sales users.

  12. Define the Output Attributes and aggregate functions that are used to calculate a price guidance.

    1. Click the "+" icon to add an output attribute.
    2. Select the Output Attribute.

    3. Select the Aggregate Type.

      • Percentile - the output result is generated based on the cumulative percentile value, for more information see Percentile Aggregate Type.
      • Min - the lowest historical value within the filtered data set.
      • Max - the highest historical value within the filtered data set.
      • Average - the average historical value within the filtered data set.
      • Standard Deviation - the measure of dispersion within the filtered data set from its mean.
      • Latest - the latest historical value, for more information see Last Price Paid.
    4. For percentile aggregate types, specify the Percentile Value.
    5. Select the Source Column.

    Output attributes

    The Output Attribute and the Source Column must be of matching data type (i.e. integer, float, currency, etc.).

    ClosedPercentile Aggregate Type

  13. Click Save.

ClosedCreate a Price Guidance Analytic Using Trained Price Optimization

  1. Navigate to the Process Administration page.

    Admin > Commerce and Documents > Process Definition

  2. Select Analytics from the Navigation drop-down menu, then click List.

  3. Click Create Analytic.

    The Analytic wizard opens.

  4. Scroll through the filmstrip to the Price Guidance option, then click Create.

    Analytic wizard - Price Guidance

    The Price Guidance wizard opens and guides administrators through the analytic creation process.

  5. Define the following parameters:

    • Name - The name for the analytic.
    • Variable Name - The variable name for the analytic.
    • Description (optional) - The description for the analytic.

    Select Data icon

  6. Click on the Data icon to proceed to the next page.

    Data page

  7. Select the Commerce Document from the drop-down menu. (e.g. Transaction or Transaction Line)

  8. Select Use Trained Price Optimization from the Data Source drop-down menu.

    Refer to Create a Price Guidance Analytic from Historic Data to create an analytic a based on historic pricing data.

  9. Select the target Price Optimization Analytic from the automatically populated list.

  10. Click on the Output icon to proceed to the next page.

    Click Output icon

  11. Select one or more modify actions as Trigger Actions.
    When a sales user invokes a trigger action on the Commerce UI, the price guidance calculation is executed and the calculation result is stored in the Output Attributes, which are also defined on this page.

    Trigger actions

    Notes:

    • The price guidance calculation is executed after "Formula", but before "Advanced Modify - After Formula" BML.

    • When a Transaction action is selected for a Transaction Line price guidance Trigger Action, the trigger action will invoke the Transaction Line price guidance against all line items of the current quote. If a quote contains a large number of line items, performance must be validated before deploying to sales users.

  12. Define the Output Attributes and Delta Percentages for the analytic.

    1. Click the "+" icon to add an output attribute.
    2. Select the Output Attribute
    3. Specify the Delta Percentage.
    4. Specify the Direction (Lower Bound or Higher Bound).

    Output attributes

    ClosedDelta Percentage

    Output Attribute

    		 Delta Percentage

    Direction

    Floor Discount %

    		 25

    Lower Bound

    Target Discount %

    		 0

     

    Max Discount %

    		 25

    Higher Bound
    • The Floor Discount % is 25% less that the target.
    • The Target Discount % adjusts the target price to optimum price.
    • The Max Discount % is 25% more than the target.

    Delta Percentage chart

  13. Click Save.

ClosedCopy Analytics

Administrators can copy Scatter Plot, Win Probability, Price Optimization, or Price Guidance analytics. This functionality allows administrators to quickly define and preview alternative analytics to evaluate the results with differing inputs.

Complete the following steps to copy an analytic:

  1. Navigate to the Admin Home page.

  2. Under Commerce and Documents, click Process.

    The Processes page opens.

  3. Select Analytics from the Navigation menu, next to the applicable process.

  4. Click List.

    The Analytics List page opens.

  5. Select the checkbox next to the applicable analytic.

    Analytics List page

  6. Click Copy.

    The Analytics Definition Editor page opens.

  7. Update the analytic properties as desired.
  8. Initiate machine learning to train the new analytic.
  9. Preview the new analytic to analyze the results.

Note: Training sessions and results, and analytic output actions and attributes are not copied as part of the cloning process.

ClosedMigrate Deal Management Analytics

The Migration Center is the user interface where all migration takes place within Oracle CPQ. Deal Management Analytics are displayed in the Analytics folder under the applicable Commerce process. Deal Management Analytics are migrated when the parent Commerce process is migrated.

Migrate analytics

Custom Variable Name Conventions

In Oracle CPQ 23D, CPQ adopted Oracle CX Sales variable naming conventions for custom items. When an administrator creates a new custom Commerce item, the "_c" suffix is appended to the variable name. The new naming convention for custom variable names provides more consistency for integrations with Oracle Sales.

Beginning in Oracle CPQ 24C, customers can submit a service request to disable the "_c" suffix on variable names for custom Commerce entities (Actions, Analytics, Attributes, Data Columns, Integrations, Library Functions, Rules, Steps, etc.). The "_c" suffix is enabled by default for standard and legacy Commerce processes.

  • Customers can submit a Service Request (SR) on My Oracle Support to disable the "_c" suffix on variable names for custom Commerce entities
  • When the "_c" is disabled, the "_c" variable name suffix will not be required for newly created custom Commerce entities.
  • Disabling the "_c" variable name suffix for custom Commerce entities will not change existing variable names.
  • The "_c" suffix setting will not impact existing variable names when cloning a Commerce process or migrating Commerce items. Target variable names will be the same as the variable names from the source Commerce process.
Data columns are required for Price Guidance Analytic.

Related Topics

Related Topics Link IconSee Also