Required Properties for Time Dimensions

The time dimension defines the units of time for your application and how those units aggregate. Any dimension that is assigned the type T is a time dimension. Each application can have only one time dimension.

Features

A time dimension has the following required properties:

Property Name	Description
`EVDESCRIPTION`	A user-defined description for the member. Can be up to 50 characters and does not need to be unique. It cannot contain double quotation marks ("). This description appears in the language specified in My Settings within Interface for the Web (see My Settings). For information about loading a list of languages into the system, see Data Management for the NetWeaver platform or Data Management for the Microsoft platform.
`LEVEL`	Time can be a year, quarter, month, week, or day. The `LEVEL` property is important in defining your time periods. You must have the correct level for each member. You must follow the chronological format throughout the time dimension. The correct format is the following: YEAR QUARTER MONTH WEEK DAY
`PERIOD`	The `PERIOD` property allows you to filter, sort, and report based on the period.
`YEAR`	The `YEAR` property allows you to filter, sort, and report based on the year. You should place the `YEAR` properties in chronological order in the file, in order for the `EVTIM` function in the Excel interface to give offsets correctly.

In addition, when using the Microsoft version of the system, the following properties are required:

Property Name	Description
`TIMEID`	Needed to change the ID members into the time format required for Analysis Services.
`USERTIMEID`	`USERTIMEID` is used to define a new user defined `TIMEID`. The `TIMEID` is an internally assigned ID that converts the ID into an all numeric format for use in the SQL database. You can define your own `TIMEID` by specifying a `USERTIMEID`. If a `USERTIMEID` is specified, the system assigns it to the `TIMEID`. Note The new `TIMEID` must follow a logical naming convention so that the months, years, and so on, are identified correctly. End of the note. The property column must follow the `TIMEID` property column or you an error message is displayed when the system processes the time dimension.

Property Name

Description

TIMEID

Needed to change the ID members into the time format required for Analysis Services.

USERTIMEID

USERTIMEID is used to define a new user defined TIMEID. The TIMEID is an internally assigned ID that converts the ID into an all numeric format for use in the SQL database.

You can define your own TIMEID by specifying a USERTIMEID. If a USERTIMEID is specified, the system assigns it to the TIMEID.

Note Note

The new TIMEID must follow a logical naming convention so that the months, years, and so on, are identified correctly.

End of the note.

The property column must follow the TIMEID property column or you an error message is displayed when the system processes the time dimension.

More Information

Dimension Management

Defining Member Behavior Using Dimension Properties

Business Rules Management for the Microsoft platform or Business Rules Management for SAP NetWeaver