Derived Variables

2 Minutes to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

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?

What's Next

Custom Members

Table of contents

What are Derived Variables
System-Defined Derived Variables