Defining Models for InterSystems IRIS Business Intelligence Overview of InterSystems IRIS Business Intelligence Models Purpose of Business Intelligence Introduction to Business Intelligence Models Introduction to the Model Development Process Introduction to the Architect Accessing the Samples Basic Concepts Introduction to Cubes Dimensions, Hierarchies, and Levels Properties Measures Listings Calculated Members Subject Areas Filters How the System Builds and Uses Fact Tables How the System Generates Listings Summary of Model Options Items That You Can Use in Pivot Tables Items That You Can Use in Calculated Members and Measures Comparison of Possible Widget Data Sources High-Level Summary of Options Principles and Recommendations Choosing a Base Table Choosing the Form of the Base Table Avoiding Large Numbers of Levels and Measures Defining Measures Appropriately Understanding Time Levels Defining Hierarchies Appropriately Defining Member Keys and Names Appropriately Avoiding Very Granular Levels Using List-Based Levels Carefully Handling Null Values Correctly Usability Considerations Considerations with Multiple Cubes Recommendations Defining Models for InterSystems Business Intelligence Defining a Cube Possible Source Classes for a Cube Other Cube Options Adding Items to a Cube Names for Model Elements Other Common Options Compiling and Building a Cube Opening a Cube in the Analyzer Deleting a Cube Compiling and Building Cubes When to Recompile and Rebuild Compiling a Cube Building a Cube Using Selective Build Building the Cube Programmatically Minimizing Cube Size During Development Using Parallel Processing During a Cube Build Build Errors Business Intelligence Task Log Defining Dimensions, Hierarchies, and Levels Overview Creating a New Dimension, Hierarchy, and Level Adding a Hierarchy and Level Adding a Level Defining the Source Values for a Dimension or Level Details for Source Expressions Changing the Order of Dimensions in the Cube Changing the Order of Levels in a Hierarchy Validating Your Levels Details of Defining Levels Ensuring Uniqueness of Member Keys Specifying the Null Replacement String for a Level Defining a List-Based Level Defining a Time Level Defining Custom Time Levels Defining an Age Level Specifying a Range Expression Configuring a Level to Use Display Values Using Property Values as the Member Names Specifying Tooltips for Members Specifying the Sort Order for Members Making the Member Names Localizable Defining Dependencies Between Levels in Different Hierarchies Specifying the Field Names in the Fact Table Defining Properties Adding a Property Getting a Property Value at Runtime Changing the Order of Properties in a Level Specifying the Column Names in the Dimension Tables Special Uses for Properties Defining Measures Adding a Measure Specifying the Measure Type Specifying How to Aggregate a Measure Specifying a Searchable Measure Specifying a Format String Specifying a Format String for a Date Measure Changing the Order of Measures in the Cube Specifying the Field Names in the Fact Table Specifying Additional Filtering for Listings Defining Listings Adding a Listing Defining a Simple Listing Defining a Data Connector Listing Defining an SQL Custom Listing Defining a Map Listing (Geo Listing) Defining Listing Fields About User-Defined Custom Listings Creating a Listing Field Defining Calculated Members Defining a Calculated Measure MDX Recipes for Calculated Measures Defining a Calculated Member (Non-Measure) MDX Recipes for Non-Measure Calculated Members Specifying Additional Filtering for Listings for a Calculated Measure Defining a Named Set Defining Subject Areas Introduction to Subject Areas in the Architect Defining a Subject Area Filtering a Subject Area Specifying Other Subject Area Options Adding Items to a Subject Area Defining an Override for a Measure Defining an Override for a Dimension, Hierarchy, or Level Redefining a Listing or Adding a New Listing Compiling a Subject Area Defining Listing Groups Introduction to Listing Groups Accessing the Listing Group Manager Adding a Listing Group Displaying a Listing Group Adding a Listing to a Listing Group Modifying a Listing Removing a Listing from a Listing Group Compiling a Listing Group Deleting a Listing Group Reference Information for Cube Classes Requirements for a Cube Class Common Attributes in a Cube <cube> <measure> <dimension> <hierarchy> <level> <member> <property> <listing> <listingField> <calculatedMember> <namedSet> <relationship> <expression> <index> Reference Information for Subject Area Classes Requirements for a Subject Area Class Common Attributes in a Subject Area Class <subjectArea> <measure> <dimension> <hierarchy> <level> <listing> <calculatedMember> <namedSet> Details for the Fact and Dimension Tables Fact Table Dimension Tables
