Tempo Planner Report Examples

The following report examples are based on Tempo Planner integration. To copy these reports to your own eazyBI accounts to use with your Tempo data, see how to export and import report definitions.

Team Hours Weekly Accountability Report

 Click here to see report definition...

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Team Hours Weekly Accountability Report",
"folder_name": "Samples Tempo",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Hours spent]"],"members":[]},{"name":"Time","selected_set":["[Time.Weekly].[All Times]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Time.Weekly].[Week])","members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Logged by Team","selected_set":["[Logged by Team].[All Logged by Teams]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Logged by Team].[Logged by Team])","members":[],"bookmarked_members":[]},{"name":"Logged by","selected_set":["[Logged by].[All Users]"],"members":[{"depth":0,"name":"All Users","full_name":"[Logged by].[All Users]","drillable":true,"type":"all","expanded":true,"drilled_into":false}],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Time","duplicate":true,"selected_set":["[Time.Weekly].[Current week]","[Time.Weekly].[Last 4 weeks]","[Time.Weekly].[All Times]","[Time.Weekly].[Previous week]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time.Weekly].[All Times]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Time.Weekly].[All Times]"]},{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Project].[All Projects]"]},{"name":"Issue Type","selected_set":["[Issue Type].[All Issue Types]"],"members":[{"depth":0,"name":"All Issue Types","full_name":"[Issue Type].[All Issue Types]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[All Issue Types]"]},{"name":"Logged by","duplicate":true,"selected_set":["[Logged by].[All Users]"],"members":[{"depth":0,"name":"All Users","full_name":"[Logged by].[All Users]","drillable":true,"type":"all","expanded":false,"drilled_into":false}],"bookmarked_members":[],"current_page_members":["[Logged by].[All Users]"]},{"name":"Logged by Team","duplicate":true,"selected_set":["[Logged by Team].[All Logged by Teams]"],"members":[{"depth":0,"name":"All Logged by Teams","full_name":"[Logged by Team].[All Logged by Teams]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Logged by Team].[All Logged by Teams]"]}]},"options":{"nonempty":true,"total":"rows"},"view":{"current":"table","maximized":false,"table":{"row_dimension_headers":{"Logged by":true,"Logged by Team":true},"cell_formatting":{"[Logged by].[All Users]":[{"background_color":"#EBECF0","text_color":"#2F579C"}]},"freeze_header":true}},"calculated_members":[]}
} ],
"calculated_members": [{"dimension":"Time","name":"Current week","format_string":"","formula":"Aggregate({\n [Time.Weekly].[Week].CurrentDateMember\n})","dimension_hierarchy":"Weekly"},{"dimension":"Time","name":"Previous week","format_string":"","formula":"Aggregate({\n [Time.Weekly].[Week].CurrentDateMember.PrevMember\n})","dimension_hierarchy":"Weekly"},{"dimension":"Time","name":"Last 4 weeks","format_string":"","formula":"Aggregate(\n [Time.Weekly].[Week].DateMembersBetween('4 weeks ago', 'today')\n)","dimension_hierarchy":"Weekly"}]
}


Tempo Hours Planned vs Hours Spent

 Click here to see report definition...

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Tempo Hours Planned vs. Hours Spent",
"folder_name": "Samples Tempo",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Tempo planned hours]","[Measures].[Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time].[All Times]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Time].[Month])","members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Logged by Team","selected_set":["[Logged by Team].[All Logged by Teams]"],"members":[{"depth":0,"name":"All Logged by Teams","full_name":"[Logged by Team].[All Logged by Teams]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Logged by Team].[All Logged by Teams]"]},{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Project].[All Projects]"]},{"name":"Time","duplicate":true,"selected_set":["[Time].[All Times]","[Time].[Last 12 months]","[Time].[Current year]","[Time].[Previous year]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time].[All Times]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Time].[All Times]"]},{"name":"Account","selected_set":["[Account].[All Accounts]"],"members":[{"depth":0,"name":"All Accounts","full_name":"[Account].[All Accounts]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Account].[All Accounts]"]}]},"options":{"nonempty":true},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{"Hours spent":{"dataLabelType":"top horizontal","color":"#9043C2"},"Tempo planned hours":{"dataLabelType":"top horizontal"}}},"table":{}},"calculated_members":[]}
} ],
"calculated_members": [{"dimension":"Time","name":"Last 12 months","format_string":"","formula":"Aggregate(\n [Time].[Month].DateMembersBetween('12 months ago', 'today')\n)"},{"dimension":"Time","name":"Current year","format_string":"","formula":"Aggregate({\n [Time].[Year].CurrentDateMember\n})"},{"dimension":"Time","name":"Previous year","format_string":"","formula":"Aggregate({\n [Time].[Year].CurrentDateMember.PrevMember\n})"}]
}


