Business Intelligence Portal
  Introducing ibi™ WebFOCUS® and Business Intelligence Portals
    Introducing ibi WebFOCUS and Business Intelligence Portals
    Signing in to ibi WebFOCUS
    Legacy Home Page
    Publishing Content
  Workspace Content in the Resources Tree
    Selecting a Workspace
    Types of Content in the Resources Tree
    Filtering Content in the Resources Tree
    Searching Workspace Content in the Resources Tree
    Creating Shortcuts
    Creating URLs
    Creating Blogs
    Using Favorites
    Sharing Content in ibi WebFOCUS
    Using the Mobile Viewer to Access Content
  Understanding the Structure of Business Intelligence Portals
    Identifying Business Intelligence Portals
    Portal Architecture
    Portal Designer Overview
    Portal Components
  Customizing and Running Portals
    Running a Portal
    Working With Portal Pages
    Removing Customizations
    Using the Easy Selector
    Building a Basic Responsive Portal
    External CSS Theme Support
    Working With Comments
    Localizing Portals
    Creating a Custom Sign-in Page
  Generating Sample Content
    Generating Sample Content Overview
    Analyzing Sample Content
  Using Web-Based Tools to Create Content
    What Are the Web-Based Tools?
    InfoAssist
    Working With Alerts
      Alert Reporting
      Components of an Alert
      Creating and Scheduling an Alert
      Checking Scheduled Alerts
      Using Sample Data to Create and Schedule an Alert
    Creating Reporting Objects
      Reporting Object Tool
    URL Tool
    Text Editor
    Scheduling Tools
    Using Deferred Reporting
  Enhancing Portals Using Interactive Features and Coding Techniques
    Creating Filtered Dashboard Pages
    Using a JavaScript Function to Navigate to a Portal Page
    Advanced Coding Techniques and Coding Considerations
  Introducing Managed Reporting
    Managed Reporting Overview
    Managed Reporting Concepts
    Managed Reporting Interfaces and Tools
    Analyzing Data in an Online Analytic Processing (OLAP) Report
      We Do It Every Day: A Typical Web Query
      OLAP Reporting Requirements
      Characteristics of an OLAP Report
      Three Ways of Working With OLAP Data
      Drilling Down On Dimensions and Measures
      Sorting Data
      Performing a Calculation on a Measure
      Limiting Data
      Visualizing Trends
      Displaying Graphs and Reports
      Controlling the Display of Measures in a Report
      Adding and Removing Dimensions
      Saving OLAP Reports
      Saving and Displaying OLAP Reports and Graphs in Other Formats
    Using the WebFOCUS Viewer
      Navigating a Report With the ibi WebFOCUS Viewer
      Opening and Closing the ibi WebFOCUS Viewer
      Controlling Button Display on the ibi WebFOCUS Viewer
      Using the Viewer Control Panel
  Glossary
  Legal and Third-Party Notices
  Introducing ibi™ WebFOCUS® and Business Intelligence Portals
    Introducing ibi WebFOCUS and Business Intelligence Portals
    Signing in to ibi WebFOCUS
    Legacy Home Page
    Publishing Content
  Workspace Content in the Resources Tree
    Selecting a Workspace
    Types of Content in the Resources Tree
    Filtering Content in the Resources Tree
    Searching Workspace Content in the Resources Tree
    Creating Shortcuts
    Creating URLs
    Creating Blogs
    Using Favorites
    Sharing Content in ibi WebFOCUS
    Using the Mobile Viewer to Access Content
  Understanding the Structure of Business Intelligence Portals
    Identifying Business Intelligence Portals
    Portal Architecture
    Portal Designer Overview
    Portal Components
  Customizing and Running Portals
    Running a Portal
    Working With Portal Pages
    Removing Customizations
    Using the Easy Selector
    Building a Basic Responsive Portal
    External CSS Theme Support
    Working With Comments
    Localizing Portals
    Creating a Custom Sign-in Page
  Generating Sample Content
    Generating Sample Content Overview
    Analyzing Sample Content
  Using Web-Based Tools to Create Content
    What Are the Web-Based Tools?
    InfoAssist
    Working With Alerts
      Alert Reporting
      Components of an Alert
      Creating and Scheduling an Alert
      Checking Scheduled Alerts
      Using Sample Data to Create and Schedule an Alert
    Creating Reporting Objects
      Reporting Object Tool
    URL Tool
    Text Editor
    Scheduling Tools
    Using Deferred Reporting
  Enhancing Portals Using Interactive Features and Coding Techniques
    Creating Filtered Dashboard Pages
    Using a JavaScript Function to Navigate to a Portal Page
    Advanced Coding Techniques and Coding Considerations
  Introducing Managed Reporting
    Managed Reporting Overview
    Managed Reporting Concepts
    Managed Reporting Interfaces and Tools
    Analyzing Data in an Online Analytic Processing (OLAP) Report
      We Do It Every Day: A Typical Web Query
      OLAP Reporting Requirements
      Characteristics of an OLAP Report
      Three Ways of Working With OLAP Data
      Drilling Down On Dimensions and Measures
      Sorting Data
      Performing a Calculation on a Measure
      Limiting Data
      Visualizing Trends
      Displaying Graphs and Reports
      Controlling the Display of Measures in a Report
      Adding and Removing Dimensions
      Saving OLAP Reports
      Saving and Displaying OLAP Reports and Graphs in Other Formats
    Using the WebFOCUS Viewer
      Navigating a Report With the ibi WebFOCUS Viewer
      Opening and Closing the ibi WebFOCUS Viewer
      Controlling Button Display on the ibi WebFOCUS Viewer
      Using the Viewer Control Panel
  Glossary
  Legal and Third-Party Notices
