Pricing Administration Guide > Matrix-Based Pricing Factors >

Improving Performance of Matrix Pricing


Because pricing matrices often have many rows of data, it is important to set up the business components for matrix pricing in the most efficient way.

The underlying table containing the pricing matrix data should contain integration ids that are indexed. If you need to export this pricing matrix information between systems, you must use ids that can be used by all of these systems; these common ids need to be indexed.

To improve performance, you can create two business components for this table, one used for administration and one used in run time. The Admin bus comp would contain the links, joins, pick lists and associated views, applets, pick applets, and pick maps that the administrator uses to create the pricing matrix data. The Run time bus comp, would not contain any of the links, joins, or pick lists that the administrator uses. The Run time bus comp would contain only the columns needed to execute the matrix look up, such as product integration id and account type.


 Pricing Administration Guide 
 Published: 18 April 2003