MENU
    Derived Variables
    • 2 Minutes to read
    • Dark
    • PDF

    Derived Variables

    • Dark
    • PDF

    Article summary

    What are Derived Variables

    Derived variables contain a formula that references a Substitution Variable and derives an appropriate value by evaluating the formula.

    For example, you need to set up a derived variable which will result in the month preceding the Current Month.

    Use a Derived Variable named @CURMTH -1@, which references a Substitution Variable @CURMTH@ and contains the formula; such as @CURMTH.Lag(1).

    Another example may be that you need to set up a derived variable off of substitution variable @CURMTH@ (current month) to list all the days in the month. Your hierarchy is set up where Jan 2017 has 1/1/2017 through 1/31/2017.

    Use the following options:

    @CurMth@ = Jan-17

    @CurMth.Day01@ = @CurMth@.FirstChild

    @CurMth.Day02@ = @CurMth@.FirstChild.lead(1)

    @CurMth.Day03@ = @CurMth@.FirstChild.lead(2)

    Because the Time dimension is not symmetrical, meaning every month does not have the same # of days, you could change @CurMth@ to Feb-17, but since Feb only has 28 days, the last 3 derived variables would get the 1st 3 days in March.

    Description of Fields on Derived Variable Page

    Code - The identifier of the variable.

    Reporting Area/Dimension - Derived Variables utilize the same Reporting Area and Dimension as the Substitution Variable. Each Derived Variable requires the selected Substitution Variable to be part of the formula.

    Derived Formula - The value associated with the derived variable.

    System-Defined Derived Variables

    There are 49 derived variables for the @CURYR@ substitution variable on the Time dimension. These derived variables are available for Financial and Workforce reporting areas.

    You can access the derived variables by navigating to Maintenance > Reports > Cube Settings > Substitution Variables > @CURYR@> Derived Variables.

    Note:
    The derived variables of @CURYR@ are not displayed if the value of @CURYR@ is not set to a valid year.

    The followings derived variables are available.


    Variable Name

    Variable Type

    Purpose

    1

    @CURYRQ1@

    Derived Variable

    Quarter 1

    2

    @CURYRQ2@

    Derived Variable

    Quarter 2

    3

    @CURYRQ3@

    Derived Variable

    Quarter 3

    4

    @CURYRQ4@

    Derived Variable

    Quarter 4

    5

    @NYRQ1@

    Derived Variable

    Next year Quarter 1

    6

    @NYRQ2@

    Derived Variable

    Next year Quarter 2

    7

    @NYRQ3@

    Derived Variable

    Next year Quarter 3

    8

    @NYRQ4@

    Derived Variable

    Next year Quarter 4

    9

    @PRYRQ1@

    Derived Variable

    Previous year Quarter 1

    10

    @PRYRQ2@

    Derived Variable

    Previous year Quarter 2

    11

    @PRYRQ3@

    Derived Variable

    Previous year Quarter 3

    12

    @PRYRQ4@

    Derived Variable

    Previous year Quarter 4

    13

    @CURM01@

    Derived Variable

    1st month of the year

    14

    @CURM02@

    Derived Variable

    2nd month of the year

    15

    @CURM03@

    Derived Variable

    3rd month of the year

    16

    @CURM04@

    Derived Variable

    4th month of the year

    17

    @CURM05@

    Derived Variable

    5th month of the year

    18

    @CURM06@

    Derived Variable

    6th month of the year

    19

    @CURM07@

    Derived Variable

    7th month of the year

    20

    @CURM08@

    Derived Variable

    8th month of the year

    21

    @CURM09@

    Derived Variable

    9th month of the year

    22

    @CURM10@

    Derived Variable

    10th month of the year

    23

    @CURM11@

    Derived Variable

    11th month of the year

    24

    @CURM12@

    Derived Variable

    12th month of the year

    25

    @NYRM01@

    Derived Variable

    1st month of the next year

    26

    @NYRM02@

    Derived Variable

    2nd month of the next year

    27

    @NYRM03@

    Derived Variable

    3rd month of the next year

    28

    @NYRM04@

    Derived Variable

    4th month of the next year

    29

    @NYRM05@

    Derived Variable

    5th month of the next year

    30

    @NYRM06@

    Derived Variable

    6th month of the next year

    31

    @NYRM07@

    Derived Variable

    7th month of the next year

    32

    @NYRM08@

    Derived Variable

    8th month of the next year

    33

    @NYRM09@

    Derived Variable

    9th month of the next year

    34

    @NYRM10@

    Derived Variable

    10th month of the next year

    35

    @NYRM11@

    Derived Variable

    11th month of the next year

    36

    @NYRM12@

    Derived Variable

    12th month of the next year

    37

    @PRYRM01@

    Derived Variable

    1st month of the previous year

    38

    @PRYRM02@

    Derived Variable

    2nd month of the previous year

    39

    @PRYRM03@

    Derived Variable

    3rd month of the previous year

    40

    @PRYRM04@

    Derived Variable

    4th month of the previous year

    41

    @PRYRM05@

    Derived Variable

    5th month of the previous year

    42

    @PRYRM06@

    Derived Variable

    6th month of the previous year

    43

    @PRYRM07@

    Derived Variable

    7th month of the previous year

    44

    @PRYRM08@

    Derived Variable

    8th month of the previous year

    45

    @PRYRM09@

    Derived Variable

    9th month of the previous year

    46

    @PRYRM10@

    Derived Variable

    10th month of the previous year

    47

    @PRYRM11@

    Derived Variable

    11th month of the previous year

    48

    @PRYRM12@

    Derived Variable

    12th month of the previous year

    49

    @2YRPriorM12@

    Derived Variable

    12th month of 2nd year prior to the current year


    Was this article helpful?