Composite Query Design Considerations

When you use composite queries as data sources for Pivot Grid models, you encounter these limitations:

  • When you use the Count aggregate in a Pivot Grid model, Composite Query executes a COUNT(FIELDNAME) and PSQuery executes a Count(*). Hence if the data is null for a field, the system displays number 0 (zero) for the composite query based pivot grid model.

  • While using expression as fact it is recommended to define the expression at the composite query level.

  • If the expression involves a Calculated Fact from other fact columns( i.e. where ‘None’ is chosen for the aggregate for the expression field), it is necessary that the expression is defined at the composite query level.