ibi™ WebFOCUS® InfoAssist Online Help
  Introducing InfoAssist
    InfoAssist Highlights
    Accessing InfoAssist
    Additional InfoAssist Types
  Navigating the InfoAssist Interface
    InfoAssist Application Window
    Application Main Menu
    Quick Access Toolbar
    Ribbon
    Home Tab
    Insert Tab
    Format Tab
    Data Tab
    Slicers Tab
    Layout Tab
    View Tab
    Field Tab
    Series Tab
    Understanding the Resources Panel
    Understanding the Canvas
    Using the Navigation Taskbar
    Using the Status Bar
  Creating and Customizing Reports
    Creating Reports
    Styling Reports
    Changing a Field Format
    Using Custom Reporting Features
    Creating Customized Report Outputs
  Creating and Customizing Charts
    Visualizing Your Data With Charts
    Using Insight to Analyze Dynamic Charts
    Selecting a Chart Type
    Creating Charts
    Binning
    Accessing Chart Formatting Tools
    Formatting a Series
    Formatting Data Labels
    Formatting a Legend
    Formatting Gridlines
    Formatting Axis Labels
    Formatting a Frame and a Background
    Formatting a Gauge Chart
    Formatting Page Headings and Page Footings
    Using Additional Formatting Features
  Creating and Customizing Documents
    Accessing Document Mode
    Building a Document
    Building Infographics in InfoAssist
  Creating and Customizing Visualizations
    Creating a Visual
    Selecting a Visual
    Interacting With Visualizations
    Customizing Visualizations
    Using Storyboards
    Animating Visualizations
    Using Visualizations at Run-Time
  Navigating Reports and Charts
    Using Auto Drill
    Using the Auto Linking Feature to Link Content
    Using Multi Drill
  Styling Reports, Charts, and Visualizations
    Customizing Reports
    Using the Report Style Dialog Box
    Using the Color Dialog Box
    Accessing Reporting Options in the Report Group
    Enabling Report Features
    Enabling Chart Features
    Labeling Charts
    Using Interactive Options
    Customizing Page Setup
  Creating Maps to Illustrate Trends
    A Brief History of Mapping
    InfoAssist and Esri Integration
    Customizing the List of Geographic Roles
    Customizing the List of Basemap Definitions
    Enabling Additional Territories in a Leaflet Map
  Manipulating Data
    Missing Data in a Chart
    Adding and Switching Data Sources
    Setting the Source of Your Data
    Creating Virtual Fields in ibi WebFOCUS
    RStat Scoring Routines in InfoAssist
    Joining and Blending Data
    Using Filters to Customize the Display of Data
    Output Formats
  Creating HOLD Files
    Valuable Applications of HOLD Files
    Storing HOLD Files
    Output Formats for Reports and Charts
    Creating HOLD Files
    Creating a Subquery Filter Using a HOLD File
  Creating Multi-Page Documents
    Creating Multi-Page Documents
    Creating a Multi-page Dashboard
    Navigating the Page Menu
    Using the Cache Option
    Enabling Cache Through InfoAssist
  Creating Interactive Content
    Overview of In-Document Analytics
    Enabling In-Document Analytics in InfoAssist
    Developing Interactive Content
    Working With Interactive Content
  Using Slicers
    Creating Slicers
    Filtering With Slicers
    Edit Slicers Dialog Box
  Building InfoMini Applications
    Understanding InfoMini Applications
    Creating an InfoMini Application
  Ribbon Command Reference
    Ribbon Commands for Reports
    Ribbon Commands for Charts
    Ribbon Commands for Documents
    Ribbon Commands for Visualizations
  Understanding Warning Messages in InfoAssist
    InfoAssist Warning Messages
    Unsupported Syntax and Objects
  Glossary
  Legal and Third-Party Notices
  Introducing InfoAssist
    InfoAssist Highlights
    Accessing InfoAssist
    Additional InfoAssist Types
  Navigating the InfoAssist Interface
    InfoAssist Application Window
    Application Main Menu
    Quick Access Toolbar
    Ribbon
    Home Tab
    Insert Tab
    Format Tab
    Data Tab
    Slicers Tab
    Layout Tab
    View Tab
    Field Tab
    Series Tab
    Understanding the Resources Panel
    Understanding the Canvas
    Using the Navigation Taskbar
    Using the Status Bar
  Creating and Customizing Reports
    Creating Reports
    Styling Reports
    Changing a Field Format
    Using Custom Reporting Features
    Creating Customized Report Outputs
  Creating and Customizing Charts
    Visualizing Your Data With Charts
    Using Insight to Analyze Dynamic Charts
    Selecting a Chart Type
    Creating Charts
    Binning
    Accessing Chart Formatting Tools
    Formatting a Series
    Formatting Data Labels
    Formatting a Legend
    Formatting Gridlines
    Formatting Axis Labels
    Formatting a Frame and a Background
    Formatting a Gauge Chart
    Formatting Page Headings and Page Footings
    Using Additional Formatting Features
  Creating and Customizing Documents
    Accessing Document Mode
    Building a Document
    Building Infographics in InfoAssist
  Creating and Customizing Visualizations
    Creating a Visual
    Selecting a Visual
    Interacting With Visualizations
    Customizing Visualizations
    Using Storyboards
    Animating Visualizations
    Using Visualizations at Run-Time
  Navigating Reports and Charts
    Using Auto Drill
    Using the Auto Linking Feature to Link Content
    Using Multi Drill
  Styling Reports, Charts, and Visualizations
    Customizing Reports
    Using the Report Style Dialog Box
    Using the Color Dialog Box
    Accessing Reporting Options in the Report Group
    Enabling Report Features
    Enabling Chart Features
    Labeling Charts
    Using Interactive Options
    Customizing Page Setup
  Creating Maps to Illustrate Trends
    A Brief History of Mapping
    InfoAssist and Esri Integration
    Customizing the List of Geographic Roles
    Customizing the List of Basemap Definitions
    Enabling Additional Territories in a Leaflet Map
  Manipulating Data
    Missing Data in a Chart
    Adding and Switching Data Sources
    Setting the Source of Your Data
    Creating Virtual Fields in ibi WebFOCUS
    RStat Scoring Routines in InfoAssist
    Joining and Blending Data
    Using Filters to Customize the Display of Data
    Output Formats
  Creating HOLD Files
    Valuable Applications of HOLD Files
    Storing HOLD Files
    Output Formats for Reports and Charts
    Creating HOLD Files
    Creating a Subquery Filter Using a HOLD File
  Creating Multi-Page Documents
    Creating Multi-Page Documents
    Creating a Multi-page Dashboard
    Navigating the Page Menu
    Using the Cache Option
    Enabling Cache Through InfoAssist
  Creating Interactive Content
    Overview of In-Document Analytics
    Enabling In-Document Analytics in InfoAssist
    Developing Interactive Content
    Working With Interactive Content
  Using Slicers
    Creating Slicers
    Filtering With Slicers
    Edit Slicers Dialog Box
  Building InfoMini Applications
    Understanding InfoMini Applications
    Creating an InfoMini Application
  Ribbon Command Reference
    Ribbon Commands for Reports
    Ribbon Commands for Charts
    Ribbon Commands for Documents
    Ribbon Commands for Visualizations
  Understanding Warning Messages in InfoAssist
    InfoAssist Warning Messages
    Unsupported Syntax and Objects
  Glossary
  Legal and Third-Party Notices
Managed Reporting
  Introducing Managed Reporting
    Managed Reporting Overview
    Managed Reporting Concepts
    Managed Reporting Interfaces and Tools
  Analyzing Data in an Online Analytic Processing (OLAP) Report
    We Do It Every Day: A Typical Web Query
    OLAP Reporting Requirements
    Characteristics of an OLAP Report
    Three Ways of Working With OLAP Data
    Drilling Down On Dimensions and Measures
    Sorting Data
    Performing a Calculation on a Measure
    Limiting Data
    Visualizing Trends
    Displaying Graphs and Reports
    Controlling the Display of Measures in a Report
    Adding and Removing Dimensions
    Saving OLAP Reports
    Saving and Displaying OLAP Reports and Graphs in Other Formats
  Using the Viewer
    Navigating a Report With the ibi WebFOCUS Viewer
    Opening and Closing the TIBCO Viewer
    Controlling Button Display on the TIBCO Viewer
    Using the Viewer Control Panel
  Legal and Third-Party Notices
  Introducing Managed Reporting
    Managed Reporting Overview
    Managed Reporting Concepts
    Managed Reporting Interfaces and Tools
  Analyzing Data in an Online Analytic Processing (OLAP) Report
    We Do It Every Day: A Typical Web Query
    OLAP Reporting Requirements
    Characteristics of an OLAP Report
    Three Ways of Working With OLAP Data
    Drilling Down On Dimensions and Measures
    Sorting Data
    Performing a Calculation on a Measure
    Limiting Data
    Visualizing Trends
    Displaying Graphs and Reports
    Controlling the Display of Measures in a Report
    Adding and Removing Dimensions
    Saving OLAP Reports
    Saving and Displaying OLAP Reports and Graphs in Other Formats
  Using the Viewer
    Navigating a Report With the ibi WebFOCUS Viewer
    Opening and Closing the TIBCO Viewer
    Controlling Button Display on the TIBCO Viewer
    Using the Viewer Control Panel
  Legal and Third-Party Notices
