Variables

A variable represents a value. Use variables in DWD to update and maintain commonly-used values. .

You can create, save, or edit a variable instead of hard-coding values in all components of DWD. Variables make it possible for the same object to filter different sets of data. The reusability of variables helps reduce maintenance of scripts and minimizes the need for manual changes.

There are two types of variables in DWD:

• Run-time variable: is a search-criteria variable used across the application.

• Substitution variable: is an SQL Server object-name variable used in User-defined Code.

DWD supports variables in these objects:

• Composers

• Decoders

• Splitters

• Denormalizers

• Dimension Tables

• Fact Tables

• Data Source Objects

• User-Defined Codes

• Substitution Variables