Skip Headers
Oracle® Enterprise Data Quality for Product Data Knowledge Studio Reference Guide
Release 5.6.2
Part Number E23610-03
Home
Book List
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Overview
Starting the Software
Understanding the Client Workspace
Frame Functionality
Menu Commands and the Toolbar
File Menu
Edit Menu
View Menu
Data Lens Menu
Tools Menu
Help Menu
Keyboard Shortcuts
Tabs
and Sub-Tabs
Task Panes
Context-Sensitive Menus
Starting the Knowledge Studio
Creating or Opening a Data Lens
2
Phrases in Data
Phrases Tab
Define Phrases Sub-Tab
Phrases and Terms Pane
Sample Data Table pane
Item Definition Field
Graphical Rule Builder Pane
Selected Line Field
Using These Tools
Creating Terminology Rules for Unknown Items
Creating Phrase Structure for Terminology Nodes
Combining Two Phrase Rules into One Phrase Rule
Merging Two Phrase Rules
Renaming Phrase Rules
Editing Phrase Rules
Adding Variant Forms of Terminology
Modifying Phrase Productions
Using Rule Predictions
Resolving Phrase Ambiguity
Editing the Term Full Form
Define Items Sub-Tab
Item Definitions Pane
Sample Data Table Pane
Item Definition Field and Selected Line Field
Graphical Rule Builder Pane
Using these Tools
Creating a New Top-Level Item Definition
Creating a Sub-Item Definition
Aliases
Active vs. Inactive Item Definitions
Item Definition List Pane
Using these Tools
Defining Item Definition Attributes
View Hierarchy Sub-Tab
Top Down and Bottom Up Grammar Hierarchy Panes
Regression Testing Sub-Tab
Ensuring Regression Testing is Active
Before Pane
After Pane
Review Column
Creating and Updating the Regression Base
3
Standardize Data
Standardize Tab
Standardize Terms Sub-Tab
Terminology Rules Pane
Rewrite Rules Pane
Copy Full Form Button
Default Case Section
Standardize Phrases Sub-Tab
Nodes to Receive Rules Pane
Sort Productions
Nodes for Insertion Pane
Ordering Rule Pane
Join Terms
Delete or Reorder Terms
Standardize Lines Sub-Tab
Unit Conversion
Sub-Tab
Nodes to Receive Rules Pane
Instructions Pane
Unit Conversion Table Construction Wizard Pane
Test Global Standardization Sub-Tab
Sample Data Table
Sub-Tab Data Fields
Regression
Test Sub-Tab
Before Pane
After Pane
Review Column
Creating and Updating the Regression Base
Standardization Types
Creating a Standardization Type
Deleting Standardization Types
4
Standardizing Item Definitions
Standardize Items Tab
Standardize Attributes Sub-Tab
Item Definitions Pane
Rewrite Rules Pane
Numeric Rewrite Rules
Value Replace Table
Simple Rewrite Rules
Automatic Rewrite Rules
Reorder Phrase Productions
Order Attributes Sub-Tab
Item Definition Pane
Selection Pane
Null Handling
Multiple Instance Handling
Match Weights Sub-Tab
Item Definition Pane
Selection Pane
Duplicate Matching
Test Attributes
Sub-Tab
Item Definition Section
Sample Data Table
Source Field
Standardized Text Section
Standardized Attributes Table
Test Item Standardization
Sub-Tab
Sample Data Table
Source Field
Standardized Text Section
Item Attributes Section
Regression
Test Sub-Tab
Sample Data Table
Current and Regression Attributes Sections
Creating and Updating the Regression Base
Match Type
5
Classify Data
Classification
Schemas
UNSPSC
eCl@ss
User-Defined
Classification Type
Creating a Classification Type
Deleting Classification Types
Classify Tab
Classify from Data Sub-Tab
Classification Type Pane
Sample Data Pane
Item Definition Section
Graphical Rule Pane
Classify from Item Definitions
Sub-Tab
Classify from Rules Sub-Tab
Test Classification
Sub-Tab
Sample Data Pane
Source Field
Standardized Text Field
Classification Pane
Testing Multi-Classification
Regression
Test Sub-Tab
Creating and Updating the Regression Base
6
Translating Data
Translation Process
Data Lens Standardizations
Quality
Prepare Data for Translation
Translation Target
Translation Smart Glossary
Create/Update Oracle DataLens Server Translation Smart Glossary
Translation
Tab
New Phrases and Known Phrases Sub-Tabs
Translation Pane
Red Check Mark
Export
Export Text for Translation
Import Text for Translation
Source and Translated Text Fields
New and Known Variable Term Phrases Sub-Tabs
Reorder Sub-Tab
Test Translation Sub-Tabs
Test Translated Attributes Sub-Tab
Item Definition Section
Sample Data Table
Source Field
Translated Text Section
Standardized Attributes Table
Test Item Translation Sub-Tab
Sample Data Table
Source Field
Item Definition Field
Test Global Translation Sub-Tab
Sample Data Table
Source Field
Translated Field
Quality Metrics
Regression Test Sub-Tab
Before Pane
After Pane
Review Column
Creating and Updating the Regression Base
Translation Repair Formats
7
Generating Reports
Function Specific Reports
Classification Reports
Standardization Report
Grammar Reports
Complexity Reports
Semantic Reports
8
Managing Data Lenses and Files
Data Lens
Management
Setting Data Lens Options
Checking In a Data Lens
Checking Out a Data Lens
Deleting Data Lenses
Deleting Read-only Data Lenses
Viewing Tasks
Changing the Task Status
Creating a Task
Data Lens
Information
Editing a Data Lens Description
Editing Data Lens History Notes
Sample Files
Creating New Sample Data
Deleting Sample Files
Renaming Sample Files
Combining Sample Files
9
Export and Import Features
Exporting a Data Lens
Importing a Data Lens
Exporting Rules
Importing Phrases and Terms
Creating Aliases When Importing Rules and Phrases Using Excel
Exporting and Importing Item Definitions
Troubleshooting Item Definition Export and Import
Pre-existing Item Definitions with Same Name as Import
Source Item Definition Relies on Knowledge Contained in an Smart Glossary
Source Item Definition Relies on Standardization Information
Source Item Definition Relies on Unit Conversion Information
Source Item Definition Relies on Value Logic Information
10
Defining Context and Item Definitions Further
Editing Attributes
Generating Term Variants
Phrase and Terminology Rule Syntax
Terminology Rules
Case Sensitivity in Terminology Rules
Regular expressions in Terminology Rules
White Space, Regular Expressions, and Terminology Rules
Phrase Structure Rules
Start Symbols in Phrase Structure Rules
Other Constraints on Rules
Global Phrase Rule Renaming
Source Format
Applying Source Formatting
Compacting Grammar
11
Standardizing Data Further
Term
Standardization
Case Replacement
Regular Expression Replacement
Individual Replacement
Multiple Standardization Types
Unit of Measure Standardization Types
Creating a Unit Conversion Type
Deleting Unit Conversion Types
Creating a Unit Conversion for a Phrase
Share Standardizations Within a Data Lens
Copying Global Standardizations
Sharing Item Definitions Standardizations
Copying Item Definitions Between Standardization Types
Copying Between Item Definitions
12
Classifying Data Further
Advanced Classification Rule Functions
Addition
Masking
Negation
Parent
Function Example
Add Mask
Add Negation
Add a Parent
Multiple Classification Schemas
Classification Type
Upgrade
User Defined Classification Types
Creating a User-Defined Schema Using Excel
Creating a User-Defined Schema Using a Text Editor
Creating a User-Defined Classification Type
Global Classification Schemas
Classification System Support
Data Lens Classification System File Format
13
Smart Glossaries
Import
ing a Smart Glossary
Creating a Smart Glossary
Included
Smart Glossaries
Colors
Counts
Packaging for
Sale
Units of Measure
Units of Measure Retail
A
Installing the Client Software
B
Regular Expressions
Special Characters in Regular Expressions
Useful Regular Expressions in Terminology Rules