ReportCaster
  Introducing ReportCaster
    About ReportCaster
    ReportCaster Overview
    Creating a Schedule in a Self-Service Installation
    Section 508 Compliance
    ReportCaster Processing
    Distribution Server Features
  Using the ReportCaster Console
    Using the ReportCaster Console
    Server Status
    Using the Java Heap Dump Feature
    Server Performance
    Failover Distribution Server Status and Tasks
    Job Status
    Job Log
    ReportCaster Configuration
    Using Blackout Periods
    Controlling When Schedules Run After Blackout Periods
    Execution IDs
    Global Updates
    Purge Job Logs
  Creating and Maintaining Distribution Lists
    Creating a Distribution List
    Editing and Deleting a Distribution List
    Accessing Distribution Lists
    Bursting a Report
    Creating an External Distribution File
    Importing a List of Members to Create Distribution Lists
    Creating a Dynamic Distribution List
    Generating a Dynamic Distribution List From WebFOCUS Repository Procedures
    Specifying Multiple Email Addresses
  Creating Schedules
    About the Basic Scheduling Tool
    Creating a Schedule in the Basic Scheduling Tool
    About Tasks in the Basic Scheduling Tool
    Using Amper Variables as Parameter Values
    Distribution Options in the Basic Scheduling Tool
    Auto-Populating the FTP Field for Single File FTP Distributions
    Auto-Populating the Title of a Report Library File
    Notification Options in the Basic Scheduling Tool
    About Properties in the Basic Scheduling Tool
    About Recurrence in the Basic Scheduling Tool
    Advanced Settings
    Restricting Distribution of Reports to the Report Library
  Creating a ReportCaster Schedule in the Advanced Scheduling Tool
    About the Advanced Scheduling Tool
    Advanced Scheduling Tool Quick Access Toolbar
    Advanced Scheduling Ribbon
    Creating a Schedule in the Advanced Scheduling Tool
    About Tasks in the Advanced Scheduling Tool
    Using the WebFOCUS Schedule Task Type to Schedule Other Schedules
    Distribution Options in the Advanced Scheduling Tool
    Auto-Populating the FTP Field for Single File FTP Distributions in the Advanced Scheduling Tool
    Auto-Populating the Title of a Report Library File in the Advanced Scheduling Tool
    Notification Options in the Advanced Scheduling Tool
    About Properties in the Advanced Scheduling Tool
    About Recurrences in the Advanced Scheduling Tool
  Maintaining Schedules
    About Maintaining a Schedule in the Basic Scheduling Tool
    Editing a Schedule in the Basic Scheduling Tool
    Copying a Schedule
    Deleting a Schedule in the Basic Scheduling Tool
    Sharing Schedules
    Publishing Schedules
  Tracking Schedules
    Log Reports
  Using the Report Library
    About the Report Library
    Privileges Required for Creating and Sharing Library Items
    Viewing Library Content
    Searching in an On-Demand Paging Report
    Opening a Version of a Library Report in Excel and Other Documents
    Creating and Maintaining Library Access Lists
    Accessing Library Access Lists
    Viewing Parameter Values for Library Reports
  ReportCaster Explorer
    Using the ReportCaster Explorer
    Explorer Schedule Toolbar
    Explorer Tree
    Explorer Item List Panel
    Explorer Schedule List Column Information
    Explorer Distribution List Column Information
    Explorer Access List Column Information
    Explorer Library and Watch List Report Column Information
    Explorer Item Options
    Searching Subfolders
  Using Traces
    Enabling Tracing
    Servlet Tracing
    Distribution Server Startup Trace Files
    Schedule and Report Tracing
    Distribution Server Initialization Tracing
    Reporting Server Tracing
  Tips and Techniques for Coding a ReportCaster Report
    Editing WebFOCUS Procedures
    Using an Ampersand or a Single Quotation Mark
    HTML and Drill-Down Reports
    Using -HTMLFORM
    Distributing a Table of Contents Report Using ReportCaster
    Data Visualization
    Using the GRAPH FILE Command
    Distributing a Graph Image in a PDF Report
    Financial Modeling Language
    Using the &&KILL_RPC Flag
    Manually Coded Excel Compound Reports
    Compound Reports and Coordinated Compound Reports
    Controlling the Display of Sorted Data With Accordion Reports
    Limitations for Using WebFOCUS Features
    Known Issues When Using WebFOCUS Commands
    Using WebFOCUS Commands With Burst Reports
    Specifying the Language for Scheduled Output
  ReportCaster Formats for Scheduled Output
    AHTML
    ALPHA
    APDF
    COM
    COMMA
    COMT
    DFIX
    DHTML
    DOC
    EXCEL
    EXL07
    EXL07 FORMULA
    EXL07 TEMPLATE
    EXL2K
    EXL2K FORMULA
    EXL2K PIVOT
    EXL2K TEMPLATE
    EXL97
    GIF
    HTML
    HTML5
    JPEG
    PDF
    PNG
    PPT
    PPT Template
    PPTX
    PPTX Template
    PS
    SVG
    TAB and TABT
    WK1
    WP
    XML
  WebFOCUS Repository Tables for ReportCaster
    About Repository Reports
    WebFOCUS Repository Tables
  ReportCaster Variables
    ReportCaster Internal Variables
  Glossary
  Legal and Third-Party Notices
  Introducing ReportCaster
    About ReportCaster
    ReportCaster Overview
    Creating a Schedule in a Self-Service Installation
    Section 508 Compliance
    ReportCaster Processing
    Distribution Server Features
  Using the ReportCaster Console
    Using the ReportCaster Console
    Server Status
    Using the Java Heap Dump Feature
    Server Performance
    Failover Distribution Server Status and Tasks
    Job Status
    Job Log
    ReportCaster Configuration
    Using Blackout Periods
    Controlling When Schedules Run After Blackout Periods
    Execution IDs
    Global Updates
    Purge Job Logs
  Creating and Maintaining Distribution Lists
    Creating a Distribution List
    Editing and Deleting a Distribution List
    Accessing Distribution Lists
    Bursting a Report
    Creating an External Distribution File
    Importing a List of Members to Create Distribution Lists
    Creating a Dynamic Distribution List
    Generating a Dynamic Distribution List From WebFOCUS Repository Procedures
    Specifying Multiple Email Addresses
  Creating Schedules
    About the Basic Scheduling Tool
    Creating a Schedule in the Basic Scheduling Tool
    About Tasks in the Basic Scheduling Tool
    Using Amper Variables as Parameter Values
    Distribution Options in the Basic Scheduling Tool
    Auto-Populating the FTP Field for Single File FTP Distributions
    Auto-Populating the Title of a Report Library File
    Notification Options in the Basic Scheduling Tool
    About Properties in the Basic Scheduling Tool
    About Recurrence in the Basic Scheduling Tool
    Advanced Settings
    Restricting Distribution of Reports to the Report Library
  Creating a ReportCaster Schedule in the Advanced Scheduling Tool
    About the Advanced Scheduling Tool
    Advanced Scheduling Tool Quick Access Toolbar
    Advanced Scheduling Ribbon
    Creating a Schedule in the Advanced Scheduling Tool
    About Tasks in the Advanced Scheduling Tool
    Using the WebFOCUS Schedule Task Type to Schedule Other Schedules
    Distribution Options in the Advanced Scheduling Tool
    Auto-Populating the FTP Field for Single File FTP Distributions in the Advanced Scheduling Tool
    Auto-Populating the Title of a Report Library File in the Advanced Scheduling Tool
    Notification Options in the Advanced Scheduling Tool
    About Properties in the Advanced Scheduling Tool
    About Recurrences in the Advanced Scheduling Tool
  Maintaining Schedules
    About Maintaining a Schedule in the Basic Scheduling Tool
    Editing a Schedule in the Basic Scheduling Tool
    Copying a Schedule
    Deleting a Schedule in the Basic Scheduling Tool
    Sharing Schedules
    Publishing Schedules
  Tracking Schedules
    Log Reports
  Using the Report Library
    About the Report Library
    Privileges Required for Creating and Sharing Library Items
    Viewing Library Content
    Searching in an On-Demand Paging Report
    Opening a Version of a Library Report in Excel and Other Documents
    Creating and Maintaining Library Access Lists
    Accessing Library Access Lists
    Viewing Parameter Values for Library Reports
  ReportCaster Explorer
    Using the ReportCaster Explorer
    Explorer Schedule Toolbar
    Explorer Tree
    Explorer Item List Panel
    Explorer Schedule List Column Information
    Explorer Distribution List Column Information
    Explorer Access List Column Information
    Explorer Library and Watch List Report Column Information
    Explorer Item Options
    Searching Subfolders
  Using Traces
    Enabling Tracing
    Servlet Tracing
    Distribution Server Startup Trace Files
    Schedule and Report Tracing
    Distribution Server Initialization Tracing
    Reporting Server Tracing
  Tips and Techniques for Coding a ReportCaster Report
    Editing WebFOCUS Procedures
    Using an Ampersand or a Single Quotation Mark
    HTML and Drill-Down Reports
    Using -HTMLFORM
    Distributing a Table of Contents Report Using ReportCaster
    Data Visualization
    Using the GRAPH FILE Command
    Distributing a Graph Image in a PDF Report
    Financial Modeling Language
    Using the &&KILL_RPC Flag
    Manually Coded Excel Compound Reports
    Compound Reports and Coordinated Compound Reports
    Controlling the Display of Sorted Data With Accordion Reports
    Limitations for Using WebFOCUS Features
    Known Issues When Using WebFOCUS Commands
    Using WebFOCUS Commands With Burst Reports
    Specifying the Language for Scheduled Output
  ReportCaster Formats for Scheduled Output
    AHTML
    ALPHA
    APDF
    COM
    COMMA
    COMT
    DFIX
    DHTML
    DOC
    EXCEL
    EXL07
    EXL07 FORMULA
    EXL07 TEMPLATE
    EXL2K
    EXL2K FORMULA
    EXL2K PIVOT
    EXL2K TEMPLATE
    EXL97
    GIF
    HTML
    HTML5
    JPEG
    PDF
    PNG
    PPT
    PPT Template
    PPTX
    PPTX Template
    PS
    SVG
    TAB and TABT
    WK1
    WP
    XML
  WebFOCUS Repository Tables for ReportCaster
    About Repository Reports
    WebFOCUS Repository Tables
  ReportCaster Variables
    ReportCaster Internal Variables
  Glossary
  Legal and Third-Party Notices
