Items That Group or Filter Records
The following items can be used to group or filter records. Except for some searchable measures, none of these items can be used as measures.
Item |
Use in Rows and Columns options |
Use in Filters option |
dimension or level |
Yes |
Yes |
dimension or level of a related cube |
Yes |
Yes |
shared dimension or level in the same compound cube |
Yes |
Yes |
calculated member (non-measure) |
Yes |
Yes |
calculated member (non-measure) in a related cube |
Yes |
Yes |
calculated member (non-measure) in another cube in the same compound cube |
No |
No |
computed dimension |
Yes |
Yes |
computed dimension in a related cube |
Yes |
Yes |
computed dimension in another cube in the same compound cube |
No |
No |
named set |
Yes |
Yes |
named set in another cube |
No |
No |
named filter |
No |
Yes |
named filter in another cube |
No |
No |
searchable measures |
Yes, except for text, string, and NLP measures |
Yes |
Related cubes, compound cubes, computed dimensions, and NLP measures are discussed in Advanced Modeling for InterSystems Business Intelligence.
Named filters are discussed in Using the Analyzer.
Note that calculated members that are part of existing cube dimensions do not appear in filters unless the Show Calculated Members in Filters option is selected.