A place for Apptio product users to learn, connect, share and grow together.
The Azure Summary report downloaded by the Azure Datalink connector has a different column name every month.. As a result the Datalink validation step will fail due to the different column name unless it is disabled.
The validation can be disabled in the connector settings by unchecking the Validation box.
A dynamic solution for R11 and R12 can be found in:
https://tbmcouncil.jiveon.com/docs/DOC-8479?commentID=13649#comment-13649
One approach to dealing with the dynamic schema (a different column header for each month) in the EA summary bill is to create a new column with a formula that will equal data for any source column named after a month of the year Here's a brief set of steps:
1. Create a transform of the Azure EA summary bill
2. Add a new column called something like, "Current Month Metric"
3. The formula for that column will be: =January&&February&&March&&April&&May&&June&&July&&August&&September&&October&&November&&December
4. Now, the Current Month Metric column will have the same data as the dynamically-named month column for every month of the year.