Administering ibi™ WebFOCUS®
  ibi™ WebFOCUS® Administration Console
    Using the Administration Console Menu Bar
      Using the Licenses Menu
      Reviewing User Audit Information
      Clearing the Cache
      Closing the Administration Console
      Opening Administration Console Help
    Reporting Servers
      Configuring Reporting Servers
      Alternate Server Mapping
    Configuring and Customizing Your Environment
      Managing Distribution Directories
      Changing Application Settings in the Administration Console
      Changing WebFOCUS Client Settings in the WebFOCUS Administration Console
      Understanding Custom Settings
      Understanding Redirection Settings
      Role Update Utility
      Working With HTML5 Chart Extensions
       Configuring White Labeling
    Configuring WebFOCUS Security
      Understanding Internal Security Page Settings
      Understanding External Security Page Settings
      Using Advanced Settings
      Configuring Security Zones
    ibi™ WebFOCUS® Change Management
      Understanding the Change Management Process
      Creating a Change Management Package
    Configuring WebFOCUS Diagnostics
      Reviewing Version Information
      Reviewing Client Verification
      HTTP Request Headers and JVM Property Information
      Monitoring WebFOCUS Sessions
      Working With Log Files
      Working With Application Log Files
      Managing Data Caches
    WebFOCUS Encryption Features
      Default WebFOCUS Encryption and AES Encryption
      Configuring Encryption in the WebFOCUS Client
    Manipulating ibi™ WebFOCUS® Variables
      Customizing ibi™ WebFOCUS® Request Processing
      ibi™ WebFOCUS® Script and Configuration Files
      ibi™ WebFOCUS® Variables
      ibi™ WebFOCUS® Script Commands
      ibi™ WebFOCUS® Servlet Plug-in
      Managed Reporting Internal Variables
      HTTP Header Variables Available for Script Processing
    Localizing WebFOCUS
      Understanding NLS Settings
      Customizing the Dynamic Language Switch
  User Administration
    Using the Security Center
    Managing Users
    Managing Groups
    Managing Roles
    Managing Rules
    Working With Folders
    Managing Private Resources
    Effective Policy
  Legal and Third-Party Notices
  ibi™ WebFOCUS® Administration Console
    Using the Administration Console Menu Bar
      Using the Licenses Menu
      Reviewing User Audit Information
      Clearing the Cache
      Closing the Administration Console
      Opening Administration Console Help
    Reporting Servers
      Configuring Reporting Servers
      Alternate Server Mapping
    Configuring and Customizing Your Environment
      Managing Distribution Directories
      Changing Application Settings in the Administration Console
      Changing WebFOCUS Client Settings in the WebFOCUS Administration Console
      Understanding Custom Settings
      Understanding Redirection Settings
      Role Update Utility
      Working With HTML5 Chart Extensions
       Configuring White Labeling
    Configuring WebFOCUS Security
      Understanding Internal Security Page Settings
      Understanding External Security Page Settings
      Using Advanced Settings
      Configuring Security Zones
    ibi™ WebFOCUS® Change Management
      Understanding the Change Management Process
      Creating a Change Management Package
    Configuring WebFOCUS Diagnostics
      Reviewing Version Information
      Reviewing Client Verification
      HTTP Request Headers and JVM Property Information
      Monitoring WebFOCUS Sessions
      Working With Log Files
      Working With Application Log Files
      Managing Data Caches
    WebFOCUS Encryption Features
      Default WebFOCUS Encryption and AES Encryption
      Configuring Encryption in the WebFOCUS Client
    Manipulating ibi™ WebFOCUS® Variables
      Customizing ibi™ WebFOCUS® Request Processing
      ibi™ WebFOCUS® Script and Configuration Files
      ibi™ WebFOCUS® Variables
      ibi™ WebFOCUS® Script Commands
      ibi™ WebFOCUS® Servlet Plug-in
      Managed Reporting Internal Variables
      HTTP Header Variables Available for Script Processing
    Localizing WebFOCUS
      Understanding NLS Settings
      Customizing the Dynamic Language Switch
  User Administration
    Using the Security Center
    Managing Users
    Managing Groups
    Managing Roles
    Managing Rules
    Working With Folders
    Managing Private Resources
    Effective Policy
  Legal and Third-Party Notices
