2.01-13 Separate Transaction data from Attribute/Property data

Keep the non-time-based data in a separate module from static attributes

 

Best Practice article:
Data Hubs Purpose and Peak Performance

0 Kudos
Comments

Rule 2.01-13 Separate Transaction Data from Attribute/Property Data. Keep the non-time based data in a separate module from static attributes. It goes against NECESSARY element of PLANS if you wish to go against the rule

Here is how it was done in Pre Planual Era: Even after best practices on Data Hub we still used to accept the unique key and load as is from the source system without analyzing the components of the key.  Remember there are 4 Corner Stones and Data is one among the largest piece of the puzzle. Hence spend good amount of time in analyzing the data. Here is the unique key which gets loaded into the system.

Misbah_0-1589888342442.png

What is wrong with this method? It looks like a prefect key to be loaded into Anaplan as there are no time periods in the key, there are proper delimiters, no duplicates etc. But if you look at the key closely it might not be the ideal key to be loaded as is into Anaplan as there can be attributes as well which do not change with time. In the below key Segment is an attribute of Customer

Misbah_1-1589888342455.png

Here is how it should be done in Planual Way: Understand the source data and the unique key carefully and see if the key contains any attribute which doesn’t change with time and follow the steps

Step 1: Create an attribute module within Anaplan and store the mappings between the two as one time activity

Misbah_2-1589888342464.png

Step 2: Load the key without Segment Part of it. Here is the ideal key to load into Anaplan

Misbah_3-1589888342469.png

Step 3: Create a SYS module to extract all components of the Key and reference Segment (Step 1)

Misbah_4-1589888342486.png

Step 4: In the Data module just reference Segment & Other Attributes from Attribute Module and create a view to be sent to spoke model

Misbah_5-1589888342501.png

 

Version history
Last update:
‎11-06-2020 11:16 AM
Updated by:
About the Author
Labels (4)