Hi All,

Please let me know if it is possible to get the last upload date and name of the upload in the cost transparency for the reporting purpose.

Appreciate your help.

Thank you,

Chenna.

Hi @Chennappa Muddammagari,

This will help for the date: https://help.apptio.com/en-us/studio/formulas-and-functions/functions/tableinfo.htm.

I would probably just use or copy/paste the existing Data Quality report, though.

You can search for the report here...

This shows the information you need...

You can then use this report or copy/paste into a new one...

This is a legacy type reporting table, though, and not something that uses the Ad Hoc Configuration window where you drag/drop columns, so you would need to choose new columns using the Data ribbon...

Hi All,

Please let me know if it is possible to get the last upload date and name of the upload in the cost transparency for the reporting purpose.

Appreciate your help.

Thank you,

Chenna.

Hi All,

Please let me know if it is possible to get the last upload date and name of the upload in the cost transparency for the reporting purpose.

Appreciate your help.

Thank you,

Chenna.

Hi @Chennappa Muddammagari,

We have applied a more custom view to a similar need within our model.  In the transformation table (where the file is being uploaded), we have added two formula columns to get the data upload date/time and file name.

Load Date=DateFormat(TableInfo("Last Updated"), "MM/dd/yyyy HH:mm:ss")

Input File =Source

Hi All,

Please let me know if it is possible to get the last upload date and name of the upload in the cost transparency for the reporting purpose.

Appreciate your help.

Thank you,

Chenna.