Data Source Properties

General properties are standard across all data types.

Name

The name of the data source. 

Description

The field for a detailed description of the data source.

Security

The security properties are standard across all data types.

Access Group

Members of the assigned group have the authority to access the data source.

Maintenance Group

Members of the assigned group have the authority to maintain the data source.

NOTE: Click and begin typing the name of the Security group in the blank field. As the first few letters are typed, the groups are filtered making it easier to find and select the desired group. Once the group is selected, click CTRL double-click. This will enter the correct name into the appropriate field.

Settings

Settings are standard across all data types.

Cube Name

The cube associated with this data source which will dictate the available dimensions that can be used.

Scenario Type

This allows the profile to be assigned to a specific scenario type or all scenario types. If the data source is assigned to a specific Scenario Type, it will only be available when assigned to the Workflow Profile.

Data Structure Settings

Data structure settings are standard across all data types.

Type

This defines the source file structure. The Type can be Fixed, Delimited, Connector, or Data Management Export Sequence. Details on these types can be found below. 

Data Structure Type

Tabular

This will have a line or lines specific to a single intersection with one amount.

Matrix

This will have multiple amounts on a given line using rows and columns to determine the intersection that corresponds to each amount.

Allow Dynamic Excel Loads

If set to True, users will be able to load Excel templates as well as the data file for which the data source has been built. See the section on Using Excel as a data source for information on the proper formatting of these files.