Select the <//Solution Configurations / Dimension Key Settings > folder.
The main goal here is to administer the way dimension keys are used.
Select a Dimension ID to enable the editor used to edit Surrogate or Distinct Key.
Tick Uses Shared Surrogate Key or Uses Shared Distinct Key for a particular Dimension ID or click Tuning Advisor.
Tuning Advisor - Command Buttons
Perform Changes |
Click to use Surrogate and Distinct Key settings specified.
|
||||
Analyze Tuning Possibilities |
Click to start Analyze Tuning Posssibilities processing. |
||||
Stop |
Click to stop Analyze processing. |
||||
Show/Hide Log and Details |
Click to see Analyze log and Analyze details. |
Surrogate / Distinct Key settings - Command Buttons
Save |
Click to save the information defined to the Solution database. |
||||||||||||
Reset |
Click to undo any edits and or deletes and redisplay the original configuration as of the most recent Save. |
||||||||||||
Tasks and Data |
Processing Manual updates to the Data Warehouse Table are performed using the command buttons in the Tasks and Data form. The following commands are available:
|
Configure Surrogate Keys
Surrogate Key Settings
Main Settings |
|
Name Definition |
Name Definition |
Description |
Optional |
Comment |
Optional |
Start Index |
The increment seed for the surrogate key. |
Track Slowly Changing Attributes |
DimensionID will be handled as a type 2 Slowly Changing Dimension. |
Fact Date Column |
The Date Column to join on to find the correct slowly changing dimension row. |
Change From Expr. |
Expression used to fill the SCDFromDate field when historical attribute is changed. |
Statistic Columns |
|
New |
Click to add new Statistic Column. |
Delete |
Click to delete Statistic Column. |
Slowly Changing Historical Attributes |
|
New |
Click to add new Historical Attribute. |
Delete |
Click to delete Historical Attribute. |
Surrogate / Distinct Key - Right Click Options
New Surrogate/Distinct Key |
Click to open the form that allows for definition of a surrogate/distinct key. |
Delete |
Click to delete the selected Surrogate/Distinct Key. An "Are you sure?" dialog requiring a confirmation is displayed before the delete is performed. |
Browse Data |
View Surrogate Keys and Surrogate Key use. |