Dimension-Extension space

The extensibility implementation is a combination of functionality implemented in the Dimension-Extension space and other Service Management Analytics spaces. The Extension Space Package is provided with the Service Management Analytics content and includes all extended sources' hierarchies. This package is consumed into all the Service Management Analytics model and conformed spaces where the corresponding sources are extended by joining to the respective hierarchy. This process is implemented in the respective scripts for the corresponding source.

Before implementation, take these rules into consideration:
  • As the user, you are the owner of the Dimension-Extension space. The Dimension-Extension space is not updated during an update of the Service Management Analytics content.
  • In the Dimension-Extension space, you are responsible for filling custom attributes for a specific dimension using Birst ETL. This also includes, for example, incrementally loading Custom Defined Fields (CDF) from Data Lake or your data source. 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.
  • The Dimension-Extension space contains the Extended dimensions, which are used by the extensibility logic. Extension Source scripts have their own separate Birst hierarchy based on multiple primary keys.

This table shows the fields contained within these hierarchies and the format of extension scripts.

Column Data Type Description
CDF Date 01 to CDF Date 03 Date (10) The five date columns that you can fill for a dimension
CDF DateTime 01 to CDFDateTime 02 DateTime (29) The three datetime columns thatyou can fill for a dimension
CDF Float 01 to CDF Float 10 Float (19) The fifteen float columns that you can fill for a dimension
CDF Integer 01 to CDF Integer10 Integer (20) The ten integer columns that you can fill for a dimension
CDF Varchar 01 to CDF Varchar 15 Varchar (100) The thirty string columns that you can fill for a dimension
Note: You are responsible for filling the Extensibility Dimension with the correct data, so that the data is extracted by the extensibility related scripts in the other Service Management Analytics spaces.