Implementation
The extensibility implementation is a combination of functionality implemented in the HCM-Model-Extension space and other HR Talent Analytics spaces. Before implementation, take these rules into consideration:
- You are the owner of the HR-Model-Extension space. This space is not updated during an update of the HR Talent Analytics.
- In the HR-Model-Extension space, you are responsible to fill custom attributes for a specific dimension using Birst ETL. This also includes, for example, incrementally loading HR Custom Defined Fields (CDF) from Data Lake. To automatically load the custom attributes into the data warehouse, the custom attributes must be populated into the Extensibility dimension using the pre-defined format.
- HR-Model-Extension space contains the Extension dimension, which is used by the extensibility logic.
- All Extension Source scripts populate a single Birst hierarchy: HCMDimensionExstension.
- The Level Key columns of this hierarchy is Business Class Key and Business Class. This hierarchy has the fields shown in the table:
Column | Data Type | Description | Notes |
---|---|---|---|
Business Class Key | Varchar(100) | Business Class Key. The population logic of these fields is handles in the respective source scripts. | Populated from all of the extensibility scripts. |
Business Class | Varchar(50) | Business Class. The population logic of these fields is handles in the respective source scripts. | Populated from all of the extensibility scripts. |
Level Key 1 to Level Key 5 | Varchar(100) | Columns that should contain the exact matching values of the Level Key column of the dimension. To be future proof five level key columns are added. | Populated only from the JobRequistionCostExtension script. |
CDF Date01 to CDF Date05 | Date | The five date columns that you can fill for a dimension. | Populated from all of the extensibility scripts. |
CDF DateTime 01 to CDF DateTime 05 | DateTime | The five datetime columns that you can fill for a dimension. | Populated from all of the extensibility scripts. |
CDF Float 01 to CDF Float 05 | Number | The five float columns that you can fill for a dimension. | Populated from all of the extensibility scripts. |
CDF Integer 01 to CDF Integer 15 | Integer | The fifteen integer columns that you can fill for a dimension. | Populated from all of the extensibility scripts. |
CDF String 01 to CDF String 40 | Varchar(300) | The fourty string columns that you can fill for a dimension. | Populated from all of the extensibility scripts. |
LastModified | DateTime | This column is used for incremental extraction of the extensibility data. The logic for the incremental extraction dateitme is defined in the script Process - variables - InforHCM. | Populated from all of the extensibility scripts. |
The HCM Extension Package is created and have the HCMDimensionExtension hierarchy. This package is consumed into the HR-Source space where the corresponding sources are extended by joining to the HCMDimensionExtension. This process is implemented in the respective scripts for the corresponding source.
Note: You are responsible to fill the
Extensibility Dimension with the correct data, so the data is extracted by the extensibility
related scripts in the other HR spaces. See Table of Extension Source Attributes .