Configure Information Source - Fact Dimensions¶
This page describes configuration of the metadata associated with Dimensions connected to an Information Source.
Information Source Dimensions¶
An overview of dimensions connected to an Information Source is available in the Connected Dimensions section in the Information Source page.
Select one or more dimensions and then use the standard go-to-details command/button to navigate to the details page.
The following information is available:
Attribute | Description |
---|---|
Information Source Dimension Details | |
Information Source ID | Identity of the Information Source. Parent key. |
Info Source Display Name | Display name of the Information Source |
Dimension ID | Dimension identity. Key |
Dimension Display Name | Display name of the Dimension |
Associated Information Source Item ID | Information Source item identity that defines the column in the Information Source table that contains the unique identifier of an instance of associated dimension. This item is used for standard join between a fact and a dimension. It is joined with the Key Column of the connected dimension. |
Display Order | Display order of the dimension in the Information Source Navigator in clients. |
Dimension Alias | Alias of the Dimension. This item is used as the Alias of the Dimension table when the join between Information Source table and Dimension table is built. |
Zoom In Details | Indicates if zoom in details are specified inInformation Source Dimension - Detail Items. Note: By default the current Information Source always supports Zoom In to itself. Dimension details does not have to be defined but normally are. |
Drill Down Details | Indicates if drill down in details are specified in Information Source Dimension - Detail Items. Note: If the current Information Source can act as a drill down data source then the attribute can be selected. Else the attribute should not be selected. |
On Line Join Defined | Indicates if specific On Line join details have been defined between the Information Source and the dimension. |
Data Mart Join Defined | Indicates if specific Data Mart join details have been defined between the Information Source and the dimension. |
Writeback Supported | Indicates if writeback specific details exists for this connected dimension. |
For each connected dimension the following details can be defined:
Content¶
- Dimension Item Details
- Dimensions Identity Definitions
- Dimension Joins for each Access Type
- Write Back Dimension Itesm
Information Source Dimension - Detail Items¶
For each connected dimension it is possible to define the dimensions items that should be displayed when performing Zoom In or Drill Down, typically in IFS Business Reporter.
An overview of dimension detail items is available in the Information Source Detail Dimension Items section in the Information Source Dimension Details page.
The following information is available:
Attribute | Description |
---|---|
Dimension Item ID | Dimension item identity. Key |
Zoom In Display Item | Indicates if the dimension item should be displayed when generating Zoom In details |
Zoom In Display Order | Display order of Zoom In items in design controls and when presenting the Zoom In result in a new work sheet in Excel. Should be synchronized with Zoom In Display Order defined for Information Source Items. Dimension items start with 1 Information Source measure items start with 101 Information Source light items start with 201 |
Drill Down Display Item | Selected if the dimension item should be displayed when generating Drill Down details |
Drill Down Display Order | Display order of Drill Down items in design controls and when presenting Drill Down result in new work sheet in Excel. Should be synchronized with Drill Down Display Order defined for Information Source Items. Dimension items start with 1 Information Source items start with 101 Light fact items start with 2 |
Information Source Dimension - ID Definition Items¶
For each connected dimension it is important to define the items (attributes) that represent the natural keys in the fact, i.e. the items in the fact that are (or can be) used to build the dimension identity. This information is important in order to support creation of Access Views. These access views should be possible to create regardless off supported data access type, i.e. if On Line access is not supported it should still be possible to find out what columns that defines the key of a given dimension.
E.g. if a dimension has the keys Company and Year, also defining the dimension ID, then the items in the fact representing Company and Year should be described.
Expand the Information Source Dimension ID Definition Items section in the Information Source Dimension Details page.
Attribute | Description |
---|---|
Sequence No | Sequence number of item defining the dimension ID |
Information Source Item ID | Information Source item representing the Sequence No key/item |
Item Expression | This attribute only provides information, it is not used in any way. The attribute can be used to define how the item in the fact is converted when represented in a dimension ID string, e.g. TO_CHAR(<item_column>, 'YYYY-MM-DD') |
Information Source Dimension - Joins¶
Each Dimension connected to an Information Source has its own set of join definitions. The join information is defined per data access type, e.g. for On Line and/or Data Mart. However the most common scenario is to define join information for the Online case.
Expand either the Information Source Dimension On Line Join section or the Information Source Dimension Data Mart Join section in the Information Source Dimension Details page.
The following information is available:
Attribute | Description |
---|---|
Requested Data Access Type | Defines the data access type the information applies to. Can have one of the following values:
If e.g. Data Mart access is requested, it might still be so that On Line access is used depending on if Data Mart access is available for the Information Source. Requested in this context means the access type that will be used when a statement to fetch a data set is built. |
Exact Join | Indicates if the dimension identity can be exactly defined on each row in the Information Source. E.g. the values that refers to one row in the dimension are always available on every row in the transaction source. Exact join is technically known as inner join. A non-exact join always refers to what technically is called left outer join. |
Note: There can be only one entry per access type for on Information Source-Dimension connection.
Information Source Dimension - Join Items¶
By selecting the join type in either the Information Source Dimension On Line Join section or the Information Source Dimension Data Mart Join section in the Information Source Dimension Details page and then use the standard go-to-detail command/button, navigation to the Information Source Dimension Join page.
The page contains the join details for each data access type specific join. The join details are specified as a connection between a dimension item and an Information Source (fact) item.
E.g. the dimension DIM_ACCOUNT has an ID that is defined as company^account_code
, meaning that one line in the dimension is uniquely defined by the company and the account code. To define a join for DIM_ACCOUNT, two detail have to be specified:
- The company related item in DIM_ACCOUNT and the corresponding company item in the fact (Information Source).
- The account related item in DIM_ACCOUNT and the corresponding account item in the fact (Information Source).
The following information is available:
Attribute | Description |
---|---|
Information Source Dimension Join | |
Information Source ID | Identity of the Information Source. Parent key. |
Dimension ID | Dimension identity. Parent key |
Requested Data Access Type | Defines the data access type the information applies to. Key. Can have one of the following values:
|
Information Source Dimension Join Item | |
Join No | Join detail counter |
Dimension Item ID | Identity of the dimension item to be joined. |
Information Source Item ID | Identity if the Information Source (fact) item to be joined with the dimension item. |
Information Source Dimension - Write Back Dimension Items¶
For each connected dimension it is possible to define the dimensions items that are associated with the Write Back functionality in IFS Business Reporter. Each write back interface can handle a given number of items, either Information Source (Fact) items or Dimension items. The write back specific dimension items are defined as details to a dimension connected to an Information Source.
Expand the Information Source Dimension On Line Join section or the Information Source Dimension Data Mart Join section in the Information Source Dimension Details page.
The following information is available:
Attribute | Description |
---|---|
Dimension Item ID | Dimension item identity. Key |
Writeback Identity | Identity of the dimension item id that can be interpreted by the API that has the responsibility to process the write back data, e.g. an attribute name in a LU specific attribute string. |
Writeback Type | Specifies the requirements that the write back interface has on each item. The following values are supported:
|
Writeback Display Order | The display order of the item in the Write Back feature in IFS Business Reporter. Note: This this attribute should be synchronized with Write Back Display Order available for Information Source Items. |
Writeback Selectable | The attributes is not available for usage and will be deprecated |