Dimensional Analytics

Dimensional Analytics involves data analyses based on dimensions and measures of spend data. Dimensional attributes and percentages can also be used as the basis for analysis.

The following table covers examples about Dimensional Analytics.
Table 1. Examples of Dimensional Analytics
Example Description
Example 1 Show all commodities (dimension) whose spend (measure) is greater than (search criteria) $10 million and whose vendor count (dimension instance count) is greater than 100.
Note: Dimcount or Dimension Instance Count is the number of occurrences or instances that exist for the dimension.
Example 2 Show all suppliers whose name contains services and whose spend is greater than $5 million.
Example 3 Show commodities that make up the first 50% of the spend.
Example 4 Within the IT services commodity, show all suppliers whose poor performance spend is greater than 20%.