Skip to main content

High-Level Summary of Options

High-Level Summary of Options

For reference, the following table summaries the possible contents of an InterSystems IRIS Business Intelligence model, including information on which tool you use to create each element:

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
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
quality measure Define measure via MDX outside of a cube quality measure class Quality Measure Manager Defining Quality Measures
related cubes Use levels of a different cube cube class Architect Defining Cube-Cube Relationships
compound cube Combine measures from different cubes or see these measures side by side subject area class Architect Defining Shared Dimensions and Compound Cubes
KPI Query the data in a more flexible way, for use as an alternative data source KPI class Studio Defining Basic KPIs
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
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
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
FeedbackOpens in a new tab