Our team was discussing Friday what information we should be putting in to our Data Quality Dimensions in CT (i.e. Cost Source Validity, Labor Validity, Vendor Validity, etc.)  We have two questions:

1.  When entering data into the validity templates, is each column considered separately?  i.e. If we have the following:

will this tell the system that only where Account=145001, CC=72650, Cost Sub Pool=Cloud Service Providers, etc it will be true?  Or will it account for each column separately (all accounts are valid, all cost center are valid, etc.)?

2.  Am I right to assume that Labor and Projects Validity need to be updated regularly?  It seems that their detail is very granular.  It asks for Project Numbers and Projects Names (new ones are added all the time) and Labor IDs (each employee has a different ID and turnover happens on a regular basis).

Any insight would be appreciated!

Thanks!

Hi Molly,

Great questions!

1. Each column is considered separately. If you right click on the KPI and click 'Show Full Data Path' you'll see the following (this is just an example from data centers):

Essentially, Apptio does a bunch of lookups from the 'Validity' datasets (on a column by column basis) to the corresponding column in the Master Data. If it finds a match, it considers it valid, else invalid. 

2. Yes, you are right on. If you are wanting to leverage the 'validity' functionality in Data Dimensions, it does require some frequent updating. I would also recommend updating the following (depending on their volatility month over month): Servers, Vendors, Cost.

Hope that helps,

Justin Zack

Thanks, Justin!  I really appreciate it!