Change Summary
Overview of QAD Data Warehouse Designer
Data Flow - Dimensional models
Data Flow - Normalized models
Data Flow - Data Store models
Data Flow - Enterprise models
Data Flow
Procedural code
Scheduler
Documentation
QADData Warehouse Designer and Traditional ETL Tools
How to use this Guide
QAD Data Warehouse Designer Installation and Administration Guide
QAD Data Warehouse Designer User Guide
QAD Data Warehouse Designer Tutorials
Sql Admin User Guide
QAD Forum
Design Introduction
Design Introduction
Design Approach
Objects and Windows
Object Types
Organizing Objects
Object Groups
Projects
Include in User Documentation
Include in Tech Documentation
Local Project
Project Groups
Windows and Panes
Toolbar
Toolbar
Toolbar
Toolbar
Database Error Messages
Tutorials
Default Settings
Settings - Options
Repository Name
Repository Type
Data Warehouse Schema
Enable
Name
Position
EUL Setting
Color
General
Procedure name defaults
Dss_source_system
Dss_fact_table
Table
Columns
General
Retention Period
General
SQL Server Integration Services
Include Statistics in Generated Stage Update Procedure
Stage Table Inserted Rows Threshold for Statistics
Include Statistics in Generated Dimension Update Procedure
Dimension Table Inserted Rows Threshold for Statistics
Include Statistics in Generated Fact Update Procedure
Fact Table Inserted Rows Threshold for Statistics
Include Statistics during Partition Exchange
Filegroup
Foreign Key Index Type
Metadata Versioning
Diagrams
Settings - User Preferences
Prompt to Regenerate Indexes when Rebuild Procedures
Show Dimension Views as a Separate Object Type
Trace Unix Sessions
General
General
Documentation
Backup Executable
Restore Executable
Version to Disk
Color Schemes
Settings - Language Options
Language
Language Description
Analysis Services Language
Parameters
Global Parameters
Connections
Connection types
Browsing a Connection
Browser Icons
Browsing a connection
Changing a Connection's Properties
Creating a Database Link
SQL Server Connections
Data Warehouse check box
Connection Name
Connection Type
ODBC Source
Provider Name
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connect String
Data Type Mapping Set
As a cube data source:
Provider Type
Server
Database
Connection Name
Connection Type
ODBC Source
Provider Name
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connect String
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Provider Name
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Provider Name
Full Database Path Name
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
SQL Server
Oracle
DB2 for Linux, UNIX and Windows (the DB2 in which Data Warehouse Designer can build a warehouse)
Teradata
Sybase
MySQL
DB2/400 (the DB2 that runs on AS/400 machines - quite different to above)
MS Access
Excel
Connection Name
Connection Type
ODBC Source
Provider Name
Full Database Path Name
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
SQL Server
Oracle
DB2 for Linux, UNIX and Windows (the DB2 in which RED can build a warehouse)
Teradata
Sybase
MySQL
DB2/400 (the DB2 that runs on AS/400 machines - quite different to above)
MS Access
Excel
Connection Name
Connection Type
Host Name
Work Directory
Database ID (SID)
Database Home Directory
Windows User ID and Password
Dss User ID and Password
Data Type Mapping Set
To test the connection
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator user id
Administrator password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
Analysis Server
User ID and Password
Connection Name
Connection Type
Analysis Server
User ID and Password
Oracle Connections
Data Warehouse check box
Connection Name
Connection Type
ODBC Source
Provider Name
Work Directory
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
As a cube data source:
Provider Type
Server
Database
Connection Name
Connection Type
ODBC Source
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
Host Name
Work Directory
Database ID (SID)
Database Home Directory
Unix User ID
Unix Password
Dss user id
Dss password
Data Type Mapping Set
Sample Unix connection screen:
Shell Type
Command
Pre Login Action, Login prompt, Password prompt, Post login action, and Command prompt.
Pre Login Action
Login Prompt
Password Prompt
Post Login Action
Command prompt
To validate the fields
To test the drag and drop functionality
Connection Failures
Connection Name
Connection Type
Host Name
Work Directory
Database ID (SID)
Database Home Directory
Windows User ID and Password
Dss User ID and Password
Data Type Mapping Set
To test the connection
Connection Name
Connection Type
ODBC Source
Work directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
Data Type Mapping Set
Connection Name
Connection Type
Analysis Server
User ID and Password
Connection Name
Connection Type
Analysis Server
User ID and Password
DB2 Connections
Data Warehouse check box
Connection Name
Connection Type
ODBC Source
Provider Name
Work Directory
Database ID (SID)
Database Link ID
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
Data Type Mapping Set
As a cube data source:
Provider Type
Server
Database
Connection Name
Connection Type
Host Name
Work Directory
Database ID (SID)
Database Home Directory
Unix User ID
Unix Password
Dss User ID
Dss Password
Data Type Mapping Set
Sample Unix connection screen:
Shell Type
Command
Pre Login Action, Login prompt, Password prompt, Post login action, and Command prompt.
Pre Login Action
Login prompt
Password prompt
Post login action
Command prompt
To validate the fields
To test the drag and drop functionality
Connection Failures
Connection Name
Connection Type
Host Name
Work Directory
Database ID (SID)
Database Home Directory
Windows User ID and Password
Dss User ID and Password
Data Type Mapping Set
To test the connection
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
SSIS Connection String
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
Data Type Mapping Set
Connection Name
Connection Type
ODBC Source
Work Directory
Extract User ID
Extract Password
Administrator User ID
Administrator Password
Default Load Type
Data Type Mapping Set
Connection Name
Connection Type
Analysis Server
User ID and Password
Connection Name
Connection Type
Analysis Server
User ID and Password
Table Properties
Table Storage Properties
Tablespace/Filegroup name
Data Compression
VarDecimal
Initial extent (KB)
Next extent (KB)
Minimum extents
Maximum extents
Percent increase
Percent free
Buffer Pool attribute
Compress
Volatile
Append Only
Index build logging
Table Notes
Table Documentation Fields
Table Statistics in DB2
Loading Data
Choosing the Best Load Method
Load Table Decision Tree
Load Drag and Drop
Data Type Mapping Set
Description
Data Type Mappings
Moving Sets between Environments
Database Link Load
Load Table Name
Short Name
Description
Connection
Load Type
Database Link
Script Name
Pre-load Action
Pre-load Sql
Table Properties clauses (e.g, Partition)
Post Load Procedure
Source schema
Source table name(s)
Non mandatory source columns
Exit status when missing columns
Load Type
Load Modifier
Distinct data select
Insert Hint
Use Source column/transformation checkbox
Source columns
Where, Group etc. clauses:
Remote view name
Where clause (for Remote view)
Load Statement
DB2 Source Mapping Screen:
Oracle Source Mapping Screen:
SQL Server Source Mapping Screen:
ODBC Based Load
SSIS Loader
Native ODBC Based Load
Native Loads in Oracle
Source schema
Source table name(s)
Non mandatory source columns
Exit status when missing columns
Native Load Routine
Native Load Delimiter
UNICODE extract file
Distinct data select
Use Source column/transformation check box
Source columns
Where, Group etc. clauses:
Remote view name
Where clause (for Remote view)
Load Statement
DB2 Source Mapping Screen:
Oracle Source Mapping Screen:
SQL Server Source Mapping Screen:
Creating a File Action
Flat File Loads
Flat file loads
Single data column
Columns parsed
Conversion
Understanding SQL*Loader
File Path
File Name
File Column Delimiter
Optionally enclosed by
File has a Header line
File Record Delimiter
Sql loader options
BULK INSERT options
LOAD options
LOAD modifier
Wait seconds
Action on wait expire
Trigger Path
Trigger Name
Trigger Delimiter
Trigger Parameter Prefix
Rename File Path
Rename File Name
Rename Trigger Path
Rename Trigger Name
XML File load
Supported XML Formats
Separate XML and XSD files
In line schema definition
External Load
Handling Missing Source Columns
Use Source column/transformation
Non mandatory source columns
Exit status when missing columns
Limitations of Missing Column check
Load Table Transformations
Changing Load Connection and Schema
Switching Connection from ODBC to Database
Switching Connection from Database to ODBC
Dimensions
Dimensions Overview
Dimension Keys
Business Key
Artificial Key
Building a Dimension
Drag and Drop
Dimension Type
Slowly Changing
Normal
Dimension Properties
Previous Values Dimension Type
Create and Load
Deleting and Changing columns
Adding additional columns
Manually adding previous value columns
Create the table
Generating the Dimension Update Procedure
The zero key row
Generating a Procedure
Join Or Lookup
Business Key definition
Slowly Changing columns
Joining multiple source tables
Simple Join
Outer Join
Lookup
Building and Compiling the Procedure
Indexes
Dimension Artificial Keys
Dimension Get Key Function
Modifying the 'Get Key' function
Adding a second 'Get Key' function for a dimension
Extending the 'Get Key' function
Dimension Initial Build
Dimension Column Properties
Table
Column name
Business display name
Data type
Format
Column order
Nulls
Numeric
Additive
Attribute
Source table
Source column
Business definition/Source strategy
Zero key value
End User Layer display
Key Type
Artificial Key
Primary Business Key
Dimension Column Transformations
Dimension Hierarchies
Snowflake
Dimension Language Mapping
Staging
Building the Stage Table
Multiple data sources
Drag and Drop
Create the table
Generating the Staging Update Procedure
Generating a Procedure
Procedure type
Cursor based procedure
Sorted cursor procedure
Set based procedure
Set + Cursor Procedure
Set Merge Procedure
Bulk Bind Procedure
Parameters variables
Multiple source tables
Source table joins
Simple Join
Outer Join
Dimension Joins
Slowly changing dimension information
Staging table business key
Index re-creation
Building and Compiling the Procedure
Tuning the Staging Update Process
Removing the Update Component
Stage Table Column Properties
Table
Column name
Business display name
Data type
Format
Column order
Nulls
Numeric
Additive
Attribute
Source table
Source column
Business definition/Source strategy
Dimension Join
Manual Dimension Join
Key Type
Artificial Key
Primary Business Key
Transformation Tab
Stage Table Column Transformations
Set Merge Procedure
Data Store Object Overview
Data Store Object Keys
Business Key
Building a Data Store Object
Drag and Drop
Data Store Object Properties
Create and Load
Deleting and Changing columns
Adding additional columns
Create the table
Generating the Data Store Update Procedure
Procedure Types
Build Options
Process in batch
Distinct data select
Include delete before insert
Include initial load insert
Insert Zero Key Record
Include update statement with/without Minus Select using except/checksum
Include insert statement with/without Minus Select using except/checksum
Update hint.
Insert hint.
Parameters variables
Business Key definition
Change Detection and History Tables
Add null support
Update Current record only
Start date for initial member
End date for current member
Start date for new member entry
End date for expiring member entry
Reset
Joining multiple source tables, where and group by clauses
Simple Join
Outer Join
Where Clause
Group By Clause
Building and Compiling the Procedure
Indexes
Data Store Artificial Keys
Data Store Column Properties
Table
Column name
Business display name
Data type
Format
Column order
Nulls
Numeric
Additive
Attribute
Source table
Source column
Business definition/Source strategy
Default Value
Key Type
Artificial Key
Primary Business Key
Data Store Object Column Transformations
Normalized Tables
Normalized Tables Overview
Normalized Table Keys
Business Key
Artificial Key
Building a Normalized Table
Drag and Drop
Normalized Table Properties
Create and Load
Deleting and Changing columns
Adding additional columns
Create the table
Generating the Normalized Update Procedure
Procedure Types
Build Options
Process in batch
Distinct data select
Include delete before insert
Include initial load insert
Insert Zero Key Record
Include update statement with/without Minus Select using except/checksum
Include insert statement with/without Minus Select using except/checksum
Update hint.
Insert hint.
Parameters variables
Business Key definition
Change Detection and History Tables
Add null support
Update Current record only
Start date for initial member
End date for current member
Start date for new member entry
End date for expiring member entry
Reset
Converting an existing Normalized Table to a Normalized History Table
Joining multiple source tables, where and group by clauses
Simple Join
Outer Join
Where Clause
Group By Clause
Building and Compiling the Procedure
Indexes
Normalized Table Artificial Keys
Normalized Table Column Properties
Table
Column name
Business display name
Data type
Format
Column order
Nulls
Numeric
Additive
Attribute
Source table
Source column
Business definition/Source strategy
Default Value
End User Layer display
Join
Manual Join
Key Type
Artificial Key
Primary Business Key
Normalized Table Column Transformations
Fact Tables
Detail Fact Tables
Detail Fact Columns
Rollup or Combined Fact Tables
Rollup Fact Columns
KPI Fact Tables
Adding columns
KPI Dimension
Create the KPI Fact Table
Defining column types and default values
Create the 'Update' procedure
Define each KPI
The KPI Statement
Procedural Block
Procedure
Copying KPIs
Testing/Development.
Snapshot Fact Tables
Snapshot Fact Columns
Slowly Changing Fact Tables
Partitioned Fact Tables
Create a detail or rollup/combined fact table
Convert to a partitioned fact table.
The partitioned fact table update procedure
Create a detail or rollup/combined fact table
Convert to a partitioned fact table.
The partitioned fact table update procedure
Create a detail or rollup/combined fact table
Convert to a partitioned fact table.
The partitioned fact table update procedure
Fact Table Column Properties
Table
Column name
Business display name
Data type
Format
Column order
Nulls
Numeric
Additive
Attribute
Source table
Source column
Business definition/Source strategy
Column Type
Default Value
End User Layer display
Dimension Join
Manual Dimension Join
Key Type
Artificial Key
Primary Business Key
Fact Table Language Mapping
Aggregation
Creating an Aggregate Table
Creating an Aggregate Summary Table
Views
Creating a Dimension View
Remove column prefix
Add column prefix
Remove business display prefix
Add business display prefix
Old column name
New column name
Non-Dimension Object Views
Creating a Custom View
Dimension View Language Mapping
Analysis Services OLAP Cubes
Overview
Defining an OLAP Cube
Building a New OLAP Cube
Setting Cube Properties
Inspecting and Modifying Advanced Cube Properties
Measure Groups
Measures
Calculations
KPIs
Actions
Partitions
Dimensions
Measure Group Dimensions
Creating an OLAP Cube on the Analysis Services Server
OLAP Cube Objects
Internal Cube Name
Cube Publish Name
Cube Description
Cube Database Connection
Cube Database Name
Data Source Connection
Data Source Provider Type
Data Source Server
Data Source Database
Post Create XML/A Script
Post Update XML/A Script
Processing Mode
Processing Priority
Process Cube Dimensions
Storage Mode
Default Measure
Estimated Rows
Visible
Language Mapping
Measure Group Name
Measure Group Description
Update Buttons
Source Table Type
Source Table
Estimated Rows
Storage Mode
Ignore Unrelated Dimensions
Measure Group Type
Processing Mode
Processing Priority
Process Method
Increment Filter
Partitioning
Partitioning Method
Partition by Dimension
Partition by Attribute
Partition by Value Type
Fact Partition Lookup Clause
Max Number of Auto Created Partitions
Number of Historic Partitions Updated
To Display Measure Groups
To Add a Measure Group
To Delete a Measure Group
Displaying Measures
Displaying Partitions
Cube name
Data source
Fact table
Update Buttons
Partition name
Partition description
Data slice formula
Aggregation prefix
Filter statement
Storage mode
Partition type
Remote server
Processing method
Cube Name
Measure Name
Measure Group
Update Buttons
Source Table
Source Column
Data Type
Aggregation Method
Display Format
Null Processing
Order number
Visible
Display Folder
Description
To View measures
To Add a New Measure
To Delete a measure
Cube Name
Calculated Member Name
Update Buttons
Description
Expression
Parent Hierarchy
Parent Member
Associated Measure Group
Display Folder
Display Format
Visible
Non Empty Behavior
Order Number
To View Calculations
To Add a Calculation
To Delete a calculation
Cube Name
KPI Name
Description
Update Buttons
Display Folder
Associated Measure Group
Value Expression
Goal Expression
Status Indicator
Status Expression
Trend Indicator
Trend Expression
Parent KPI
Weight
To View KPIs
To Add a KPI
To Delete a KPI
Cube Name
Action Type
Action Name
Update Buttons
Target Type
Target Object:
Condition
Report Action: Server
Report Action: Report Path
Format/Content Type
Expression
Default
Invocation
Application
Description
Caption
Caption is MDX
To View Actions
To Add an Action
To Delete an Action
Internal Dimension Name
OLAP Dimension Name
Cube Dimension Name
Update Buttons
Dimension Description
Order Number
Process Cube Dimension With Cube
Visible
All member aggregation usage
Hierarchy unique name style
Member unique name style
To View Cube Dimensions
To Add a Cube Dimension
To Remove a Cube Dimension
Internal Dimension Name
OLAP Dimension Name
Cube Dimension Name
Update Buttons
Dimension Description
Order Number
Update dimension with Cube
Visible
All member aggregation usage
Hierarchy unique name style
Member unique name style
Measure group
Measure group column
Relationship type
Cardinality
Source Table Type
Source Table
Source Table Key
Processing Mode
All Caption
OLAP Dimension Type
Unknown member Action
Unknown Member Name
OLAP Dimension Objects
Internal Dimension Name
Dimension Publish Name
Dimension Description
Default database connection and OLAP Database Name
Data Source Connection
Source Table Type
Source Table
Source Table Key
Processing Group
Processing Mode
Processing Method
Storage Mode
All Caption
OLAP Dimension Type
Unknown member Action
Unknown Member Name
Language Mapping
Dimension Name
Internal Attribute Name
Published Name
Description
Estimated Count
Member Names Unique
Hierarchy Visible
Hierarchy Enabled
Hierarchy Optimized State
Hierarchy Display Folder
Order by
Order by attribute
Type
Usage
Key Column
Name Column
To View Attributes
To Add an Attribute
To Delete an Attribute
Dimension Name
Attribute
Relationship Name
Related Attribute
Relationship Type
Cardinality
Visible
To View Attribute Relationships
To Add an Attribute Relationship
To Delete an Attribute Relationship
Dimension Name
Internal Hierarchy Name
Hierarchy Publish Name
Hierarchy Description
All Member Name
Allow duplicate Names
Member Keys Unique
Member Names Unique
Display Folder
To view User Defined Hierarchies
To Add a User Defined Hierarchy
To Delete a User Defined Hierarchy
Dimension Name
Hierarchy
Level Number
Internal Level Name
Level Publish Name
Level Description
Source Attribute
Hide If
To View User Defined Hierarchy Levels
To Add a User Defined Hierarchy
To Delete a User Defined Hierarchy Level
Changing OLAP Cubes
Retrofitting an OLAP Object
Exporting Data
Building an Export Object
File Attributes
Export File Path
Export File Name
Export Routine
Export Format
Export File Delimiter
Optionally Enclosed by
Header row in export file
Export options
Export modifier
Trigger Path
Trigger Name
Trigger Delimiter
Trigger Parameter 1,2,3
Compress after export
Compress Utility Path
Compress Utility Name
Compress Parameters
Export Column Attributes
Table Name
Column name
Business display name
Data type
Column order
Format
Nulls
Numeric
Additive
Attribute
Source table
Source column
Business definition / Source strategy
Host Script Exports
MicroStrategy Projects
MicroStrategy Prerequisites
Building MicroStrategy Projects
Transformations
Column Transformations
Function SQL Text Window
Function Builder
Add Src table.col Button
Add table.col Button
Transform Stage
Update Buttons
Function Syntax
Function Desc
Function Model
Localize Transformation
Overview
Example
Example
Example
Database Functions
Re-usable Transformations
Transform Description
Function Tag
Function Syntax
Function Description
Example of Building a Transformation Model
Example of a change to the Model SQL
Procedures and Scripts
Procedures
Scripts
Procedure Generation
Wrapper procedures
Procedure Editing
Indenting code
Cut, Copy, Paste and Delete
Indenting a block of text
Commenting out a block of text
Inserting Steps
Inserting Audit Message
Inserting Detail/Error Message
Viewing other procedural code
Procedure Loading and Saving
Loading data
Saving the Procedure
Versions
Procedure Comparisons
Procedure Compilation
Procedure Running
Procedure Syntax
Parameters
Procedure Properties
Script Generation
Script Editing
Indenting code
Cut, Copy, Paste and Delete
Indenting a block of text
Viewing other scripts
Script Testing
UNIX Scripts
Script Syntax
Windows Example for Oracle:
Calling a Batch File from a Script
Templates
Procedure Structure Templates
Example Templates
Submitting Example Templates
Scheduler
Audit trail
Error trail
Administration Views
Scheduler Options
Toolbar/Jobs menu
Top pane
Middle pane
Bottom pane
Scheduler States
Scheduling a Job
To add a task:
Change the action on an object
Order
Respace Order
Group Object Types
Ungroup All
Jobs within Jobs
Editing Jobs
To edit a job
Deleting Job Logs
Monitoring the Database and Jobs
Monitor Days
Nominal Start Time
Earliest Possible Start
Periodicity of Job
Notification Order
Must Start Within (Notification)
Must Finish In (Notification)
Run Warning Count (Notification)
Run Error Count (Notification)
Finish Warning Count (Notification)
Finish Error Count (Notification)
Finish Success (Notification)
Checkpoint 1 (Notification)
Checkpoint 2 (Notification)
Checkpoint 3 (Notification)
Stand Alone Scheduler Maintenance
Scheduler maintenance logon
Scheduler maintenance grants
SQL to return Scheduler Status
22.9 Reset Columns in Job and Task View
Indexes
Index Definition
Properties
Index Storage Properties
Filegroup name
Fill Factor (0 to 100)
Sort in tempdb
Additional build options
Percent Free
Level 2 Percent Free
Minimum Percent Used
Documentation and Diagrams
Creating Documentation
Create documentation
Creating a header
Adding Links
Adding glossary elements
Batch Documentation Creation
Parameter Descriptions
Example
Reading the Documentation
Diagrams
Printable diagram editing
Printable diagram save
Printable diagram load
Creating a Job from a Source Tracking Diagram
Editing a Job's Dependencies from a Job Dependencies diagram
Query Tool Access
Dimension tables and columns
Fact tables and columns
Fact - Dimension Joins
Reports
Dimension-Fact Matrix
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
OLAP Dimension-Cube Matrix
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Dimension Views of a Specified Dimension
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Column Reports
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Sending Results to Microsoft Excel
Table Reports
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Procedure Reports
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Index Reports
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Object Reports
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Job Reports
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Operational Reports
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Validate
Validate Meta-data
Sending Results to Microsoft Excel
Validate Workflow Data
Sending Results to Microsoft Excel
Validate Table Create Status
Sending Results to Microsoft Excel
Validate Load Table Status
Sending Results to Microsoft Excel
Validate Index Status
Sending Results to Microsoft Excel
Validate Procedure Status
Sending Results to Microsoft Excel
List Meta-data Tables not in the Database
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
List Database Tables not in the Meta-data
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
List Tables with no related Procedures or Scripts
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
List Procedures not related to a Table
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Compare Meta-data Repository to another
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Compare Meta-data Indexes to Database
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
List Duplicate Business Key Columns
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Query Data Warehouse Objects
Objects Included
Parameters
Results
Report Example
Sending Results to Microsoft Excel
Promoting Between Environments
Applications
Creating an Application
Define an Application distribution
Output Directory
Application Identifier
Application Version
Application Name
Description
Previous Application
Pre application load SQL
Post application load SQL
Objects to Add/Replace
Objects to Delete
Importing Object Metadata
Importing Language Files
Data Warehouse Testing
Creating and Loading Applications from the Command Line
Backing Up and Restoring Metadata
Backup using DB Routines
UNIX Backups
Windows Backups
Oracle Windows Backups
SQL Server Windows Backups
DB2 Windows Backups
Restoring DB Backups
Restoring metadata
Oracle Windows Restore
Oracle UNIX restore
SQL Server Windows Restore
DB2 Windows Restore
Unloading Metadata
Performing an Unload
Loading an Unload
Performing a Load
Altering Metadata
Validating Tables
Using outdated metadata in drag and drop
Validating Source (Load) Tables
Validating Procedures
Altering Tables
Validating Indexes
Recompiling Procedures
Re-validate Procedures (Oracle only)
Callable Procedures
Introduction to Callable Procedures
Terminology
Common Parameters
Ws_Api_Glossary
Callable Procedure Type
Call Syntax
Parameters
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Connect_Replace
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Clear_Archive
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Clear_Logs
Callable Procedure Type
Call Syntax
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Clear_Logs_By_Date
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Create
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_CreateWait
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Dependency
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Release
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Restart
Callable Procedure Type
Call Syntax
The calling syntax is:
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Schedule
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Job_Status
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
Job Status - Simple
Job Status - Standard
Job Status - Enhanced
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Load_Change
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Maintain_Indexes
Callable Procedure Type
Call Syntax
Parameters
Valid options
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_Version_Clear
Callable Procedure Type
Call Syntax
Parameters
Valid Return Codes
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsParameterRead
Callable Procedure Type
Call Syntax
Parameters
Returned data
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsParameterReadG
Callable Procedure Type
Call Syntax:
Parameters
Returned data
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsParameterReadJ
Callable Procedure Type
Call Syntax
Parameters
Returned data
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsParameterWrite
Callable Procedure Type
Call Syntax
Parameters
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsWrkAudit
Callable Procedure Type
Call Syntax
Parameters
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsWrkAuditBulk
Callable Procedure Type
Call Syntax
Parameters
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsWrkError
Callable Procedure Type
Call Syntax
Parameters
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsWrkErrorBulk
Callable Procedure Type
Call Syntax
Parameters
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
WsWrkTask
Callable Procedure Type
Call Syntax
Parameters
Returned result
SQL Server Examples:
Oracle Examples:
DB2 Examples:
Ws_admin_v Views
Ws_admin_v_audit
Columns
Screen shot of Sample Data returned
SQL Script
Ws_admin_v_dim_col
Columns
Screen shot of Sample Data returned
SQL Script
Ws_admin_v_error
Columns
Screen shot of Sample Data returned
SQL Script
Ws_admin_v_fact_col
Columns
Screen shot of Sample Data returned
SQL Script
Ws_admin_v_fact_join
Columns
Screen shot of Sample Data returned
SQL Script
Ws_admin_v_sched
Columns
Screen shot of Sample Data returned
SQL Script
Ws_admin_v_task
Columns
Screen shot of Sample Data returned
SQL Script
Retrofitting
Migrating the Data Warehouse Database Platform
Importing a Data Model
Re-Targeting Source Tables
Retro Copying Column Properties
Table
Column name
Business display name
Data type
Format
Column order
Nulls
Numeric
Additive
Attribute
Source table
Source column
Business definition/Source strategy
Dimension Join
Manual Dimension Join
Key Type
Artificial Key
Primary Business Key
Transformation Tab
Integrating QAD Data Warehouse Designer into an Existing Warehouse
Rebuilding
Integrate
Rebuilding
The rebuild process
Integrating
The integrate process
Removing the metadata for a table
Artificial Key definition
Get Key Function
Update Procedure
Artificial Key Sequence
Update Procedure Definition
Business Key definition
Index definition
Procedure creation
Parameters
Join Information Maintenance
Filter
Object Type
Table/View
Column
Upgrading Data Warehouse Designer
Login Checks
Change Summary
Login Checks