Data Map "Data Type" Definition and Configuration

The data map "data types" explicitly cast the data matriculating through the data pipeline to match the appropriate BPC structure.  There are three (3) data types in BPMC, these are  defined as such:

• Dimension Data Type default is SQL Server NVARCHAR(20), matches BPC dimensions
• Measure Data Type default is SQL Server DECIMAL (25, 10), matches BPC measures
• Natural Type is not cast, meaning the data map leaves the data in its natural state

The definition of these data types are set in the global configurations. Here is an example of how these data types are configured.

Its is not recommended to change these defaults, as these explicitly match BPC, thus providing proper referential integrity when loading data in the fact tables.