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.