Table of Contents
- Title and Copyright Information
- Send Us Your Comments
- Preface
- 1 Introduction
- 2 Configuration Components Pane
-
3
Projects
- Working with Projects
- Understanding Hierarchies
- Configuration of Attribute Hierarchy Information
- Configuration of Virtual Hierarchy Information
- The Hierarchy Definition Window
- Working with Hierarchies
- Working with Dimensions
- Data Interface Manager
- Working with Styles
- Working with Taskflows
-
4
Solutions
- Working with Solutions
-
Measures and Components
- Measure Manager
- Measure Component Design
- Create a Major Component
- Create a Minor Component
-
Defining Measure
Component Properties
-
Measure Component Properties
- Name
- Label
- Description
- Type
- NA Value
- Base Intx
- Multi-Level Display
- Default Agg
- Agg Spec
- Default Spread
- Base State
- Agg State
- Database
- View Type
- Sync With
- Insertable
- Non-Translatable
- UI Type
- Range
- Purge Age
- Lower Bound and Upper Bound
- Sp Value Type and Sp Value
- Dim Attr Type
- Dim Attr Name (optional field)
- Dim Attr Label (optional field)
- Allowed Aggs
- Style
- Single Hier Select
- Filename (read only)
- Load Intx (read only)
- Clear Intx (read only)
- Start (read only)
- Width (read only)
- Load Agg (read only)
- Materialized (read only)
- Creator (read only)
- Signature (read only)
- Shared Fact Name (read only)
- Shared Fact Base Intx (read only)
- Report Category
- Source Fact (Read Only)
- Customer Managed
-
Measure Component Properties
- Edit Components
- Measure Validation within the Measure Manager
- Working with Measures
- External Measures
- Rule Sets
-
Rule Groups
- Create a Rule Group
- Delete a Rule Group
- Copy a Rule Group
- Edit Rule Group Properties
- Measure Validation in the Rule Definition Window
- Rule Definition
- Create a Rule and Add It to a Rule Group
- Add an Existing Rule to a Rule Group
- Apply a Rule Pattern to Create New Rules or to Update Existing Rules
- Delete a Rule from All Rule Groups
- Remove a Rule from a Rule Group
- Edit Properties of a Rule
- Rename All Rules in a Rule Group
- Filter Rules in a Rule Group
- Reordering Rules in a Rule Group
- Auto Generate Load and Commit Rules
- Copy Selected Rules to Another Rule Group
- Find and Replace Measures in the Copied Rules
- Expressions and Rules
- Named Rule Pattern
- RPASCE Functions, Procedures, Keywords, and Modifiers
-
Workbooks
- Workbook Components
- Participation Measures Overview
- Create a Workbook
- Patch Workbook with New Attributes
- Edit Workbook Properties
-
Defining Workbook Properties
-
General Tab
- RPAS Name
- User Label
- Group
- Group Label
- Workbook Type
- Library
- Wizard Only
- Rule Set
- Use Default Rules
- Load Rules, Commit Rules, and Calc Rules
- Refresh Rules
- X Axis, Y Axis, Z Axis and Unassigned
- Use Custom Wizard
- Custom Wizard
- Standard Wizard
- Enable Image Modification
- Hierarchy Pre-Ranging
- DPM Like-Item Measure
- Dim Attr Setup Date Measures
- Use Rolling Calendar
- Rolling Calendar Range Measures
- Login User Only
- Dynamic Dimension Label Override Measures
- Sync DPM Positions to Virtual Dimension
- Custom Menus Tab
- Workbook Hierarchies Tab
- Real Time Alerts Tab
- Workbook Transitions Tab
-
Measures Tab
- Defining Measure Properties Override Settings for a Workbook
- Modifying Measure Properties Override Settings for a Workbook
- Removing a Measure Override Settings from a Workbook
- Defining the LoadRange and LoadRangeMeas Properties
- Defining a Measure with a Dynamic Picklist
- Make a Measure Editable during Elapsed Period
- Extended Measures Tab
- Dynamic Position Maintenance Tab
-
General Tab
- Working with the Rule Group Simulator
- Working with Workbook Tabs
-
Working with Worksheets
- Create a Worksheet
- Defining Worksheet Properties for Pivot/Chart Worksheets
- Defining Worksheet Properties for Worksheets Tiled View
- Defining Worksheet Properties for the Worksheets Container View
-
Defining Worksheet Properties for Worksheets Card View
-
Card View Worksheet
- Features of the Card View Worksheet
- Card Types and Card Definitions
- Add/Remove and Drag/Drop Behavior
- Define the Axis Layout of the Worksheet
- Support for Images, Attributes, and Measures
- Support for Measure Profiles
- Window Formatting
- Properties of the Card View Worksheet
- Additional Tabs of the Card View Worksheet
-
Card View Worksheet
-
Defining Worksheet Properties for the Worksheets Summary View
- Summary View Worksheet
-
Properties of the Summary View Worksheet
- RPAS Name
- User Label
- Worksheet Type
- Total Quantity Measure
- Total Quantity Label
- Total Gauge Measure
- Total Gauge Label
- Percent Label
- Quantity Label
- Units Label
- Currency Label
- Metric 1 Units Measure
- Metric 1 Currency Measure
- Metric 1 Percent Measure
- Metric 1 Label
- Metric 2 Units Measure
- Metric 2 Currency Measure
- Metric 2 Percent Measure
- Metric 2 Label
- Metric 3 Units Measure
- Metric 3 Currency Measure
- Metric 3 Percent Measure
- Metric 3 Label
- Metric 4 Units Measure
- Metric 4 Currency Measure
- Metric 4 Percent Measure
- Metric 4 Label
- Units Chart Type
- Currency Chart Type
- Percent Chart Type
- Card Hierarchy
- Base Intersection
- Additional Tabs of the Summary View Worksheet
- Specifying Which Measures Display in a Worksheet
- Specify the Sequence of Measures on a Worksheet
- Edit Worksheet Properties
- Remove a Worksheet
- Wizards
- 5 Accessibility
-
6
Configuring
Dashboards in RPASCE
- Determining the Dashboard Requirements and the Approach
- Creation of a Dashboard Workbook Template
- Creation of the Dashboard View Configuration File
- Configuring Attribute Roll-Up Dynamic Hierarchies
- Configuring the Unit of Measurement Display in Dashboards
- Dashboard Plans
- Dashboard Errors
-
7
Contextual Help
- Overview
-
Contextual Help Configuration File
- Creating the Configuration File
- Using JSON
- Configuration File Levels
- Help Topic Building Blocks
- Help Topic Tile
- Naming Conventions for Keys
- JSON Structure of Contextual Help Configuration File
- Adding or Editing the Contextual Help Configuration File
- Retrieving or Updating the InContext Help JSON File
- 8 System Preferences
- 9 Configuration Utilities
- 10 Integration Tool
-
11
Integration Configuration Generation
- Important Configuration Items for Fact and Grouping
- Fact Grouping Best Practices
- Generate Integration Configuration - Integration Tools
- Generate Integration Configuration - rpasInstall
-
12
Deployment Tool
-
General Process
Flow for Generating Deployment Resources
- User Interface
- Deployment Tool - Distributed Workbook Storage
- Deployment Tool – Global Domain Configuration
- Deployment Tool – Online Administrative Tasks
-
Deployment Tool – Dashboard Settings Resource
- DashboardSettings.json View
- DashboardSettings.json Resource Contents
- Metric Profile Element
- Seasonal Profile Element
- Exception Profile Element
- Dynamic Hierarchy Element
- Metric Tile Element
- Comparison Metric Tile Element
- Metric Tile Variance Element
- Exception Tile Element
- Creating Dashboard Profiles: Two Examples
-
Deployment Tool – Retail Home Dashboard Settings
- How Metric Tiles are Populated in the Retail Home Portal Dashboard Page
- RetailHomeConfig.json View
- RetailHomeConfig.json Option in Deployment Tool
- RetailHomeConfig.json Resource Contents
- Template, Worksheet, and TileStates Definition
- Validation against the Application Configuration
- Retail Home Translation Resources
- Deployment Tool Limitations
-
General Process
Flow for Generating Deployment Resources
- A Appendix – Note on Deprecated Functionality
- B Appendix – RPASCE Cloud Partitioning Guide
- C Appendix – Calculation Engine User Guide
-
D
Appendix – Rules Function Reference Guide
- Syntax and Design
- Special Handling for Functions
- Non-Conforming Measures
- Functional Keywords
- Modifiers
-
Description of Functions
- Calendar Index Functions
- Calendar Calculation Functions
- Index and Position Functions
- Forecast Procedure
- Tensorflow Procedure
- Time Series Functions
- Hierarchical Functions and Procedures
-
Other Functions and Procedures
- multisource
- Left Hand Side (LHS) Measure Properties
- Right Hand Side (RHS) Measure Properties
- cover
- uncover
- min
- max
- sum
- lag
- lead
- timeshift
- round
- roundup
- rounddown
- navalue
- propspread
- passthrough
- rankagg
- ranksort
- positionLocked
- randMask
- loadagg
- spreadcommit
- dynHierRefresh
- preModified
- AggPEClc
- intradayexport
- rmsNewItemExpr
- E Appendix – Aggregation and Spread Types
- F Appendix – RPASCE Configuration Manager and rpasConfigMgr
- G Appendix – Dynamic Hierarchies
- H Appendix – RPASCE Rule Writing Tips