Apptio for All

 View Only

 Creating report from table

Jump to  Best Answer
  • ApptioforAll
Apptio Community Member's profile image
Apptio Community Member posted 04/20/22 03:39 PM
Hello Apptio Community.  I am looking to take a final output table (raw, not modeled) and provide as a report for end user.  Can anyone provide direction on how to do this in Apptio Cost Transparency (version 12.9.13)?
#ApptioforAll
Jenny Franklin's profile image
Jenny Franklin posted 04/20/22 03:46 PM  Best Answer

You can add a Model step to the end of the transform pipeline to make the data available on the reporting surface, and then you can create a report using the data from that table.
#ApptioforAll
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 04/21/22 02:23 AM
Like @Jenny Franklin wrote, we need a Model step to be able to build a report.
Not sure what you mean by "raw, not modeled"​ table, @Jennifer Osage, but there is no way around ​adding the Model step that I know of.

Just add the Model step to the pipeline and please remember to create an Object ID with whatever granularity is required for the report.

I know this sounds a bit cryptic, but say you want to create a report on a specific type of devices you have in a raw table other than Servers Master Data, and that your requirement is to report by category. In the Object ID you could enter the column for the category, as opposed to the device ID. This will help contain calculation times (thanks to @Gulcin Menekse for her writings on sparseness, and for hammering the concept into my thick skull 👀👀👀❤❤❤).​
#ApptioforAll

Related Content