Gantt Chart for Project Planning & Progress

 Click here to see report definition...

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Gantt Chart for Project Planning \u0026 Progress",
"folder_name": "Samples Tempo",
"result_view": "gantt_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Tempo planned hours]","[Measures].[Progress %]","[Measures].[Planning start]","[Measures].[Planning end]","[Measures].[Hours spent]"],"members":[{"depth":0,"full_name":"[Measures].[Progress %]","format_string":"#0.00%","report_specific":true,"name":"Progress %","calculated":true},{"depth":0,"full_name":"[Measures].[Planning start]","format_string":"mmm dd yyyy","report_specific":true,"name":"Planning start","calculated":true},{"depth":0,"full_name":"[Measures].[Planning end]","format_string":"mmm dd yyyy","report_specific":true,"name":"Planning end","calculated":true}]}]},"rows":{"dimensions":[{"name":"Issue","selected_set":["[Issue].[Project].Members"],"members":[{"depth":1,"name":"Open Library","full_name":"[Issue].[Open Library]","drillable":true,"key":"OL","expanded":true,"drilled_into":false}],"bookmarked_members":[]}],"filter_by":{"conditions":[{"expression":["[Measures].[Tempo planned hours]"],"operator":"\u003e","value":"0"}]},"nonempty_crossjoin":true},"pages":{"dimensions":[]},"options":{},"view":{"current":"gantt_chart","maximized":false,"gantt_chart":{"show_key":["Issue"],"left_width":[234.6,200.99375],"timescale":"weekly"},"table":{}},"calculated_members":[{"dimension":"Measures","name":"Planning start","formula":"Filter(\n [Time].[Day].Members,\n ([Time].CurrentHierarchyMember,\n [Measures].[Tempo planned hours])\u003e0\n).Item (0).StartDate","format_string":"mmm dd yyyy"},{"dimension":"Measures","name":"Planning end","formula":"Order(Filter(\n [Time].[Day].Members,\n ([Time].CurrentHierarchyMember,\n [Measures].[Tempo planned hours])\u003e0\n),\n[Time].CurrentHierarchyMember.StartDate,\nBDESC\n).Item (0).StartDate","format_string":"mmm dd yyyy"},{"dimension":"Measures","name":"Progress %","formula":"\n[Measures].[Hours spent]\n/\n[Measures].[Tempo planned hours]\n","format_string":"#0.00%"}]}
} ],
"calculated_members": []
}


Planned Assigned Hours vs Contribution

 Click here to see report definition...

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Planned Assigned Hours vs. Contribution",
"folder_name": "Samples Tempo",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Tempo planned hours]","[Measures].[Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Logged by","selected_set":["[Logged by].[User].Members"],"members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Open Library","full_name":"[Project].[Open Library]","drillable":true,"key":"OL","parent_full_name":"[Project].[All Projects]"}],"bookmarked_members":[],"current_page_members":["[Project].[Open Library]"]},{"name":"Fix Version","selected_set":["[Fix Version].[All Fix Versions]"],"members":[{"depth":0,"name":"All Fix Versions","full_name":"[Fix Version].[All Fix Versions]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Open Library","full_name":"[Fix Version].[Open Library]","drillable":true,"key":"OL","expanded":true,"drilled_into":false,"parent_full_name":"[Fix Version].[All Fix Versions]"},{"depth":2,"name":"Released","full_name":"[Fix Version].[Open Library].[Released]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Fix Version].[Open Library]"},{"depth":3,"name":"Version 1.0","full_name":"[Fix Version].[Open Library].[Released].[Version 1.0]","url_id":11400,"parent_key":"OL","parent_full_name":"[Fix Version].[Open Library].[Released]"},{"depth":2,"name":"Unreleased","full_name":"[Fix Version].[Open Library].[Unreleased]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Fix Version].[Open Library]"},{"depth":3,"name":"Version 2.0","full_name":"[Fix Version].[Open Library].[Unreleased].[Version 2.0]","url_id":11401,"parent_key":"OL","parent_full_name":"[Fix Version].[Open Library].[Unreleased]"}],"bookmarked_members":[],"current_page_members":["[Fix Version].[Open Library].[Released].[Version 1.0]","[Fix Version].[Open Library].[Unreleased].[Version 2.0]"]},{"name":"Issue Type","selected_set":["[Issue Type].[All Issue Types]"],"members":[{"depth":0,"name":"All Issue Types","full_name":"[Issue Type].[All Issue Types]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[All Issue Types]"]},{"name":"Time","selected_set":["[Time].[All Times]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time].[All Times]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Time].[All Times]"]}]},"options":{"nonempty":"rows"},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{"Tempo planned hours":{"type":"column","dataLabelType":"top horizontal"},"Hours spent":{"type":"column","color":"#9043C2","dataLabelType":"top horizontal"}}},"table":{}},"calculated_members":[]}
} ],
"calculated_members": []
}


