Defining Models for InterSystems IRIS Business Intelligence
Summary of Model Options
|
|
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 |
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** |
Item | Use in Rows and Columns options | Use in Measures option | Use in Filters option |
---|---|---|---|
property | Yes | No | No |
property in another cube (related or compound) | Yes | No | No |
Item | To Access This Item from a Calculated Member or Measure |
---|---|
MDX standard cube items (dimension, hierarchy, level, measure, property, calculated member, named set) | Many options; see Using InterSystems MDX. |
computed dimension* | Use the dimension and member name to create a member expression that refers to the desired member, in the same way that you do for any standard member. |
quality measure* | Use the %QualityMeasure dimension to create a quality measure expression that refers to the measure. |
KPI or plug-in* | Use the %KPI function to refer to the value of a property in the KPI or plug-in. |
term list* |
Feature | Pivot Tables | KPIs | Plugins | Production Business Metrics |
---|---|---|---|---|
How definition is stored | Folder item | Class definition | Class definition | Class definition |
Where defined | Analyzer | Studio | Studio | Studio |
Data source options | MDX query |
|
MDX query | Values returned by custom code |
Supports custom computation using lowest-level records? | No | No | Yes | No |
Supports filtering? | Yes | Yes, depending on your implementation | Yes, depending on your implementation | No |
Supports custom filtering (for example, provide user with only a subset of the members of a level)? | No | Yes, depending on your implementation | Yes, depending on your implementation | No |
Supports listings? | Yes | Yes, depending on your implementation | Yes | No |
Supports the Mini Analyzer? | Yes | No | No | No |
Item | Purpose | Location of definition | Primary tool to create | Where described |
---|---|---|---|---|
dimension, hierarchy, and level | Define groups of records | cube class | Architect | “Defining Dimensions, Hierarchies, and Levels” |
measure (numeric, integer, date, age, or boolean) | Aggregate values across multiple records | cube class | Architect | “Defining Measures” |
measure (text or string) | Store string data in the fact table. These measures are usually also searchable. | |||
searchable measure | Aggregate values across multiple records; also support filtering of lowest-level records | |||
NLP measure | Used by NLP dimensions; not visible in the Analyzer | cube class | Architect | “Using Text Analytics in Cubes” in Advanced Modeling for InterSystems Business Intelligence |
property | Contain data specific to a level | cube class | Architect | “Defining Properties” |
listing | Provide access to lowest-level details | cube class | Architect | “Defining Listings,” “Defining List Fields”, and “Defining Listing Groups” |
calculated measure | Define a measure based on other model elements | cube class or pivot table | Architect or Analyzer | “Defining Calculated Members” |
calculated member (non-measure) | Define a member based on other model elements | |||
named set | Define a reusable set of members | cube class | Architect | “Defining Named Sets” |
subject area | Filter a cube or otherwise refine its definition | subject area class | Architect | “Defining Subject Areas” |
computed dimension | Define groups of records to retrieve at runtime (usually via SQL or MDX) | cube class | Architect | “Defining Computed Dimensions” in Advanced Modeling for InterSystems Business Intelligence |
quality measure | Define measure via MDX outside of a cube | quality measure class | Quality Measure Manager | “Defining Quality Measures” in Advanced Modeling for InterSystems Business Intelligence |
related cubes | Use levels of a different cube | cube class | Architect | “Defining Cube-Cube Relationships” in Advanced Modeling for InterSystems Business Intelligence |
compound cube | Combine measures from different cubes or see these measures side by side | subject area class | Architect | “Defining Shared Dimensions and Compound Cubes” in Advanced Modeling for InterSystems Business Intelligence |
KPI | Query the data in a more flexible way, for use as an alternative data source | KPI class | Studio | “Defining Basic KPIs” in Advanced Modeling for InterSystems Business Intelligence |
pivot-type plug-in | Calculate a value based on the lowest-level data; use via drag and drop | plug-in class | Studio | “Defining Plug-ins” in Advanced Modeling for InterSystems Business Intelligence |
aggregate-type plug-in | Calculate a value based on the lowest-level data; use in calculated members | |||
term list | Define values outside of a cube, for various purposes | Business Intelligence folder item | Term List manager | Defining Term Lists in Advanced Modeling for InterSystems Business Intelligence |
business metric | Compute data specific to a production | business metric class | Studio | Developing Productions |
named filter | Define a filter for use with a specific cube | global | Analyzer | Using the Analyzer |