Defining Scenario Members

You define scenario members by using the attributes in Table 11.

Table 11. Scenario Member Attributes  

Attribute

Description

ConsolidateYTD

Specifies the view for consolidation. This attribute is required. Specify Y for YTD or N for periodic.

DefaultFreq

Specifies the types of periods for which data input is valid for the scenario. This attribute is required.

For example, a value of Monthly indicates that you can extract input data only in month-based periods, not in quarter-based or year-based periods. The frequency must be defined in the application profile.

DefaultParent

Specifies the default parent for the scenario.

DefaultView

Specifies the view to use when Scenario View is selected in the point-of-view bar. This attribute is required. Specify YTD or Periodic.

If you change the default view for a scenario and line-item detail has been entered, you should first extract the line-item detail and save it. Then delete the line-item detail from the scenario before changing the view. You must change the extracted line-item detail to match the new default view before loading it.

DefFreqForICTrans

Specifies the default frequency for intercompany transactions. This attribute must be a valid frequency and can contain a maximum of 80 characters. The default for this attribute is blank.

Description

Specifies the description for the scenario. The description can contain up to 80 characters, including spaces.

EnableDataAudit

Specifies whether the scenario is audited. This attribute for an account or a scenario determines what can be audited. Specify one of these values:

  • Y to automatically audit all accounts. Even accounts that have EnableDataAudit set to False will be audited.

  • O to audit only those accounts that have EnableDataAudit set to True.

  • N to disable auditing for all accounts.

MaximumReviewLevel

Specifies the maximum Process Management review level for the scenario. Specify a review level from 1 to 10. This attribute is required.

Member

Specifies the name for the scenario. This attribute is required. The name must be unique and can contain up to 80 characters, including spaces, but cannot start with a space.

Note:

Scenario names cannot contain spaces if you are using an Oracle database.

Do not use these characters in the scenario name:

  • Period ( . )

  • Plus sign ( + )

  • Minus sign ( - )

  • Asterisk ( * )

  • Slash mark ( / )

  • Number sign ( # )

  • Comma ( , )

  • Semicolon ( ; )

  • At sign ( @ )

  • Double quote ( “ )

  • Curly brackets ( { } )

PhasedSubmissionStartYear

Specifies the start year for phased submissions in process management.

SecurityClass

Specifies the name of a valid security class that defines users who can access the data for the scenario. Security class names can contain up to 80 characters. For example, a user with None access rights to a scenario can open journal periods for the scenario.

SupportsProcessManagement

Specifies whether Process Management functionality is enabled. Specify one of these values:

  • Y to enable the Process Management

  • N to disable the Process Management option

  • A to enable Process Management and E-mail alerting.

UserDefined1, UserDefined2, UserDefined3

Stores custom information for the scenario. You can enter a maximum of 80 characters. The UserDefined1, UserDefined2, and UserDefined3 functions retrieve the text stored in this attribute.

UsesLineItems

Specifies whether the scenario can have line items. Specify Y if the scenario can accept line items and N if the scenario cannot accept line items.

Note:

If you change this attribute after line-item detail is entered, the stored line item detail may no longer be valid for the scenario. These behaviors occur:

  • If the scenario accepted line items and now it cannot, the line-item detail stored in the database is no longer valid. Only the total is displayed.

  • If the scenario did not accept line items and now it can, there is a total amount but no corresponding line-item detail information for the scenario. You can extract the total and then load it as line-item detail data so that the total matches the line-item detail information.

ZeroViewForAdj

Specifies how to interpret missing, adjusted data values for the period. This attribute is required. Specify YTD or Periodic.

ZeroViewForNonadj

Specifies how to interpret missing, nonadjusted data values for the period. This attribute is required. Specify YTD or Periodic.