Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Diversity and Inclusion
  • Related Documents
  • Conventions
• Part I Before You Begin
  • 1 Introduction to Semantic Models
    • What Is a Semantic Model?
    • About a Semantic Model's Architecture
    • How Does a Semantic Model Query Data?
    • What Is SMML?
    • Oracle Analytics Data Modeling Tools
    • What Is Oracle Analytics Semantic Modeler?
  • 2 Plan a Semantic Model
    • Understand a Semantic Model's Requirements
    • Components of a Semantic Model
    • Plan the Physical Layer
      • About Physical Schema Types
      • Identify the Data Source Table Structure
      • Physical Layer Design Tips
    • Plan the Logical Layer
      • Guidelines for Identifying the Logical Layer's Content
      • Identify the Logical Fact Tables
      • Identify the Logical Dimension Tables
      • Identify Dimensions
      • Identify Lookup Tables
      • Logical Layer Design Tips
      • Model Outer Joins
    • Plan the Presentation Layer
• Part II Create and Build Your Model
  • 3 Get Started with Semantic Modeling
    • Workflow to Build a Semantic Model
    • Semantic Model Object Naming Requirements
    • Edit Semantic Model Objects Using the SMML Editor
  • 4 Develop Semantic Models in a Collaborative Environment
    • About Collaborative Semantic Model Development
    • Use Permissions for Collaborative Semantic Model Development
    • About Using Git with Semantic Model Development
    • Upload a Semantic Model to a Git Repository Using HTTPS
    • Upload a Semantic Model to a Git Repository Using SSH
    • Work With Branches
    • View and Manage Git Profiles
    • Understand and Resolve Merge Conflicts
      • What are Merge Conflicts?
      • About the Merge Editor
      • Understand How to Resolve Conflicts
      • Change Git's Merge Strategy
      • Cancel All Merge Conflicts
      • Resolve All Merge Conflicts
      • Resolve Individual Merge Conflicts
  • 5 Migrate From Model Administration Tool
    • Plan Your Migration From Model Administration Tool to Semantic Modeler
    • Understand the Differences Between Model Administration Tool and Semantic Modeler
    • Prepare the Semantic Model for Migration to Semantic Modeler
    • Import the Semantic Model From the Model Administration Tool .rpd File
    • Import the Semantic Model Deployed From Model Administration Tool
    • Update the Semantic Model After Migration From Model Administration Tool
  • 6 Migrate From Data Modeler to Semantic Modeler
    • Plan Your Migration From Data Modeler to Semantic Modeler
    • Import the Semantic Model From Data Modeler
    • Set the Migrated Semantic Model's Connection Pools
    • Fix a Semantic Model's Database Names Used by Initialization Blocks and Variables
    • Remove Duplicate Additional Keys
  • 7 Work with a Semantic Model's Data Source Connections
    • Data Sources Supported for Semantic Models
    • About Semantic Model Data Source Connections
    • View Data Source Connections Available to Semantic Models
  • 8 Create a Semantic Model
    • Create an Empty Semantic Model
    • Import a File to Create a Semantic Model
    • Import the Deployed Model to Create a Semantic Model
    • Clone a Git Repository Using HTTPS to Create a Semantic Model
    • Clone a Git Repository Using SSH to Create a Semantic Model
  • 9 Build a Semantic Model's Physical Layer
    • What is the Physical Layer?
    • About Importing Metadata into the Physical Layer
    • Create a Database and Add Tables to the Physical Layer
    • Add a Catalog to a Database
    • Add a Schema to a Database or Catalog
    • Use a Variable to Dynamically Name a Catalog or Schema
    • Change a Database Object's Database Type
    • Modify a Database's Data Source Properties and Supported Query Features
      • Add or Modify a Database's Data Source Properties
      • What Are Supported Query Features?
      • Modify a Database's Supported Query Features
    • Work with Connection Pools
      • What Are Connection Pools?
      • About Connection Pools for Initialization Blocks
      • Connection Pool General Properties
      • Set a Connection Pool's General Properties
      • Set a Connection Pool's Connection Property
      • Add Connection Scripts to a Connection Pool
      • About Setting the Bulk Insert Buffer Size and Transaction Boundary Settings
      • Set up Write Back in a Connection Pool
      • Set a Connection Pool's Permissions
    • About Physical Tables
    • What Are a Physical Table's General Properties?
    • Disable Auto Joins Creation in the Physical Layer
    • Create a Physical Table
    • Create or Modify a Physical Column
    • Populate Physical Columns with a Stored Procedure or Select Statement
    • About Physical Alias Tables
    • Create an Alias Table
    • Open the Physical Diagram from the Physical Layer
    • Delete a Physical Table
    • Delete a Physical Column
    • Work with Physical Joins
      • About Physical Joins
      • About Joining Fragmented Data
      • Add and Define Physical Joins
    • Use Hints in SQL Statements
      • About Hints in SQL Statements
      • About the Index Hint
      • About the Leading Hint
      • Performance Considerations for SQL Statement Hints
      • Create Physical Table Hints
      • Create Physical Join Hints
    • Preview Data in Physical Tables
  • 10 Build a Semantic Model's Logical Layer
    • What is the Logical Layer?
    • Automatically Rename Logical Layer Objects
    • Create a Business Model in the Logical Layer
    • About Logical Tables
    • Create a Fact, Dimension, or Lookup Logical Table
    • Work with Logical Columns
      • About Logical Columns
      • Add or Modify a Logical Column
      • Delete a Logical Column's Logical Table Source
      • Base a Logical Column's Sort Order on a Different Column
      • Add Double Column Support
      • Create Derived Columns
      • Configure Logical Columns for Multicurrency Support
    • Specify a Logical Table's Primary Key
    • Work with Logical Joins
      • About Logical Joins
      • What Are Driving Tables?
      • What Determines Join Trimming?
      • Add and Define Logical Joins
      • Identify the Physical Tables That Map to Logical Tables
    • Open the Logical Diagram
    • Open the Physical Diagram from the Logical Layer
    • Work with Logical Column Aggregation
      • About Levels of Aggregation
      • Set Aggregation Rules for a Measure Column
      • Set an Aggregation Level Based on a Dimension for a Measure Column
      • Associate an Attribute with a Logical Level in Dimension Tables
    • Enable Write Back On Columns
    • Work with Bridge Tables
      • About Bridge Tables
      • Create Joins in the Physical Layer for Bridge and Associated Dimension Tables
      • Model the Associated Dimension Tables in a Single Dimension
      • Model the Associated Dimension Tables in Separate Dimensions
  • 11 Build a Semantic Model's Presentation Layer
    • What is the Presentation Layer?
    • About Alternative Names for Presentation Objects
    • Work with Subject Areas
      • About Creating Subject Areas
      • About the Implicit Fact Column
      • Create a Subject Area
    • Work with Presentation Tables and Columns
      • About Presentation Tables
      • Create a Presentation Table
      • About Presentation Columns
      • Create a Presentation Column
      • Modify a Presentation Column Name
      • Delete a Presentation Column
      • Reorder and Nest Tables for End Users
    • Work with Presentation Hierarchies and Levels
      • About Presentation Hierarchies and Levels
      • About Creating Presentation Hierarchies
      • About Adding Logical Hierarchies with Multiple Hierarchies to the Presentation Layer
      • Add a Presentation Hierarchy to a Presentation Table
      • Add and Modify Presentation Hierarchy Levels
    • Write an Expression to Hide a Presentation Object
    • Work with Localization
      • Modify or Delete Individual Localization Keys and Variables
      • Clear All Name and Description Variables
      • Generate Localization Keys and Name and Description Variables
      • Externalize Strings for a Subject Area
      • Externalize Strings for All Subject Areas
      • Translate Strings
  • 12 Work with a Semantic Model's Logical Hierarchies
    • About Working with Logical Hierarchies in a Semantic Model
    • Create and Manage Level-Based Hierarchies in a Semantic Model
      • About Level-Based Hierarchies
      • About Hierarchy Structures
      • About Using Dimension Hierarchy Levels in Level-Based Hierarchies
      • Automatically Create Dimensions with Level-Based Hierarchies
      • Manually Create Dimensions in Level-Based Hierarchies
      • Create Logical Levels in a Logical Dimension Table
      • Associate a Logical Column and Its Table with a Dimension Level
      • About Level-Based Measure Calculations
      • Grand Total Dimensional Hierarchy Example
      • Identify the Primary Key for a Dimension Level
      • Select and Sort Chronological Keys in a Time Dimension
      • Add a Dimension Level to the Preferred Drill Path
    • Create and Manage Parent-Child Hierarchies in a Semantic Model
      • About Parent-Child Hierarchies
      • About Levels and Distances in Parent-Child Hierarchies
      • About Parent-Child Relationship Tables
      • Create Dimensions with Parent-Child Hierarchies
      • Generate Scripts to Create a Parent-Child Relationship Table
      • Add the Parent-Child Relationship Table to the Semantic Model
      • Define Parent-Child Relationship Tables
      • About Modeling Aggregates for Parent-Child Hierarchies
      • About Storing Facts for Parent-Child Hierarchies
      • About Aggregating Parent-Child Hierarchies
      • Maintain Parent-Child Hierarchies Based on Relational Tables
    • Model Time Series Data in a Semantic Model
      • About Time Series Functions for Semantic Models
      • About the AGO Time Series Function
      • About the TODATE Time Series Function
      • About the PERIODROLLING Time Series Function
      • About Creating Logical Time Dimensions in a Semantic Model
      • About Setting Chronological Keys in a Semantic Model
      • Create the Logical Time Dimension in a Semantic Model
      • Create AGO, TODATE, and PERIODROLLING Measures in a Semantic Model
  • 13 Manage Logical Table Sources
    • What are Logical Table Sources?
    • How Are Fact Logical Table Sources Selected to Answer a Query?
    • How Are Dimension Logical Table Sources Selected to Answer a Query?
    • Change the Default Selection Criteria for Dimension Logical Table Sources
    • About Consistency Among Data in Multiple Table Sources
    • Add Logical Table Sources
    • Enable or Disable a Logical Table Source
    • Work With Logical Table Source Priorities
      • About Assigning Logical Table Sources Priority Order
      • Set the Logical Table Sources Priority Order
      • Reverse the Table Source Priority Ranking at Query Time
    • Modify a Logical Table Source's Logical Column to Physical Column Mappings
    • Map a Logical Table Source's Logical Column to a Calculated Item
    • Work With Data Granularity
      • About Data Granularity
      • About Aggregate Tables
      • About Aggregate Table Joins
      • About the Logical Table Source's Parent-Child Settings
      • Define Logical Table Source Data Granularity
    • Work With Logical Table Source Data Fragmentation
      • About Data Fragmentation
      • About Global Variables and Logical Table Source Fragmentation
      • Define Data Fragmentation for a Logical Table Source
      • Improve the Performance of Fragmented Logical Table Sources
      • Work With Fragmentation for Aggregate Navigation
        • Specify Fragmentation for Single Column, Value-Based Predicates
        • Specify Fragmentation for Single Column, Range-Based Predicates
          • Specify Multicolumn Content Descriptions
          • Specify Parallel Content Descriptions
          • Specify Unbalanced Parallel Content Descriptions
          • Examples of Parallel Content Descriptions
      • Work With Aggregate Table Fragments
        • About Aggregate Table Fragments
        • Specify the Aggregate Table Content
        • Define a Physical Layer Table with a Select Statement to Complete the Domain
        • Specify the SQL Virtual Table Content
        • Create Physical Joins for the Virtual Table
    • Work With Logical Table Source Data Filters
      • About Logical Table Source Data Filters
      • Add a Data Filter to a Logical Table Source
  • 14 Create and Use Variables in a Semantic Model
    • About Semantic Model Variables
    • Create and Configure Initialization Blocks
      • Create an Initialization Block
      • Open an Initialization Block
      • Defer Session Variable Processing
      • When You Can't Defer Session Variable Processing
      • About Dynamically Creating Session Variables and Setting Their Values
      • Use a List of Values to Initialize a Session Variable
      • Create a Schedule to Update Global Variable Values
      • Add an Additional Database Query to an Initialization Block
      • Initialization Queries Used in Variables to Override Selection Steps
      • Test an Initialization Block's Query
      • Change the Order of Variables in an Initialization Block
      • Add Dependencies to an Initialization Block
      • Disable or Enable an Initialization Block
    • Define Global Variables
      • About Global Variables
      • Create a Global Variable
    • Define Session Variables
      • About Session Variables
      • About Multi-Source Session Variables
      • Create a Session Variable
      • Example - Create and Use a Multi-Source Session Variable
        • Create a Multi-Source Session Variable
        • Use a Multi-Source Session Variable in an Expression
        • Use a Multi-Source Session Variable in a Data Filter
    • Define Static Variables
      • About Static Variables
      • Create a Static Variable
  • 15 Support Multilingual Data
    • What Is Multilingual Data Support?
    • What is Lookup?
    • What Is Double Column Support?
    • Design Translation Lookup Tables in Multilingual Schema
    • Create Logical Lookup Tables and Logical Lookup Columns
      • Create Logical Lookup Tables
      • Designate a Logical Table as a Lookup Table
      • About the LOOKUP Function Syntax
      • Create Logical Lookup Columns
    • Create Physical Lookup Tables and Physical Lookup Columns
    • Enable Lexographical Sorting
  • 16 Apply Data Access Security to Semantic Model Objects
    • About Data Access Security
    • Work With Row-Level Security
      • About Row-Level Security
      • Where to Set Up Row-Level Security
      • Set Up Row-Level Security in the Database
      • About Data Filters and Row-Level Security
      • Set Up Data Filters in the Semantic Model
      • About Specifying Functional Groups for Application Roles in Data Filters
      • Specify a Functional Group for a Data Filter's Application Role
    • Work With Object Permissions
      • About Object Permissions
      • About Permission Inheritance for Application Roles
      • Set Up Presentation Object Permissions
    • Work With Query Limits
      • Limit the Number of Rows in a Database Query
      • Limit Database Queries by Maximum Run Time
      • Allow or Disallow Direct Database Requests
      • Override an Application Role's Query Limits
      • Pause an Application Role's Query Limits
  • 17 Check Consistency and Deploy a Semantic Model
    • Work with Check Consistency
      • About Check Consistency
      • Types of Semantic Model Consistency Checks
      • Common Consistency Check Messages
      • Check the Consistency of a Semantic Model
      • Check Consistency of One or More Semantic Model Objects
      • Run the Advanced Consistency Check Before Deploying a Semantic Model
      • Find and View Advanced Check History
      • Why Are the Advanced Check Records in a Different Language?
      • Show or Hide the Advanced Check Warning Message
      • Export Consistency Check Results to a CSV File
    • Deploy a Semantic Model
  • 18 Manage Semantic Models
    • Import the Deployed Model Into Your Semantic Model
    • Import an .rpd or .zip File Into Your Semantic Model
    • Generate JSON/SMML from an .rpd File
    • Export a Semantic Model
    • Generate an .rpd file from JSON/SMML
    • Download an Exported .rpd File
    • Compress SMML Files to a .zip File on Windows
    • Use Terminal to Compress SMML Files to a .zip File on Mac
    • View a Semantic Model's Logs
    • View a Semantic Model's Job History
    • Generate Indexes for a Semantic Model