Functions
  Simplified Analytic Functions
    FORECAST_MOVAVE: Using a Simple Moving Average
    FORECAST_EXPAVE: Using Single Exponential Smoothing
    FORECAST_DOUBLEXP: Using Double Exponential Smoothing
    FORECAST_SEASONAL: Using Triple Exponential Smoothing
    FORECAST_LINEAR: Using a Linear Regression Equation
    PARTITION_AGGR: Creating Rolling Calculations
    PARTITION_REF: Using Prior or Subsequent Field Values in Calculations
  Simplified Character Functions
    CHAR_LENGTH: Returning the Length in Characters of a String
    LAST_NONBLANK: Retrieving the Last Field Value That is Neither Blank nor Missing
    LOWER: Returning a String With All Letters Lowercase
    LTRIM: Removing Blanks From the Left End of a String
    PATTERNS: Returning a Pattern That Represents the Structure of the Input String
    POSITION: Returning the First Position of a Substring in a Source String
    RTRIM: Removing Blanks From the Right End of a String
    SUBSTRING: Extracting a Substring From a Source String
    TOKEN: Extracting a Token From a String
    TRIM_: Removing a Leading Character, Trailing Character, or Both From a String
    UPPER: Returning a String With All Letters Uppercase
  Character Functions
    ARGLEN: Measuring the Length of a String
    CHKFMT: Checking the Format of a String
    CHKNUM: Checking a String for Numeric Format
    CTRAN: Translating One Character to Another
    CTRFLD: Centering a Character String
    EDIT: Extracting or Adding Characters
    GETTOK: Extracting a Substring (Token)
    LCWORD: Converting a String to Mixed-Case
    LCWORD2: Converting a String to Mixed-Case
    LCWORD3: Converting a String to Mixed-Case
    LENV: Returning the Length of an Alphanumeric Field
    LJUST: Left-Justifying a String
    LOCASE: Converting Text to Lowercase
    OVRLAY: Overlaying a Character String
    PARAG: Dividing Text Into Smaller Lines
    POSIT: Finding the Beginning of a Substring
    RJUST: Right-Justifying a Character String
    SQUEEZ: Reducing Multiple Spaces to a Single Space
    STRREP: Replacing Character Strings
    SUBSTV: Extracting a Variable Length Substring
    TRIMV: Removing Characters From a String
    UPCASE: Converting Text to Uppercase
  Character Functions for DBCS Code Pages
    DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
    DEDIT: Extracting or Adding Characters
    DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
    DSUBSTR: Extracting a Substring
    JPTRANS: Converting Japanese Specific Characters
    KKFCUT: Truncating a String
    SFTDEL: Deleting the Shift Code From DBCS Data
    SFTINS: Inserting the Shift Code Into DBCS Data
  Legacy Character Functions
    STRIP: Removing a Character From a String
    SUBSTR: Extracting a Substring
    TRIM: Removing Leading and Trailing Occurrences
  Special Character Functions
    PATTERN: Generating a Pattern From a String
    SOUNDEX: Comparing Character Strings Phonetically
    SPELLNM: Spelling Out a Dollar Amount
    XMLDECOD: Decoding XML-Encoded Characters
    XMLENCOD: XML-Encoding Characters
  Data Source and Decoding Functions
    CHECKSUM: Computing a Hash Sum
    CHECKMD5: Computing an MD5 Hash Check Value
    DB_EXPR: Inserting an SQL Expression Into a Request
    DB_INFILE: Testing Values Against a File or an SQL Subquery
    DB_LOOKUP: Retrieving Data Source Values
    DECODE: Decoding Values
    LAST: Retrieving the Preceding Value
  Simplified Date and Date-Time Functions
    DT_CURRENT_DATE: Returning the Current Date
    DT_CURRENT_DATETIME: Returning the Current Date and Time
    DT_CURRENT_TIME: Returning the Current Time
    DTADD: Incrementing a Date or Date-Time Component
    DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
    DTIME: Extracting Time Components From a Date-Time Value
    DTPART: Returning a Date or Date-Time Component in Integer Format
    DTRUNC: Returning the Start of a Date Period for a Given Date
   Legacy Date Functions
    AYM: Adding or Subtracting Months
    AYMD: Adding or Subtracting Days
    CHGDAT: Changing How a Date String Displays
    DA Functions: Converting a Legacy Date to an Integer
    DMY, MDY, YMD: Calculating the Difference Between Two Dates
    DOWK and DOWKL: Finding the Day of the Week
    DT Functions: Converting an Integer to a Date
    GREGDT: Converting From Julian to Gregorian Format
    JULDAT: Converting From Gregorian to Julian Format
    TODAY: Returning the Current Date
    YM: Calculating Elapsed Months
  Standard Date Functions
    DATEADD: Adding or Subtracting a Date Unit to or From a Date
    DATECVT: Converting the Format of a Date
    DATEDIF: Finding the Difference Between Two Dates
    DATEMOV: Moving a Date to a Significant Point
    DATETRAN: Formatting Dates in International Formats
    DPART: Extracting a Component From a Date
    FIQTR: Obtaining the Financial Quarter
    FIYR: Obtaining the Financial Year
    FIYYQ: Converting a Calendar Date to a Financial Date
  Date-Time Functions
    HADD: Incrementing a Date-Time Value
    HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
    HDIFF: Finding the Number of Units Between Two Date-Time Values
    HDTTM: Converting a Date Value to a Date-Time Value
    HEXTR: Extracting Components of a Date-Time Value and Setting Remaining Components to Zero
    HGETC: Storing the Current Local Date and Time in a Date-Time Field
    HGETZ: Storing the Current Coordinated Universal Time in a Date-Time Field
    HHMMSS: Retrieving the Current Time
    HHMS: Converting a Date-Time Value to a Time Value
    HINPUT: Converting an Alphanumeric String to a Date-Time Value
    HMASK: Extracting Date-Time Components and Preserving Remaining Components
    HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
    HNAME: Retrieving a Date-Time Component in Alphanumeric Format
    HPART: Retrieving a Date-Time Component as a Numeric Value
    HSETPT: Inserting a Component Into a Date-Time Value
    HTIME: Converting the Time Portion of a Date-Time Value to a Number
    HTMTOTS or TIMETOTS: Converting a Time to a Timestamp
    HYYWD: Returning the Year and Week Number From a Date-Time Value
  Simplified Conversion Functions
    CHAR: Returning a Character Based on a Numeric Code
    CTRLCHAR: Returning a Non-Printable Control Character
    EDIT2: Converting a Numeric, Date, or Date-Time Value to a Character String
    HEXTYPE: Returning the Hexadecimal View of an Input Value
    TO_INTEGER: Converting a Character String to an Integer Value
    TO_NUMBER: Converting a Character String to a Numeric Value
  Format Conversion Functions
    EDIT: Converting the Format of a Field
    FPRINT: Converting Fields to Alphanumeric Format
    ITONUM: Converting a Large Binary Integer to Double-Precision Format
    ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
    ITOZ: Converting a Number to Zoned Format
    PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
    TSTOPACK: Converting an MSSQL or Sybase Timestamp Column to Packed Decimal
  Legacy Functions
    ATODBL: Converting an Alphanumeric String to Double-Precision Format
    BAR: Producing a Bar Chart
    BYTVAL: Translating a Character to Decimal
    BITVAL: Evaluating a Bit String as an Integer
    BITSON: Determining If a Bit Is On or Off
    CHKPCK: Validating a Packed Field
    FIND: Verifying the Existence of a Value in a Data Source
    FTOA: Converting a Number to Alphanumeric Format
    HCNVRT: Converting a Date-Time Value to Alphanumeric Format
    HEXBYT: Converting a Decimal Integer to a Character
    LOOKUP: Retrieving a Value From a Cross-referenced Data Source
    PCKOUT: Writing a Packed Number of Variable Length
    REVERSE: Reversing the Characters in a String
    UFMT: Converting an Alphanumeric String to Hexadecimal
    XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
  Simplified Numeric Functions
    CEILING: Returning the Smallest Integer Value Greater Than or Equal to a Value
    EXPONENT: Raising e to a Power
    FLOOR: Returning the Largest Integer Less Than or Equal to a Value
    MOD: Calculating the Remainder From a Division
    POWER: Raising a Value to a Power
  Numeric Functions
    ABS: Calculating Absolute Value
    DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
    EXP: Raising e to the Nth Power
    EXPN: Evaluating a Number in Scientific Notation
    INT: Finding the Greatest Integer
    LOG: Calculating the Natural Logarithm
    MAX and MIN: Finding the Maximum or Minimum Value
    MIRR: Calculating the Modified Internal Return Rate
    NORMSDST and NORMSINV: Calculating Normal Distributions
    PRDNOR and PRDUNI: Generating Reproducible Random Numbers
    RDNORM and RDUNIF: Generating Random Numbers
    SQRT: Calculating the Square Root
    XIRR: Calculating the Modified Internal Return Rate (Periodic or Non-Periodic)
  Simplified Statistical Functions
    Specify the Partition Size for Simplified Statistical Functions
    CORRELATION: Calculating the Degree of Correlation Between Two Sets of Data
    KMEANS_CLUSTER: Partitioning Observations Into Clusters Based on the Nearest Mean Value
    MULTIREGRESS: Creating a Multivariate Linear Regression Column
    RSERVE: Running an R Script
    STDDEV: Calculating the Standard Deviation for a Set of Data Values
  Simplified System Functions
    EDAPRINT: Inserting a Custom Message in the EDAPRINT Log File
    ENCRYPT: Encrypting a Password
    GETENV: Retrieving the Value of an Environment Variable
    PUTENV: Assigning a Value to an Environment Variable
  System Functions
    CLSDDREC: Closing All Files Opened by the PUTDDREC Function
    FEXERR: Retrieving an Error Message
    FGETENV: Retrieving the Value of an Environment Variable
    FPUTENV: Assigning a Value to an Environment Variable
    GETCOOKI: Retrieving a Browser Cookie Value
    GETHEADR: Retrieving an HTTP Header Variable
    GETUSER: Retrieving a User ID
    GRPLIST: Retrieving the Group List of the Connected User
    PUTCOOKI: Submitting a Value to a Browser Cookie
    PUTDDREC: Writing a Character String as a Record in a Sequential File
    SLEEP: Suspending Execution for a Given Number of Seconds
  Simplified Geography Functions
    Sample Geography Files
    GIS_DISTANCE: Calculating the Distance Between Geometry Points
    GIS_DRIVE_ROUTE: Calculating the Driving Directions Between Geometry Points
    GIS_GEOCODE_ADDR: Geocoding a Complete Address
    GIS_GEOCODE_ADDR_CITY: Geocoding an Address Line, City, and State
    GIS_GEOCODE_ADDR_POSTAL: Geocoding an Address Line and Postal Code
    GIS_GEOMETRY: Building a JSON Geometry Object
    GIS_IN_POLYGON: Determining if a Point is in a Complex Polygon
    GIS_LINE: Building a JSON Line
    GIS_POINT: Building a Geometry Point
    GIS_SERVICE_AREA: Calculating a Geometry Area Around a Given Point
    GIS_SERV_AREA_XY: Calculating a Service Area Around a Given Coordinate
  Legal and Third-Party Notices
  Simplified Analytic Functions
    FORECAST_MOVAVE: Using a Simple Moving Average
    FORECAST_EXPAVE: Using Single Exponential Smoothing
    FORECAST_DOUBLEXP: Using Double Exponential Smoothing
    FORECAST_SEASONAL: Using Triple Exponential Smoothing
    FORECAST_LINEAR: Using a Linear Regression Equation
    PARTITION_AGGR: Creating Rolling Calculations
    PARTITION_REF: Using Prior or Subsequent Field Values in Calculations
  Simplified Character Functions
    CHAR_LENGTH: Returning the Length in Characters of a String
    LAST_NONBLANK: Retrieving the Last Field Value That is Neither Blank nor Missing
    LOWER: Returning a String With All Letters Lowercase
    LTRIM: Removing Blanks From the Left End of a String
    PATTERNS: Returning a Pattern That Represents the Structure of the Input String
    POSITION: Returning the First Position of a Substring in a Source String
    RTRIM: Removing Blanks From the Right End of a String
    SUBSTRING: Extracting a Substring From a Source String
    TOKEN: Extracting a Token From a String
    TRIM_: Removing a Leading Character, Trailing Character, or Both From a String
    UPPER: Returning a String With All Letters Uppercase
  Character Functions
    ARGLEN: Measuring the Length of a String
    CHKFMT: Checking the Format of a String
    CHKNUM: Checking a String for Numeric Format
    CTRAN: Translating One Character to Another
    CTRFLD: Centering a Character String
    EDIT: Extracting or Adding Characters
    GETTOK: Extracting a Substring (Token)
    LCWORD: Converting a String to Mixed-Case
    LCWORD2: Converting a String to Mixed-Case
    LCWORD3: Converting a String to Mixed-Case
    LENV: Returning the Length of an Alphanumeric Field
    LJUST: Left-Justifying a String
    LOCASE: Converting Text to Lowercase
    OVRLAY: Overlaying a Character String
    PARAG: Dividing Text Into Smaller Lines
    POSIT: Finding the Beginning of a Substring
    RJUST: Right-Justifying a Character String
    SQUEEZ: Reducing Multiple Spaces to a Single Space
    STRREP: Replacing Character Strings
    SUBSTV: Extracting a Variable Length Substring
    TRIMV: Removing Characters From a String
    UPCASE: Converting Text to Uppercase
  Character Functions for DBCS Code Pages
    DCTRAN: Translating A Single-Byte or Double-Byte Character to Another
    DEDIT: Extracting or Adding Characters
    DSTRIP: Removing a Single-Byte or Double-Byte Character From a String
    DSUBSTR: Extracting a Substring
    JPTRANS: Converting Japanese Specific Characters
    KKFCUT: Truncating a String
    SFTDEL: Deleting the Shift Code From DBCS Data
    SFTINS: Inserting the Shift Code Into DBCS Data
  Legacy Character Functions
    STRIP: Removing a Character From a String
    SUBSTR: Extracting a Substring
    TRIM: Removing Leading and Trailing Occurrences
  Special Character Functions
    PATTERN: Generating a Pattern From a String
    SOUNDEX: Comparing Character Strings Phonetically
    SPELLNM: Spelling Out a Dollar Amount
    XMLDECOD: Decoding XML-Encoded Characters
    XMLENCOD: XML-Encoding Characters
  Data Source and Decoding Functions
    CHECKSUM: Computing a Hash Sum
    CHECKMD5: Computing an MD5 Hash Check Value
    DB_EXPR: Inserting an SQL Expression Into a Request
    DB_INFILE: Testing Values Against a File or an SQL Subquery
    DB_LOOKUP: Retrieving Data Source Values
    DECODE: Decoding Values
    LAST: Retrieving the Preceding Value
  Simplified Date and Date-Time Functions
    DT_CURRENT_DATE: Returning the Current Date
    DT_CURRENT_DATETIME: Returning the Current Date and Time
    DT_CURRENT_TIME: Returning the Current Time
    DTADD: Incrementing a Date or Date-Time Component
    DTDIFF: Returning the Number of Component Boundaries Between Date or Date-Time Values
    DTIME: Extracting Time Components From a Date-Time Value
    DTPART: Returning a Date or Date-Time Component in Integer Format
    DTRUNC: Returning the Start of a Date Period for a Given Date
   Legacy Date Functions
    AYM: Adding or Subtracting Months
    AYMD: Adding or Subtracting Days
    CHGDAT: Changing How a Date String Displays
    DA Functions: Converting a Legacy Date to an Integer
    DMY, MDY, YMD: Calculating the Difference Between Two Dates
    DOWK and DOWKL: Finding the Day of the Week
    DT Functions: Converting an Integer to a Date
    GREGDT: Converting From Julian to Gregorian Format
    JULDAT: Converting From Gregorian to Julian Format
    TODAY: Returning the Current Date
    YM: Calculating Elapsed Months
  Standard Date Functions
    DATEADD: Adding or Subtracting a Date Unit to or From a Date
    DATECVT: Converting the Format of a Date
    DATEDIF: Finding the Difference Between Two Dates
    DATEMOV: Moving a Date to a Significant Point
    DATETRAN: Formatting Dates in International Formats
    DPART: Extracting a Component From a Date
    FIQTR: Obtaining the Financial Quarter
    FIYR: Obtaining the Financial Year
    FIYYQ: Converting a Calendar Date to a Financial Date
  Date-Time Functions
    HADD: Incrementing a Date-Time Value
    HDATE: Converting the Date Portion of a Date-Time Value to a Date Format
    HDIFF: Finding the Number of Units Between Two Date-Time Values
    HDTTM: Converting a Date Value to a Date-Time Value
    HEXTR: Extracting Components of a Date-Time Value and Setting Remaining Components to Zero
    HGETC: Storing the Current Local Date and Time in a Date-Time Field
    HGETZ: Storing the Current Coordinated Universal Time in a Date-Time Field
    HHMMSS: Retrieving the Current Time
    HHMS: Converting a Date-Time Value to a Time Value
    HINPUT: Converting an Alphanumeric String to a Date-Time Value
    HMASK: Extracting Date-Time Components and Preserving Remaining Components
    HMIDNT: Setting the Time Portion of a Date-Time Value to Midnight
    HNAME: Retrieving a Date-Time Component in Alphanumeric Format
    HPART: Retrieving a Date-Time Component as a Numeric Value
    HSETPT: Inserting a Component Into a Date-Time Value
    HTIME: Converting the Time Portion of a Date-Time Value to a Number
    HTMTOTS or TIMETOTS: Converting a Time to a Timestamp
    HYYWD: Returning the Year and Week Number From a Date-Time Value
  Simplified Conversion Functions
    CHAR: Returning a Character Based on a Numeric Code
    CTRLCHAR: Returning a Non-Printable Control Character
    EDIT2: Converting a Numeric, Date, or Date-Time Value to a Character String
    HEXTYPE: Returning the Hexadecimal View of an Input Value
    TO_INTEGER: Converting a Character String to an Integer Value
    TO_NUMBER: Converting a Character String to a Numeric Value
  Format Conversion Functions
    EDIT: Converting the Format of a Field
    FPRINT: Converting Fields to Alphanumeric Format
    ITONUM: Converting a Large Binary Integer to Double-Precision Format
    ITOPACK: Converting a Large Binary Integer to Packed-Decimal Format
    ITOZ: Converting a Number to Zoned Format
    PTOA: Converting a Packed-Decimal Number to Alphanumeric Format
    TSTOPACK: Converting an MSSQL or Sybase Timestamp Column to Packed Decimal
  Legacy Functions
    ATODBL: Converting an Alphanumeric String to Double-Precision Format
    BAR: Producing a Bar Chart
    BYTVAL: Translating a Character to Decimal
    BITVAL: Evaluating a Bit String as an Integer
    BITSON: Determining If a Bit Is On or Off
    CHKPCK: Validating a Packed Field
    FIND: Verifying the Existence of a Value in a Data Source
    FTOA: Converting a Number to Alphanumeric Format
    HCNVRT: Converting a Date-Time Value to Alphanumeric Format
    HEXBYT: Converting a Decimal Integer to a Character
    LOOKUP: Retrieving a Value From a Cross-referenced Data Source
    PCKOUT: Writing a Packed Number of Variable Length
    REVERSE: Reversing the Characters in a String
    UFMT: Converting an Alphanumeric String to Hexadecimal
    XTPACK: Writing a Packed Number With Up to 31 Significant Digits to an Output File
  Simplified Numeric Functions
    CEILING: Returning the Smallest Integer Value Greater Than or Equal to a Value
    EXPONENT: Raising e to a Power
    FLOOR: Returning the Largest Integer Less Than or Equal to a Value
    MOD: Calculating the Remainder From a Division
    POWER: Raising a Value to a Power
  Numeric Functions
    ABS: Calculating Absolute Value
    DMOD, FMOD, and IMOD: Calculating the Remainder From a Division
    EXP: Raising e to the Nth Power
    EXPN: Evaluating a Number in Scientific Notation
    INT: Finding the Greatest Integer
    LOG: Calculating the Natural Logarithm
    MAX and MIN: Finding the Maximum or Minimum Value
    MIRR: Calculating the Modified Internal Return Rate
    NORMSDST and NORMSINV: Calculating Normal Distributions
    PRDNOR and PRDUNI: Generating Reproducible Random Numbers
    RDNORM and RDUNIF: Generating Random Numbers
    SQRT: Calculating the Square Root
    XIRR: Calculating the Modified Internal Return Rate (Periodic or Non-Periodic)
  Simplified Statistical Functions
    Specify the Partition Size for Simplified Statistical Functions
    CORRELATION: Calculating the Degree of Correlation Between Two Sets of Data
    KMEANS_CLUSTER: Partitioning Observations Into Clusters Based on the Nearest Mean Value
    MULTIREGRESS: Creating a Multivariate Linear Regression Column
    RSERVE: Running an R Script
    STDDEV: Calculating the Standard Deviation for a Set of Data Values
  Simplified System Functions
    EDAPRINT: Inserting a Custom Message in the EDAPRINT Log File
    ENCRYPT: Encrypting a Password
    GETENV: Retrieving the Value of an Environment Variable
    PUTENV: Assigning a Value to an Environment Variable
  System Functions
    CLSDDREC: Closing All Files Opened by the PUTDDREC Function
    FEXERR: Retrieving an Error Message
    FGETENV: Retrieving the Value of an Environment Variable
    FPUTENV: Assigning a Value to an Environment Variable
    GETCOOKI: Retrieving a Browser Cookie Value
    GETHEADR: Retrieving an HTTP Header Variable
    GETUSER: Retrieving a User ID
    GRPLIST: Retrieving the Group List of the Connected User
    PUTCOOKI: Submitting a Value to a Browser Cookie
    PUTDDREC: Writing a Character String as a Record in a Sequential File
    SLEEP: Suspending Execution for a Given Number of Seconds
  Simplified Geography Functions
    Sample Geography Files
    GIS_DISTANCE: Calculating the Distance Between Geometry Points
    GIS_DRIVE_ROUTE: Calculating the Driving Directions Between Geometry Points
    GIS_GEOCODE_ADDR: Geocoding a Complete Address
    GIS_GEOCODE_ADDR_CITY: Geocoding an Address Line, City, and State
    GIS_GEOCODE_ADDR_POSTAL: Geocoding an Address Line and Postal Code
    GIS_GEOMETRY: Building a JSON Geometry Object
    GIS_IN_POLYGON: Determining if a Point is in a Complex Polygon
    GIS_LINE: Building a JSON Line
    GIS_POINT: Building a Geometry Point
    GIS_SERVICE_AREA: Calculating a Geometry Area Around a Given Point
    GIS_SERV_AREA_XY: Calculating a Service Area Around a Given Coordinate
  Legal and Third-Party Notices
