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. |
cube class |
Architect |
Defining Measures |
searchable measure |
Aggregate values across multiple records; also support filtering of lowest-level records |
cube class |
Architect |
Defining Measures |
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 |