Items That Behave Like Measures
The following items behave like measures and are shown in the body of a pivot table. With one exception (noted), these items cannot be used for filtering.
| Item |
Use in Rows and Columns options |
Use in Measures option |
Use in Filters option |
| measure |
Yes, except for text, string, and NLP measures |
Yes, except for text, string, and NLP measures |
Yes, if searchable |
| measure of a related cube |
No* |
No* |
No |
| measure of another cube in the same compound cube |
Yes |
Yes |
No |
| calculated measure |
Yes |
Yes |
No |
| calculated measure from another cube |
No |
No** |
No |
| quality measure |
Yes |
Yes |
No |
| quality measure from another cube |
Not applicable** |
Not applicable** |
Not applicable** |
| property of pivot-type plug-in |
Yes |
Yes |
No |
| pivot-type plug-in from another cube |
Not applicable** |
Not applicable** |
Not applicable** |
Related cubes, compound cubes, NLP measures, quality measures, and plug-ins are discussed in Advanced Modeling for InterSystems Business Intelligence.
* These measures would not be aggregated correctly if used this way.
** Quality measures and plug-ins are designed to be directly associated with any cubes where they are to be used.
