Technical data

Chapter 11 Using Built-in Functions in Analytic M odels
INCDATE
Syntax
INCDATE(Date
, Months, Years)
Description
The INCDATE returns the value of Date incremented by Months and Ye ars.
Returns
The value of Date incremented by Months and Years.
Example
If Date contai
ns the date 2001/04/18, INCDATE(Date, 3, 2) returns the date 2003/07/18.
If Date falls on the last day of a m onth, INCDATE returns a date that falls on the last day of a month, even
if it has to change the day. For example, if Date contains the date 2003/04/30, then INCDATE(Date,
3, 2) returns the date 2005/07/31 rather than 2005/07/30. Because Date contains the last day of April,
INCDATE returns the last day of July.
Suppose that an analytic model contains a data cube called HIRE_DATE that uses a dimension called
EMPLOYEES. Company policy starts benefits for an employee three months after the hire date. The following
formula calculates the benefits date for each employee as follows:
INCDATE(HIRE_DATE, 3, 0)
See Also
Chapter 11, “
Using Built-in Functions in Analy t ic Models,” IF, pa ge 164
INPUT
Syntax
INPUT()
Description
The INPUT function returns the value that an end user has entered into a cell, and supports both calculated
cells and input cells in a single data cube.
Returns
The val ue that an end user has entered into a cell.
Example
You c an us e t
he INPUT function in both an IF function and a CASE function. For example:
IF([SCENAR
IOS:Actual], INPUT( ), FORECAST_REVENUE_CALCULATION)
This formula returns 88 if the Scenario value is Actual and the end user enters 88. This formula causes all
cells for the Actual dimension member to become input cells, leaving the remaining cells to be calculated.
Copyright © 1988-2007, Oracl e. All rights reserved. 165