I have a custom cube of data that has pipeline names with some test code coverage data. Each day, another row for each pipeline gets added to the cube with the latest code coverage data. What I would like to display is the latest code coverage (by date) for each pipeline. Currently, though, my report is summing up all the code coverage data per pipeline, which isn’t what I want. Below is my report definition:
{
"cube_name": "Unit Test Coverage",
"cube_reports": [ {
"name": "Unit Test Coverage Per Repo",
"folder_name": "2021 Engineering OKRs",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Coverable lines]","[Measures].[Covered lines]","[Measures].[Coverage %]"],"members":null}]},"rows":{"dimensions":[{"name":"Pipeline name","selected_set":["[Pipeline name].[All Pipeline names]"],"members":[{"depth":0,"name":"All Pipeline names","full_name":"[Pipeline name].[All Pipeline names]","drillable":true,"type":"all","expanded":true,"drilled_into":false}],"bookmarked_members":null}]},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[All Times]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time].[All Times]","drillable":true,"type":"all"}],"bookmarked_members":null,"current_page_members":["[Time].[All Times]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{}},"calculated_members":null}
} ],
"calculated_members": [{"name":"Coverage %","dimension":"Measures","formula":"CASE WHEN\n [Measures].[Coverable lines] = 0\nTHEN\n 0\nELSE\n [Measures].[Covered lines] / [Measures].[Coverable lines]\nEND","format_string":"#0.00%"}]
}
Thanks!