Download and Extract
Source Data and Data Marts
Advanced: TARGIT Settings
Advanced: Periods Settings
Advanced Database Settings
Advanced: Dimension Settings
Advanced: Measure Settings
User Defined Attributes
You can add new attributes to existing dimensions from any of the source tables.
This video will show you how to add a new dimension to your Data Warehouse before executing the Accelerator.
Add table to Table Collection
When working with dimensions, you may need to add further attributes to one of the existing dimensions. If that attribute originates from a column in a table that is currently not part of the dimension, you must add the new table to become part of the dimension's Table Collection.
Dimension Attribute from Calculated Column
Suppose your source dimension table does not contain information in the exact way you would like to present these data to the end-users.
In that case, you can add a Calculated Column to your dimension tables. A Calculated Column lets you define custom content, e.g. a concatenation of two existing columns, potentially mixed with static text.
The Calculated Column is then immediately available to be used as a new attribute within your dimension.
Define your own custom hierarchies on basis of available attributes within the dimension.
Courage to Act
© 2017 TARGIT. All Rights Reserved.