Design, Modeling, and Transformations
- Spatial Joins with TimeXtender ★
- Create a self-join table using Custom Views
- How to create an Environment Specific Project Variable
- How to create a dynamic project variable
- How to use the Add Related Records feature
- How to build a Parent-Child dimension
- How to create secured views and securable columns
- Custom conditions on Conditional Lookup fields
- How to create a custom table insert
- Using the Override Data Type feature
- Understanding data selection rule syntax and function
- Exploding tables using views
- How to deal with empty fields
- How to create an aggregate table
- How to keep data from retired systems in the staging database
- How to add a default value to a unique identifier field
- How to create all possible combinations across two (not joined) tables
- How to split a single field into multiple fields
- How to set up many-to-many relations in TimeXtender (PDF)
- What is a Data Staging Area?
- What is a degenerate dimension?