Variables, Functions, and Masking

1

• Variables, Functions, and Masking

Module 6
2
Variables

• Are user defined.
• Formula that has a name.
• Are usually displayed in columns alongside
  corresponding data.
• May contain functions.

3
Variables help when

• A formula is used repeatedly in different blocks
  and on different reports within a document.
• Creating an Object not found in the universe when
  its parts are.

4
Creating Variables
Variable Editor
Variable Name
Dimension Measure or Detail
Data (Objects)
5
Creating Variables (cont)
6
Functions

• Functions help you define formulas and / or
  variables.
• Function examples
• SubStr(...)
• ToNumber(...)
• CurrentDate(...)
• IsNull(...)
• ToDate(...)

7
Masking Data
To Mask certain portions of data create a
Variable and use a Sub-string or the Right
Function
Example Mask all but the last 4 digits of SSNs
8
To Mask Data with a Variable
9
EXERCISE TIME