Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Use DimCaseProduct to compare support demand by the product associated with each case.
Business value
Use the Product filter on the Summary page, the product volume chart, and the top product/type card to analyze cases by product. Product reporting requires available product information and cases linked to those products.
Grain and source tables
The optional product source supplies one row per ProductId. Rows with null source IDs are excluded. For multiple versions, the latest modifiedon is retained when available.
Product analysis can be empty when product data or the case product mapping is unavailable. An empty product view doesn't mean that no cases exist.
Columns
| Column | Type | Source field | Description |
|---|---|---|---|
ProductId |
STRING | product.productid |
Product identifier and primary key. |
ProductName |
STRING | product.name |
Product display name. |
ProductNumber |
STRING | product.productnumber |
Business product number. |
_LastRefreshedDateTimeUtc |
TIMESTAMP | System | Date and time of the pipeline refresh. |
Optional attributes remain null when unavailable.
Dashboard relationships
Create single-direction, one-to-many relationships from ProductId to the matching column on AggCaseAnalytics, AggCaseSLA, and AggCaseSnapshot. The case key comes from incident.productid.
Use products to group and compare cases, not as values to add together. The top product/type card shows which combination of product and case type has the most cases.