Table of Contents
- Title and Copyright Information
- 1 Preface
- 2 OFSAAI - An Overview
- 3 Accessing OFSAA Applications
- 4 Configuring User Preferences
- 5 Logging in OFSAA
- 6 Data Model Management
-
7
Data Management Framework
- Data Management Tools
- Components of Data Management Tools
- Data Sources
-
Data Mapping
-
Creating Data Mapping
Definition
- Specifying Data Mapping Definition Details
- Selecting Model
- Defining Data Mapping to Table (T2T, F2T, H2T, T2H, H2H, F2H, L2H)
- Defining Data Mapping for File Extraction (T2F, H2F)
- Associating DQ Rules to a Data Mapping Definition
- Replacing Source or Target of Data Mapping Definition during Execution
- Executing H2H on Spark
- Dynamic Table Creation
- Prescripts
- Handling Partitioned Target Tables
- Expression Builder
- Modifying a Data Mapping Definition
- Versioning and Make Latest Feature of Data Mapping
- Copying Data Mapping Definition
- Viewing Data Mapping Definition
- Deleting Data Mapping Definitions
- Purging Data Mapping Definitions
-
Creating Data Mapping
Definition
- Post Load Changes
- User Defined Functions
- DMT Configurations
- Slowly Changing Dimensions (SCD)
- Data Quality Framework
- Configure Dynamic Degree of Parallelism (DOP) in DQ Framework
- References
-
8
Unified Analytical
Metadata
- Alias
- Derived Entity
- Datasets
- Dimension Management
- Measure
- Business Processor
- Expression
- Filter
- Map Maintenance
- Analytics Metadata
- References
-
9
Data Maintenance Interface
- Prerequisites
- Creating Forms Definition
- Approving or Rejecting Forms Definition
-
Data Entry
- Viewing Data Entry
- Data Entry for Forms Created without Auto-Approve Option
- Data Entry for Forms Created using the Auto-Approve Option
- Other Options for Data Entry
-
10
Rule Run Framework
- Components of Rules Run Framework
- Rule
- Process
- Run
- Manage Run Execution
- Utilities
-
References
- How Run Rule Framework is used in LLFP Application
- How Run Rule Framework is used in LRM Application
- Process Hierarchy Members
- Hierarchical Member Selection Modes
- Significance of Pre-Built Flag
-
Seeded Component Parameters in
RRF
- Cube Aggregate Data (CubeAggregateData)
- Create Cube (CubeCreateCube)
- Data Extraction Rules (ExtractT2F)
- Load Data Rules (LoadF2T)
- Load Data Rules (LoadT2T)
- Modeling Framework - Model (MFModel)
- Modeling Framework - Optimizer (MFOptimizer)
- Modeling Framework - Pooling (MFPooling)
- Process
- Base Rules - Classification Rule (RuleType2)
- Base Rules - Computation Rule (RuleType3)
- Run Executable (RunExecutable)
- Stress Testing - Variable Shocks (SSTVariableShock)
- Transformation Rules (TransformDQ)
- Transformation Rules (TransformDT)
- Data Quality Groups (Run DQ)
-
11
Operations
- Batch Maintenance
- Batch Execution
- Batch Scheduler
- Batch Monitor
- Processing Report
- Execution View Log
- Batch Cancellation
- View Log
-
References
-
Task Component Parameters
- Component: AGGREGATE DATA
- Component: CREATE CUBE
- Component: EXTRACT DATA
- Component: LOAD DATA
- Component: MODEL
- Component: PROCESS_EXECUTION
- Component: RULE_EXECUTION
- Component: RUN DQ RULE
- Component: RUN EXECUTABLE
- Component: SQLRULE
- Component: TRANSFORM DATA
- Component: VARIABLE SHOCK
- Component: Workflow Execution
-
Task Component Parameters
-
12
Questionnaire
- Know the Questionnaire Workflow
- Questionnaire Types
- Use Search in the Questionnaire
- Configure the Questionnaire Attributes
- Define the Questions
-
Define the Questionnaires
-
Create the Questionnaire in the
Library
- Create a Section in a Questionnaire
- Link a Question to a Questionnaire
- Configure the Questions in a Section
- Rearrange the Sequence of Sections and Questions
- Delink a Question From a Questionnaire
- Attach URLs to a Questionnaire Section
- View the Workflow History
- Edit a Section in a Questionnaire
- Delete a Section in a Questionnaire
- Wrap and Unwrap Sections in a Questionnaire
- Approve the Questionnaires
- Edit the Questionnaire From the Library
- <Enter Task Title Here>
- Delete the Questionnaire from the Library
- Wrap and Unwrap the Questionnaire from the Library Wrap and Unwrap the Questionnaire from the Library
- Configuring Token-Based RFI
-
Create the Questionnaire in the
Library
-
13
System Configuration and Identity Management
-
System Configuration
- Navigating to System Configuration
- Components of System Configuration
- Database Server
- Application Server
- Web Server
- Database Details
- OLAP Details
- Configure Email Configuration
- Instance Access Token
- Information Domain
- Configuration
- Application
- View OFSAA Product Licenses After Installation of Application Pack
-
Identity Management
- Navigating to Identity Management
- Components of Identity Management
- Mappings in Identity Management
-
User Administrator
- User Maintenance
- Setting up User Attribute Master
- User Group Maintenance
- User - User Group Map
- Profile Maintenance
- Adding Profile
- Mapping Holidays
- Viewing Profile
- Modifying Profile
- Deleting Profile
- User Authorization
- User Group Authorization
- Authorization for User Group Folder Mapping
- User Group Domain Map
- User Group Role Map
- User Group Folder Role Map
- Reinstating Deleted Users
- System Administrator
- References
-
System Configuration
- 14 Reports
-
15
Object Administration
- Access Object Administration and Utilities based on Information Domain
- Object Security Concept in OFSAAI
- OFSAA Seeded Security
- Object Security
- Object Migration
- Translation Tools
- Utilities
- References
-
16
Command Line Utilities
- Command Line Utility to Migrate Objects
- Command Line Utilities to Execute RRF Definitions
- Command Line Utility for DMT Migration
- Command Line Utility for File Encryption
- Command Line Utility to Publish Metadata in Metadata Browser
- Command Line Utility for Object Application Mapping in Metadata Browser
- Command Line Utility for Resaving UAM Hierarchy Objects
- Command Line Utility for Resaving Derived Entities and Essbase Cubes
- Command Line Utility for Mapper Pushdown
- Command Line Utility for Downloading Metadata Objects in PDF Format
- Command Line Utility for LDAP Migration
- Model Upload Utility
- Command Line Utility for Object Registration
- Command Line Utility for Transforming erwin XML to Database XML or JSON(ODM)
- Command Line Utility for Generating Slice JSON (ODM)
- Command-Line Utility for SQL Modeler to JSON (ODM)
- Command Line Utility for Populating AAI_DMM_METADATA Table
- Command-line Utility to Bulk Import User Groups to IDCS
-
17
References
- Calendar
-
External Scheduler Interface
Component
- Architecture
- Scope of Integration
- ESIC Invocation
- Batch Execution Mechanism
- External Scheduler Batch Run ID
- Batch Monitoring
- Advantages of ES
- OFSAAI Standard XML
- Exit Status Specifications
- ESIC Operations using Wrapper Scripts
- ESIC Operations Using Command Line Parameters and Job Types
- Additional Information on ESIC
- File Upload Requirements
- File Upload Requirements
- 18 Preferences
- A Appendix A