Databases Reference
In-Depth Information
Additional Information About Change Management
The Help for SAS Data Integration Studio provides more details about
change-management. To display the relevant Help topics, do the following:
1
From the SAS Data Integration Studio menu bar, select
Help
Contents
. The
Help window displays.
2
In the left pane of the Help window, select
Task Overviews
SAS Data
Integration Studio Task Reference
Using Change Management in SAS
Data Integration Studio
.
Working with Impact Analysis and Reverse Impact Analysis (Data
Lineage)
Impact analysis displays information about how data is used. Reverse impact
analysis displays information about how data was developed. Analytical results are
derived from the current metadata repository and any parent repositories.
Impact analysis shows you the jobs, tables, and cubes that make use of a selected
table or column. This information is helpful before you modify or delete data. For
example, if you perform impact analysis on a column, the Impact Analysis window
might show that the selected column is used to build an OLAP cube. If you deleted that
column, you might also have to change the job that builds the cube. You can also track
the usage of generated transformations using impact analysis. In this case, the Impact
Analysis window shows all of the jobs that make use of the generated transformation.
Reverse impact analysis shows you the lineage of the data in a selected table,
column, or cube. This information is useful when you need to trace data errors or data
sources. For example, if you perform reverse impact analysis on a table, the results
might show that the data in the table was validated by a job that contains a Data
Validation transformation. The source for validation job might be an Oracle table. Data
errors might be present in the lookup table that provides valid values, or in the original
Oracle data.
Working with OLAP Cubes
Overview of OLAP Cubes
Online analytical processing (OLAP) cubes are logical sets of data that are structured
in a hierarchical, multidimensional arrangement. Cubes are valuable analytical tools
because they provide easily modified views of large data sets. Because of their size,
cubes are built and stored on servers and viewed, or queried, from client cube viewers.
To decrease the response time for commonly submitted queries, numeric data
summaries are calculated at build time and stored with the cube data.
OLAP Capabilities in SAS Data Integration Studio
In SAS Data Integration Studio, you can create and update OLAP cubes with the
Cube Designer, which is available in the Target Designer wizard. The Cube Designer
Search WWH ::
Custom Search