ibi™ WebFOCUS® Online Help
  Welcome to ibi™ WebFOCUS®
    Signing in to ibi WebFOCUS
    Navigating the ibi WebFOCUS® Hub
      Banner
      Home Area
      Workspaces Area
      Application Directories Area
      Portals Area
      Management Center Area
      Search Content & Data Area
      Viewing the Hub on Mobile Devices
    Configuring and Using Your ibi WebFOCUS Environment
      Creating New Workspaces and Folders
      Dragging and Dropping Folders and Files
      Adding Content to Favorites
      Adding Thumbnails to Content Items
      Assigning Tags to Content Items
      Creating Shortcuts
      Creating URLs
      Creating Blogs
      Uploading Files
      Sharing Content in ibi WebFOCUS
      Customizing the Getting Started View
      Using Keyboard Shortcuts
    Editing Source Code Files
      Accessing the Editor
      Navigating the Editor Interface
      Using the Editor Toolbar
      Syntax Highlighting
      Saving Files
      Previewing Output
      Preferences for Managing Code
      Using Search and Replace
      Working With the Editor Canvas
    Introducing the ibi™ WebFOCUS® Mobile App
      Configuring ibi WebFOCUS Mobile App
      Navigating the ibi WebFOCUS Home Page on a Mobile App
      Using ibi WebFOCUS Mobile App to View In-Document Analytics Reports
  Accessing Data
    Preparing Spreadsheets for Upload
    Uploading Data Files
    Pivoting Data
    Connecting to Data Files
    Joining Data
    Creating HOLD Files
    Editing Metadata
    Preparing and Managing Data
    Extending Metadata With Reporting Objects
    Running Predictive Analytics on Your Data
    Running Predictive Analytics on Your Data in WebFOCUS Designer
    Running Datasets Against Saved Models
    Using NLQ On Your Data
    Using NLQ On Your Data in WebFOCUS Designer
  Visualizing Data
    Navigating the ibi WebFOCUS Designer Interface
      Navigating ibi WebFOCUS Designer With Keyboard Controls
    Creating Content in ibi WebFOCUS Designer
    Selecting a Data Source
    Configuring Sample Data Settings
    Creating Charts
      Displaying Measure Values in Charts
      Sorting Legends in a Chart
      Formatting Charts
      Creating Maps to Illustrate Trends
      Using Your Extension in an ibi WebFOCUS Request
      Configuring the Automatic Refresh Option for Charts
      Using Insight to Analyze Dynamic Charts
    Creating Reports
      Displaying Measure Values in Reports
      Adding Column and Row Totals to a Report
      Using Breaks and Subtotals in a Report
      Sorting Data in a Report
      Styling Reports in ibi WebFOCUS Designer
      Converting Reports to Excel Tables
    Creating and Customizing Documents
      Accessing and Navigating Document Mode
      Composing a Document
    Adding Filters to a Visualization
    Adding Headers and Footers to Content
    Setting Conditional Styling Based on Data Values
    Changing a Field Format
    Creating Calculations
    Using Prefix Operator Aggregation Functions
    Using Quick Transforms to Apply Analytical Functions to Data Fields
    Using Dynamic Grouping for Dimension Field Values
    Creating Numeric Ranges With Binning
    Enabling Field Selection at Run Time With Field List Parameters
    Enabling Hierarchical Drilling in ibi WebFOCUS Designer With Auto Drill
    Enabling Drill Anywhere to Analyze Field Relationships
    Enabling Automatic Content Linking in ibi WebFOCUS Designer With Auto Linking
    Adding Drill-Down Links to Content
    Changing Output Formats in a Chart or Report
      Overview of In-Document Analytics
    Generating a Data Extract or Image From Content
    Previewing Content
    Generating Insights in ibi WebFOCUS Designer
    Generating Insights in the ibi WebFOCUS Hub
  Organizing Content Into Pages
    Creating Pages
    Styling Pages
      Customizing Assembled Page Defaults
      Applying Custom CSS and JavaScript Code to a Page
    Adding Panels to a Responsive Container
    Linking to External Content From a Page
    Enabling Container Customization
    Providing Access to Content Items and ibi WebFOCUS Tools
    Working With Interactions
    Creating Custom Templates
    Passing Parameter Values to a Page
    Bookmarking Control Selections in a Page
    Exporting a Page as a PDF or Image
  Building Portal Applications
    Creating Portals
    Defining a Portal Structure
    Running Portals
    Targeting a Page to Open When Running a Portal
    Launching a Portal with Parameters
     Enabling and Sharing Personal Pages
    Customizing Portals
    Applying Themes to Portals
     Adding Icons to Portal Levels
    Customising User Menu Options
    Using a JavaScript Function to Navigate to a Designer Portal Page
    Configuring Dynamically Customized Designer Portals for Multiple SaaS Tenant Groups
    Configuring Dynamically Customized Collaborative Portals for Multiple SaaS Tenant Groups
  Scheduling and Distributing Content
    Creating Event-based Schedules
      Alert Reporting
      Components of an Alert
      Creating and Scheduling an Alert
      Checking Scheduled Alerts
  Legal and Third-Party Notices
  Welcome to ibi™ WebFOCUS®
    Signing in to ibi WebFOCUS
    Navigating the ibi WebFOCUS® Hub
      Banner
      Home Area
      Workspaces Area
      Application Directories Area
      Portals Area
      Management Center Area
      Search Content & Data Area
      Viewing the Hub on Mobile Devices
    Configuring and Using Your ibi WebFOCUS Environment
      Creating New Workspaces and Folders
      Dragging and Dropping Folders and Files
      Adding Content to Favorites
      Adding Thumbnails to Content Items
      Assigning Tags to Content Items
      Creating Shortcuts
      Creating URLs
      Creating Blogs
      Uploading Files
      Sharing Content in ibi WebFOCUS
      Customizing the Getting Started View
      Using Keyboard Shortcuts
    Editing Source Code Files
      Accessing the Editor
      Navigating the Editor Interface
      Using the Editor Toolbar
      Syntax Highlighting
      Saving Files
      Previewing Output
      Preferences for Managing Code
      Using Search and Replace
      Working With the Editor Canvas
    Introducing the ibi™ WebFOCUS® Mobile App
      Configuring ibi WebFOCUS Mobile App
      Navigating the ibi WebFOCUS Home Page on a Mobile App
      Using ibi WebFOCUS Mobile App to View In-Document Analytics Reports
  Accessing Data
    Preparing Spreadsheets for Upload
    Uploading Data Files
    Pivoting Data
    Connecting to Data Files
    Joining Data
    Creating HOLD Files
    Editing Metadata
    Preparing and Managing Data
    Extending Metadata With Reporting Objects
    Running Predictive Analytics on Your Data
    Running Predictive Analytics on Your Data in WebFOCUS Designer
    Running Datasets Against Saved Models
    Using NLQ On Your Data
    Using NLQ On Your Data in WebFOCUS Designer
  Visualizing Data
    Navigating the ibi WebFOCUS Designer Interface
      Navigating ibi WebFOCUS Designer With Keyboard Controls
    Creating Content in ibi WebFOCUS Designer
    Selecting a Data Source
    Configuring Sample Data Settings
    Creating Charts
      Displaying Measure Values in Charts
      Sorting Legends in a Chart
      Formatting Charts
      Creating Maps to Illustrate Trends
      Using Your Extension in an ibi WebFOCUS Request
      Configuring the Automatic Refresh Option for Charts
      Using Insight to Analyze Dynamic Charts
    Creating Reports
      Displaying Measure Values in Reports
      Adding Column and Row Totals to a Report
      Using Breaks and Subtotals in a Report
      Sorting Data in a Report
      Styling Reports in ibi WebFOCUS Designer
      Converting Reports to Excel Tables
    Creating and Customizing Documents
      Accessing and Navigating Document Mode
      Composing a Document
    Adding Filters to a Visualization
    Adding Headers and Footers to Content
    Setting Conditional Styling Based on Data Values
    Changing a Field Format
    Creating Calculations
    Using Prefix Operator Aggregation Functions
    Using Quick Transforms to Apply Analytical Functions to Data Fields
    Using Dynamic Grouping for Dimension Field Values
    Creating Numeric Ranges With Binning
    Enabling Field Selection at Run Time With Field List Parameters
    Enabling Hierarchical Drilling in ibi WebFOCUS Designer With Auto Drill
    Enabling Drill Anywhere to Analyze Field Relationships
    Enabling Automatic Content Linking in ibi WebFOCUS Designer With Auto Linking
    Adding Drill-Down Links to Content
    Changing Output Formats in a Chart or Report
      Overview of In-Document Analytics
    Generating a Data Extract or Image From Content
    Previewing Content
    Generating Insights in ibi WebFOCUS Designer
    Generating Insights in the ibi WebFOCUS Hub
  Organizing Content Into Pages
    Creating Pages
    Styling Pages
      Customizing Assembled Page Defaults
      Applying Custom CSS and JavaScript Code to a Page
    Adding Panels to a Responsive Container
    Linking to External Content From a Page
    Enabling Container Customization
    Providing Access to Content Items and ibi WebFOCUS Tools
    Working With Interactions
    Creating Custom Templates
    Passing Parameter Values to a Page
    Bookmarking Control Selections in a Page
    Exporting a Page as a PDF or Image
  Building Portal Applications
    Creating Portals
    Defining a Portal Structure
    Running Portals
    Targeting a Page to Open When Running a Portal
    Launching a Portal with Parameters
     Enabling and Sharing Personal Pages
    Customizing Portals
    Applying Themes to Portals
     Adding Icons to Portal Levels
    Customising User Menu Options
    Using a JavaScript Function to Navigate to a Designer Portal Page
    Configuring Dynamically Customized Designer Portals for Multiple SaaS Tenant Groups
    Configuring Dynamically Customized Collaborative Portals for Multiple SaaS Tenant Groups
  Scheduling and Distributing Content
    Creating Event-based Schedules
      Alert Reporting
      Components of an Alert
      Creating and Scheduling an Alert
      Checking Scheduled Alerts
  Legal and Third-Party Notices
WebFOCUS Help
  WebFOCUS Online Help
  Application Settings
  Client Settings
  ReportCaster Settings
  Startup Parameters
  Realm Driver Parameters
  Functions
  WebFOCUS Online Help
  Application Settings
  Client Settings
  ReportCaster Settings
  Startup Parameters
  Realm Driver Parameters
  Functions