A place for Apptio product users to learn, connect, share and grow together.
♦ Applies to: Apptio Cost Transparency or Apptio Cloud Cost Management running on TBM Studio v12.3.3 to 12.5.x
The Daily Transparency report provides a view into your AWS spend as of the current point in time and allows drilling into a fine grain of cost detail down to the hourly level. This report is fed by the AWS Detailed Billing Report with Resources and Tags (DBR) and is updated on a daily basis.
The Daily Transparency report integrates the AWS Cost and Usage Report (CUR) and the Enterprise Agreement (EA) billing APIs for Azure.
Note: All costs are sourced from the UnblendedCost in the AWS DBR and does not include most monthly line items such as tax or enterprise support. It does include Reserved Instance purchase costs for those hours where Reserved Instances were utilized.
This article is open for your feedback. At the bottom of this page, click Add a comment.
@John Feore Great info John! I was looking for how to use the function to convert time into a different time zone. thank you!
good information
Thanks John, this is great info.
Rick,
With the default dbr processing you cannot 'see' the data as it is not available but you can using the Advanced Report type (in DataLink) download the data behind the report and create your own view. As I have been asking for the same info for 6 months now and had to create the Advanced download, by nominating the full file name (you can find this in the AWS billing console with the name of xxxxxx-aws-billing-detailed-line-items-with-resources-and-tags-2018-04.csv.zip, where xxxxxx is your account number) and then creating my own reporting.
Then you have the raw file behind the dbr processing and you can report at time of day / server / or any of the other tags your organisation might use. Be careful as the file can be very large but with a bit of effort you can get some interesting info. eg I added code to be able to compare working day to weekend by tags, to verify usage by time.
The one thing to be careful of is the timeshift, unless you are East Coast USA, but Apptio has a great timeshift feature at https://tbmcouncil.jiveon.com/docs/DOC-5004 where the Converted Time =DateFormat(Date With Timezone,"M/dd/yy HH:mm z","AET","M/dd/yy HH:mm z") that will move the times to local / nominated times. As in Australia the peak periods of usage were in the middle of the night due to difference in the time in the AWS file versus local times, so the conversion allowed us to see the data in hourly views, but as local date & time.
John Feore
I'm not able to see the server level information on the daily transaction feed. I was told that the data is being held by Apptio and not pushed to the reporting view. The hourly detail by server is what will allow actionable tasks to reduce costs. Currently, all I can do is see that I have a lot of usage on an hourly basis. I need the "Linked account name" so I know product usage and then drill into that level to see the servers that are up each hour. @Randall Tennant
^^What he said
When will this report be available for Azure data?
Very basic explanation and description says you can drill down to hourly, while that is in the file it does not appear to be able to be shown on the report...