Advanced Modeling for InterSystems IRIS Business Intelligence Defining Computed Dimensions Defining SQL Computed Dimensions Defining MDX Computed Dimensions Defining Shared Dimensions and Compound Cubes Overview Defining a Formally Shared Dimension Defining an Informally Shared Dimension Defining Compound Cubes Defining Cube-Cube Relationships Overview of Relationships Considerations for Defining Cube Relationships Defining a One-Way Relationship Defining a Two-Way Relationship Building Cubes That Have Relationships Using Model Browser Removing Relationships Using Text Analytics in Cubes Overview of Integration with Text Analytics Setting Up the Aviation Events Demo Defining an NLP measure Loading and Updating Dictionaries Defining an Entity Dimension Defining a Dictionary Dimension Adding Member Overrides to an Item Level Adding Measures That Use Plug-ins Including Text Analytics Results in Listings Text Analytics Domain Management Advanced Topics When the NLP Updates Occur Defining Term Lists Overview of Term Lists Accessing the Term List Manager Defining a Term List Specifying the Pattern for a Term List Exporting and Importing Term Lists Deleting a Term List Accessing Term Lists Programmatically Defining Worksheets Defining Quality Measures Overview of Quality Measures Introduction to the Quality Measure Manager Creating a Quality Measure Specifying the Expression for a Quality Measure Editing Other Information for a Quality Measure Defining a Linked Quality Measure (Quality Measure Alias) Checking the Expression for a Quality Measure Deleting a Quality Measure Defining Basic KPIs Introduction to KPIs Choosing Between MDX and SQL Structure of a KPI Result Set Defining a KPI with a Hardcoded Query Specifying Class Parameters Specifying Ranges and Thresholds for Speedometers Disabling the %CONTEXT Filter Defining KPIs with Filters and Listings Introduction to Filters Creating Interoperable Filters Defining Filters in an MDX-Based KPI Defining Filters in an SQL-Based KPI Other Options for Defining Filter Names and Items Modifying an MDX Query to Use Filter Values Modifying an SQL Query to Use Filter Values Additional MDX KPI Examples Defining a Listing for a KPI Defining Advanced KPIs Defining Manual KPIs Defining Cacheable KPIs Defining Asynchronous KPIs Defining Plug-ins Introduction Requirements for a Simple Plug-in Implementing %OnCompute() Indicating State of Completion Creating a Plug-in for Multiple Cubes Filtering the Listing Available Error Logging Defining a Calculated Member That Uses a Plug-in Using Cube Inheritance Introduction to Cube Inheritance Cube Inheritance and the Architect The %cube Shortcut Hiding or Removing Items Inheritance and Relationships Defining Intermediate Expressions Defining and Using Intermediate Expressions in Studio Defining Intermediate Expressions in Architect Other Options Specifying maxFacts in the Cube Definition Restricting the Records Used in the Cube Manually Specifying the Members for a Level Adding Custom Indices to the Fact Table Customizing Other Cube Callbacks Filtering a Cube or Subject Area Dynamically Reference Information for KPI and Plug-in Classes Basic Requirements Common Attributes in a KPI or Plug-in <kpi> <property> <filter> <action> Generating Secondary Cubes for Use with Text Analytics Entity Occurrence Cube Matching Results Cube