• Part III Reference
  • 19 Design Tips
    • Business Model Design
    • Time Dimension Design
    • Physical Table Alias
    • Implicit Facts in Subject Areas
    • Dimensional Hierarchies, Level Keys and Content Levels
  • 20 Miscellaneous Reference Information
    • Keyboard Shortcuts for Semantic Modeler
    • Manually Create Relationship Tables for Parent-Child Hierarchies Using Scripts
    • Model Binary Large Object (BLOB) Data and Character Large Object (CLOB) Data
  • 21 Data Types Supported by Oracle Analytics Cloud
    • Data Types Supported by Oracle Analytics
    • Data Type Limitations
    • Floating Point Limitations
    • SQL Identifier Character Limitation
    • Data Type Mapping in Oracle Database and Oracle Analytics
  • 22 Expression Editor Reference
    • SQL Operators
    • Conditional Expressions
    • Functions
      • Aggregate Functions
      • Analytics Functions
      • Date and Time Functions
      • Date Extraction Functions
      • Conversion Functions
      • Display Functions
      • Evaluate Functions
      • Mathematical Functions
      • Running Aggregate Functions
      • Spatial Functions
      • String Functions
      • System Functions
      • Time Series Functions
    • Constants
    • Types
    • Variables
• Part IV Appendix - Build Semantic Models Using Model Administration Tool
  • 23 Upload Semantic Model Files from Oracle Analytics Server
    • About Uploading Semantic Model Files from Oracle Analytics Server to the Cloud
    • Get Your Semantic Model File Ready
    • Upload Semantic Models from a .rpd File Using Console
  • 24 Edit Semantic Model Files Using Model Administration Tool
    • About Editing Semantic Models Using Model Administration Tool
    • Download and Install Oracle Analytics Client Tools
    • Connect to a Semantic Model in the Cloud
    • Edit a Semantic Model in the Cloud
    • Upload a Semantic Model to the Cloud
    • Connect to a Data Source Using a Console Connection
    • Connect to a Data Source Using a Data Connection
    • Build a Semantic Model from Analytic Views in Oracle Autonomous Data Warehouse
      • Overview to Connecting to Analytic Views
      • Create and Upload a Semantic Model Based on an Analytic View
      • Connect to Analytic Views in Oracle Autonomous Data Warehouse
    • Working with Model Administration Tool
    • Using Oracle Analytics Client Tools on Linux
    • Troubleshoot Issues with Model Administration Tool (Oracle Analytics Client Tools)
  • 25 Create a New Semantic Model Using Model Administration Tool
    • About Creating Semantic Models with Model Administration Tool
    • Typical Workflow to Model Data Using Model Administration Tool
    • Create a New Semantic Model File in Model Administration Tool