Apptio for All

 View Only

 Table Report column headers not displaying

Jump to  Best Answer
  • ApptioforAll
Dawn Kassube's profile image
Dawn Kassube posted 11/10/21 04:37 PM
I have a subtotalled report where the Metric Value column headers are not displaying.  See below and attached:
I am baffled-and-bemused and cannot figure out why.  Any help would be greatly appreciated.

Here is the Full Data Path:
us.qbe.com:_.r.Cost Transparency_{QBE Non-SQL Database}_1636640844773/
Reports/
.DateGoesHere/
CostModels/
Default/
.View:SQL Database/
.View:QBE Non-SQL Database/
QBE Non SQL DB/
.WithDefaultMetric-Cost/
.DrillTo/
Mainframes/
!GROUPBY[{QBE Non SQL DB.SOURCE_OBJECT},{Mainframes.Mainframes Master Data.ITBM Source Object}]/
!NEWCOLUMN[{Cost}=Rollup Value][FORMAT=Rollup Value]/
!NEWCOLUMN[{Budget}=Budget.Rollup Value][FORMAT=Budget.Rollup Value]/
.AssignmentRatios[][Budget]/
!NEWCOLUMN[{Weighting Percent}=Mainframes.Mainframes Master Data.Weighting Percent]/
!ALL_ROWS[Jan:FY2020->Dec:FY2021]/
!NEWCOLUMN[{Budget Variance}=Budget-Cost][=Currency({$_},"#,###")]/
!NEWCOLUMN[{Cost YTD}=YearToDate(Cost)][=Currency({$_},"#,##0")]/
!NEWCOLUMN[{Budget YTD}=YearToDate(Budget)][=Currency({$_},"#,##0")]/
!NEWCOLUMN[{Budget Variance YTD}=Budget YTD-Cost YTD][=Currency({$_},"#,###")]/
!NEWCOLUMN[{LTM Cost}=PreviousYear(Cost)][=Currency($_)]/
!NEWCOLUMN[{LTM Budget}=PreviousYear(Budget)][=Currency($_)]/
!NEWCOLUMN[{LTM Variance}=LTM Budget-LTM Cost][=Currency({$_},"#,##0")][canSum,numeric]/
!FILTER_ZERO[{Rollup Value},{Budget.Rollup Value},{Budget Variance},{Cost YTD},{Budget YTD},{Budget Variance YTD},{LTM Cost},{LTM Budget},{LTM Variance}]/
!SUBTOTAL[{QBE Non SQL DB.SOURCE_OBJECT}][{Mainframes.Mainframes Master Data.ITBM Source Object}][{Cost YTD}|desc]/
!LIMIT[0,1000,add_total]/
!LIMIT_COLUMNS[{QBE Non SQL DB.SOURCE_OBJECT},{Mainframes.Mainframes Master Data.ITBM Source Object},{Weighting Percent},{Cost},{Budget},{Budget Variance},{Cost YTD},{Budget YTD},{Budget Variance YTD},{LTM Cost},{LTM Budget},{LTM Variance}][{Group}][][orderByIncludeList]/

Thank you,
#ApptioforAll
Attachment  View in library
Missing Column Headers.JPG 55 KB
Debbie Hagen's profile image
Debbie Hagen posted 11/15/21 01:41 PM  Best Answer
Hi @Dawn Kassube,
I don't think I've seen that issue before.  For troubleshooting I think it should go to someone who can access your environment so I'd recommend submitting a Support ticket. Our support team and get in there an take a look and see if they can troubleshoot the issue.

Kind regards,
Debbie​
#ApptioforAll
Jenny Franklin's profile image
Jenny Franklin posted 11/10/21 05:51 PM
Commenting for additional visibility!
#ApptioforAll
Justin Hazelrigg's profile image
Justin Hazelrigg posted 11/16/21 01:58 PM
Looking at a similar datapath for a report we have it looks like you are missing the label piece for each of the NEWCOLUMN lines try adding [label] just before the "/"


!NEWCOLUMN[{ }=][=NumberFormat({$_},"#,###.00")][label]/
#ApptioforAll
Dawn Kassube's profile image
Dawn Kassube posted 11/16/21 05:52 PM
Hello,

I am unable to Edit Path and I looked at my other reports setup the same way which properly display the Column Headers and they do not have  [label] just before the "/".

Thank you,
#ApptioforAll

Related Content