Worksheet variables

Variable	Format	Example
%cube	Replaced with the full cube name.	'Normal.July 08.D'
%previouscube(n)	Replaced with the full cube name of the cube n periods prior to %cube. Uses the previous cycle period field to determine the links. Assumes returned cycle periods (cubes) are not archived.	%previouscube(1) gives 'Normal.June 08.D', %previouscube(2) gives 'Normal.May 08.D', %previouscube(2) gives 'Normal.Jul 07.D', etc...
%items	Replaced with the full cube item dimension.	'Normal.July 08.D.I'
%itemsA1	Replaced with the full cube item dimension.	'Normal.July 08.D.IA1'
%itemsA2	Replaced with the name of the additional pivot item dimension.	'Normal.July 08.D.IA2'
%itemsA3	Replaced with the name of the additional pivot item dimension.	'Normal.July 08.D.IA3'
%itemsA4	Replaced with the name of the additional pivot item dimension.	'Normal.July 08.D.IA4'
%itemsA5	Replaced with the name of the additional pivot item dimension.	'Normal.July 08.D.IA5'
%itemsAx	Places all currently enabled additional pivot item dimensions into a comma separated list including the %items dimension.	'Normal.July 10.D.I' (no additional pivot dimensions). 'Normal.July 10.D.I' ,'Normal.July 10.D.IA1','Normal.July 10.D.IA2' (two additional item pivot dimensions)
%locations	Replaced with the full cube location dimension.	'Normal.July 08.D.L'
%locationsA1	Replaced with the name of the additional pivot location dimension.	'Normal.July 08.D.LA1'
%locationsA2	Replaced with the name of the additional pivot location dimension.	'Normal.July 08.D.LA2'
%locationsA3	Replaced with the name of the additional pivot item dimension.	'Normal.July 08.D.LA3'
%locationsA4	Replaced with the name of the additional pivot item dimension.	'Normal.July 08.D.LA4'
%locationsA5	Replaced with the name of the additional pivot item dimension.	'Normal.July 08.D.LA5'
%locationsAx	Places all currently enabled additional pivot location dimensions into a comma separated list including the %locations dimension.	'Normal.July 10.D.L' (no additional pivot dimensions). 'Normal.July 10.D.L' ,'Normal.July 10.D.LA1','Normal.July 10.D.LA2' (two additional location pivot dimensions)
%periods	Replaced with the full cube period dimension.	'Normal.July 08.D.P'
%measures	Replaced with the full cube measure dimension name.	'Normal.July 08.D.M'
%scenarios	Replaced with the full cube scenario dimension name.	'Normal.July 08.D.S'
%cyclecontext%	Replaced with the name of the user's cycle data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.	'Normal'
%cycleperiodcontext%	Replaced with the node of the user's cycle period data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.	'FY08 M07 Jul'
%scenariocontext%	Replaced with the name of the user's scenario data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.	'Demand-Baseline'
%itemcontext%	Replaced with the node name of the user's item data context for the current module. Can be used in a worksheet parameter value to set the worksheet context. Allows use of OLAP terms to select nodes relative to the passed context. For example: `{[%itemcontext%].children}`is be replaced with `{[All Items].children}` in the worksheet URL and in the report would display the children of the `[All Items]` node.	'All Items'
%locationcontext%	Replaced with the node name of the user's location data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.	'EMEA'
%periodcontext%	Replaced with the node name of the user's period data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.	'Rolling Periods'
%FirstPeriod	Replaced with the first planning bucket in the current Cycle Period. If a monthly cycle (cycle periodicity) with weekly buckets (enterprise's calendar periodicity) this must be the first week of this (cycle) period.	'FY08 W27'
%ThisCyclePeriod	Replaced with the period label for the current Cycle Period. If a monthly cycle (cycle periodicity) this must be the monthly period label.	'FY08 M07 July'
%PreviousCyclePeriod	Replaced with the period label for the previous Cycle Period. Note: This is based on the previous bucket in the calendar for the cycle process periodicity, not necessarily the previously created cycle period.	'FY08 M06 June'
%ItemTopNode	Replaced with the node name of the top node in the primary item hierarchy for the current cube.	'All Items By Division'
%LocationTopNode	Replaced with the node name of the top node in the primary location hierarchy for the current cube.	'All Locations'
%PeriodTopNode	Replaced with the node name of the top node in the primary calendar hierarchy for the current cube.	'Standard Planning Calendar'
%PeriodYTD	Replaced with the node name of the top node in the additional period hierarchy Year to Date for the current cube.	'Year To Date'
%PeriodYearEnd	Replaced with the node name of the top node in the additional period hierarchy Year End for the current cube.	'Year End'
%PreviousYTD	Replaced with the node name of the top node in the additional period hierarchy Previous Year to Date for the current cube.	'Previous Year to Date'
%PreviousYearEnd	Replaced with the node name of the top node in the additional period hierarchy Precious Year End for the current cube.	'Previous Year End'
%periods:{{BasePeriodsBeforeFirstPeriod}}	Replaced with a set of elements of base periods in the cycle calendar hierarchy prior to `%FirstPeriod`.	{{[FY08 W26],[FY08 W25], ...}}
%periods:{{ConsolidatedPeriods}}	Replaced with a set of elements of all consolidated periods in the cycle calendar hierarchy.	{{[Weekly Calendar],[FY 2008],[FY08 Qtr1] ...}}
%periods:{{ParentsOfFirstBasePeriod}}	Replaced with a set of elements of all consolidated periods above `%FirstPeriod`.	{{[Weekly Calendar],[FY 2008],[FY08 Qtr3],[FY08 M06 June]}}
%periods:{{PeriodsInFirstCyclePeriod}}	Replaced with a set of all period elements that exist as children to the aggregate of current planning period at the level of the calendar defined by Cycle.Periodicity; including the aggregate and the current planning period and the siblings.	{[FY11 M11], [FY11 W44],[FY11 W45],[FY11 W46],[FY11 W47]}
%periods:{{FirstPeriodsPerYear}}	Replaced with a set of all period elements, including consolidated periods, in the first period of each year. This includes any appropriate additional period hierarchy parents.	{[FY 2011],[FY11 Qtr1],[FY11 M01],[FY11 W01],[FY 2012],[FY12 Qtr1],[FY12 M02],[FY12 W01],[FY 2013],[FY13 Qtr1],[FY13 M01],[FY13 W01]}

%cube

Replaced with the full cube name.

'Normal.July 08.D'

%previouscube(n)

Replaced with the full cube name of the cube n periods prior to %cube. Uses the previous cycle period field to determine the links. Assumes returned cycle periods (cubes) are not archived.

%previouscube(1) gives 'Normal.June 08.D', %previouscube(2) gives 'Normal.May 08.D', %previouscube(2) gives 'Normal.Jul 07.D', etc...

%items

Replaced with the full cube item dimension.

'Normal.July 08.D.I'

%itemsA1

Replaced with the full cube item dimension.

'Normal.July 08.D.IA1'

%itemsA2

Replaced with the name of the additional pivot item dimension.

'Normal.July 08.D.IA2'

%itemsA3

Replaced with the name of the additional pivot item dimension.

'Normal.July 08.D.IA3'

%itemsA4

Replaced with the name of the additional pivot item dimension.

'Normal.July 08.D.IA4'

%itemsA5

Replaced with the name of the additional pivot item dimension.

'Normal.July 08.D.IA5'

%itemsAx

Places all currently enabled additional pivot item dimensions into a comma separated list including the %items dimension.

'Normal.July 10.D.I' (no additional pivot dimensions). 'Normal.July 10.D.I' ,'Normal.July 10.D.IA1','Normal.July 10.D.IA2' (two additional item pivot dimensions)

%locations

Replaced with the full cube location dimension.

'Normal.July 08.D.L'

%locationsA1

Replaced with the name of the additional pivot location dimension.

'Normal.July 08.D.LA1'

%locationsA2

Replaced with the name of the additional pivot location dimension.

'Normal.July 08.D.LA2'

%locationsA3

Replaced with the name of the additional pivot item dimension.

'Normal.July 08.D.LA3'

%locationsA4

Replaced with the name of the additional pivot item dimension.

'Normal.July 08.D.LA4'

%locationsA5

Replaced with the name of the additional pivot item dimension.

'Normal.July 08.D.LA5'

%locationsAx

Places all currently enabled additional pivot location dimensions into a comma separated list including the %locations dimension.

'Normal.July 10.D.L' (no additional pivot dimensions). 'Normal.July 10.D.L' ,'Normal.July 10.D.LA1','Normal.July 10.D.LA2' (two additional location pivot dimensions)

%periods

Replaced with the full cube period dimension.

'Normal.July 08.D.P'

%measures

Replaced with the full cube measure dimension name.

'Normal.July 08.D.M'

%scenarios

Replaced with the full cube scenario dimension name.

'Normal.July 08.D.S'

%cyclecontext%

Replaced with the name of the user's cycle data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.

'Normal'

%cycleperiodcontext%

Replaced with the node of the user's cycle period data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.

'FY08 M07 Jul'

%scenariocontext%

Replaced with the name of the user's scenario data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.

'Demand-Baseline'

%itemcontext%

Replaced with the node name of the user's item data context for the current module. Can be used in a worksheet parameter value to set the worksheet context. Allows use of OLAP terms to select nodes relative to the passed context. For example:

{[%itemcontext%].children}

is be replaced with

{[All Items].children}

in the worksheet URL and in the report would display the children of the [All Items] node.

'All Items'

%locationcontext%

Replaced with the node name of the user's location data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.

'EMEA'

%periodcontext%

Replaced with the node name of the user's period data context for the current module. Can be used in a worksheet parameter value to set the worksheet context.

'Rolling Periods'

%FirstPeriod

Replaced with the first planning bucket in the current Cycle Period. If a monthly cycle (cycle periodicity) with weekly buckets (enterprise's calendar periodicity) this must be the first week of this (cycle) period.

'FY08 W27'

%ThisCyclePeriod

Replaced with the period label for the current Cycle Period. If a monthly cycle (cycle periodicity) this must be the monthly period label.

'FY08 M07 July'

%PreviousCyclePeriod

Replaced with the period label for the previous Cycle Period.

Note: This is based on the previous bucket in the calendar for the cycle process periodicity, not necessarily the previously created cycle period.

'FY08 M06 June'

%ItemTopNode

Replaced with the node name of the top node in the primary item hierarchy for the current cube.

'All Items By Division'

%LocationTopNode

Replaced with the node name of the top node in the primary location hierarchy for the current cube.

'All Locations'

%PeriodTopNode

Replaced with the node name of the top node in the primary calendar hierarchy for the current cube.

'Standard Planning Calendar'

%PeriodYTD

Replaced with the node name of the top node in the additional period hierarchy Year to Date for the current cube.

'Year To Date'

%PeriodYearEnd

Replaced with the node name of the top node in the additional period hierarchy Year End for the current cube.

'Year End'

%PreviousYTD

Replaced with the node name of the top node in the additional period hierarchy Previous Year to Date for the current cube.

'Previous Year to Date'

%PreviousYearEnd

Replaced with the node name of the top node in the additional period hierarchy Precious Year End for the current cube.

'Previous Year End'

%periods:{{BasePeriodsBeforeFirstPeriod}}

Replaced with a set of elements of base periods in the cycle calendar hierarchy prior to %FirstPeriod.

%periods:{{ConsolidatedPeriods}}

Replaced with a set of elements of all consolidated periods in the cycle calendar hierarchy.

%periods:{{ParentsOfFirstBasePeriod}}

Replaced with a set of elements of all consolidated periods above %FirstPeriod.

%periods:{{PeriodsInFirstCyclePeriod}}

Replaced with a set of all period elements that exist as children to the aggregate of current planning period at the level of the calendar defined by Cycle.Periodicity; including the aggregate and the current planning period and the siblings.

{[FY11 M11], [FY11 W44],[FY11 W45],[FY11 W46],[FY11 W47]}

%periods:{{FirstPeriodsPerYear}}

Replaced with a set of all period elements, including consolidated periods, in the first period of each year. This includes any appropriate additional period hierarchy parents.

{[FY 2011],[FY11 Qtr1],[FY11 M01],[FY11 W01],[FY 2012],[FY12 Qtr1],[FY12 M02],[FY12 W01],[FY 2013],[FY13 Qtr1],[FY13 M01],[FY13 W01]}