Project Flow Burn-Up Chart

 Click here to see report definition...

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Project Flow Burn-Up Chart",
"folder_name": "Samples Tempo",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Hours spent cumulative]","[Measures].[Hours spent]","[Measures].[Total planned hours]","[Measures].[Cumulative Tempo planned hours]","[Measures].[Current period]"],"members":[{"depth":0,"full_name":"[Measures].[Hours spent cumulative]","format_string":"#,##0.00","report_specific":true,"name":"Hours spent cumulative","calculated":true},{"depth":0,"full_name":"[Measures].[Total planned hours]","format_string":"#,##0.00","report_specific":true,"name":"Total planned hours","calculated":true},{"depth":0,"name":"Cumulative Tempo planned hours","full_name":"[Measures].[Cumulative Tempo planned hours]","drillable":false,"calculation_of":"[Measures].[Tempo planned hours]","calculation":"cumulative_sum","format_string":"#,##0.00"},{"depth":0,"full_name":"[Measures].[Current period]","format_string":"","report_specific":true,"name":"Current period","calculated":true,"id":"[Measures].[Current period]"}]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time.Weekly].[Week].Members"],"members":[],"bookmarked_members":[]}],"filter_by":{"conditions":[{"expression":["[Measures].[Tempo planned hours]"],"operator":"\u003e","value":"0"}]}},"pages":{"dimensions":[{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Project].[All Projects]"]}]},"options":{},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{"Hours budget control":{"type":"line","color":"#D4153B","symbol":false},"Hours spent":{"color":"#376BB7"},"Total planned hours":{"type":"line-Dash","symbol":false},"Tempo planned hours":{"type":"line"},"Cumulative Hours spent":{"color":"#B3D4FF"},"Cumulative Tempo planned hours":{"color":"#9043C2","type":"line"},"Current week":{"type":"plotline","dataLabelType":"top vertical"},"Current period":{"type":"plotline","dataLabelType":"top vertical"},"Hours spent cumulative":{"type":"area","color":"#7CA7E5"}}},"table":{}},"calculated_members":[{"dimension":"Measures","name":"Total planned hours","formula":"([Measures].[Tempo planned hours],\n[Time].CurrentHierarchy.DefaultMember)","format_string":""},{"dimension":"Measures","name":"Current period","formula":"CASE WHEN\nDateInPeriod(Now(),[Time].CurrentHierarchyMember)\nTHEN\n\"Current period\"\nEND","format_string":""},{"dimension":"Measures","name":"Hours spent cumulative","formula":"CASE WHEN\nDateAfterPeriodEnd(Now(),\n[Time].CurrentHierarchyMember.PrevMember)\nTHEN\nSum(\n {PreviousPeriods([Time].CurrentHierarchyMember),\n [Time].CurrentHierarchyMember},\n [Measures].[Hours spent]\n)\nEND","format_string":""}]}
} ],
"calculated_members": []
}



Weekly Hours Spent by Issue Type

 Click here to see report definition...

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Weekly Hours Spent by Issue Type",
"folder_name": "Samples Tempo",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Issue Type","selected_set":["[Issue Type].[Issue Type].Members"],"members":[],"bookmarked_members":[]},{"name":"Measures","selected_set":["[Measures].[Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time.Weekly].[Week].Members"],"members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[]},"options":{"nonempty":true},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{}},"table":{}},"calculated_members":[]}
} ],
"calculated_members": []
}


Planned vs Spent Hours by Issue Resolution

 Click here to see report definition...

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Planned vs Spent Hours by Issue Resolution",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Resolution","selected_set":["[Resolution].[Resolution].Members"],"members":[],"bookmarked_members":[]},{"name":"Measures","selected_set":["[Measures].[Tempo planned hours]","[Measures].[Hours spent]"],"members":[]}]},"rows":{"dimensions":[{"name":"Issue","selected_set":["[Issue].[Issue].Members"],"members":[],"bookmarked_members":[]}],"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[All Times]","[Time].[Current month]"],"members":[{"depth":0,"name":"Current month","full_name":"[Time].[Current month]","annotations":{"group":"Default","predefined":"true"},"calculated":true,"drillable":true,"dimension":"Time"}],"bookmarked_members":[],"current_page_members":["[Time].[Current month]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{}},"calculated_members":[]}
} ],
"calculated_members": [{"dimension":"Time","name":"Current month","format_string":"","formula":"Aggregate({\n [Time].[Month].CurrentDateMember\n})"}]
}