针对在eazyBI中做好的报告,我们可以让第三方系统通过rest的这种方式进行调用 ,获得数据后进行按自己的业务计算,将报告显示在自己的环境中。
接口
其中参数包括
| 项 | 值说明 | 
|---|---|
| accountid | 如示例的:2 | 
| reportid | 如示例的:119-06 | 
| format | 如:json 格式支持: 
  | 
返回值
{
    "report_name":"Created vs resolved issues over time",
    "query_results":{
        "column_positions":[
            [
                {
                    "name":"Issues created",
                    "full_name":"[Measures].[Issues created]",
                    "depth":0,
                    "format_string":"#,##0",
                    "annotations":{
                        "predefined":"true"
                    }
                }
            ],
            [
                {
                    "name":"Issues resolved",
                    "full_name":"[Measures].[Issues resolved]",
                    "depth":0,
                    "format_string":"#,##0",
                    "annotations":{
                        "predefined":"true"
                    }
                }
            ],
            [
                {
                    "name":"Average resolution days",
                    "full_name":"[Measures].[Average resolution days]",
                    "depth":0,
                    "format_string":"#,##0.00",
                    "annotations":{
                        "group":"Default",
                        "predefined":"true"
                    },
                    "calculated":true
                }
            ],
            [
                {
                    "name":"Open issues",
                    "full_name":"[Measures].[Open issues]",
                    "depth":0,
                    "format_string":"#,##0",
                    "annotations":{
                        "group":"Default",
                        "predefined":"true"
                    },
                    "calculated":true
                }
            ]
        ],
        "row_positions":[
            [
                {
                    "name":"Apr 2020",
                    "full_name":"[Time].[2020].[Q2 2020].[Apr 2020]",
                    "drillable":true,
                    "depth":3,
                    "start_date":"2020-04-01"
                }
            ],
            [
                {
                    "name":"May 2020",
                    "full_name":"[Time].[2020].[Q2 2020].[May 2020]",
                    "drillable":true,
                    "depth":3,
                    "start_date":"2020-05-01"
                }
            ],
            [
                {
                    "name":"Jun 2020",
                    "full_name":"[Time].[2020].[Q2 2020].[Jun 2020]",
                    "drillable":true,
                    "depth":3,
                    "start_date":"2020-06-01"
                }
            ],
            [
                {
                    "name":"Jul 2020",
                    "full_name":"[Time].[2020].[Q3 2020].[Jul 2020]",
                    "drillable":true,
                    "depth":3,
                    "start_date":"2020-07-01"
                }
            ],
            [
                {
                    "name":"Aug 2020",
                    "full_name":"[Time].[2020].[Q3 2020].[Aug 2020]",
                    "drillable":true,
                    "depth":3,
                    "start_date":"2020-08-01"
                }
            ]
        ],
        "values":[
            [
                72,
                1,
                0.02,
                71
            ],
            [
                561,
                54,
                1.565925925925926,
                578
            ],
            [
                null,
                null,
                null,
                578
            ],
            [
                null,
                null,
                null,
                578
            ],
            [
                12,
                1,
                0,
                589
            ]
        ],
        "formatted_values":[
            [
                "72",
                "1",
                "0.02",
                "71"
            ],
            [
                "561",
                "54",
                "1.57",
                "578"
            ],
            [
                "",
                "",
                "",
                "578"
            ],
            [
                "",
                "",
                "",
                "578"
            ],
            [
                "12",
                "1",
                "0.00",
                "589"
            ]
        ]
    },
    "definition":{
        "columns":{
            "dimensions":[
                {
                    "name":"Measures",
                    "selected_set":[
                        "[Measures].[Issues created]",
                        "[Measures].[Issues resolved]",
                        "[Measures].[Average resolution days]",
                        "[Measures].[Open issues]"
                    ]
                }
            ]
        },
        "rows":{
            "dimensions":[
                {
                    "name":"Time",
                    "selected_set":[
                        "[Time].[Last 12 months]"
                    ],
                    "selected_set_expression":"DescendantsSet({{selected_set}}, [Time].[Month])"
                }
            ]
        },
        "pages":{
            "dimensions":[
                {
                    "name":"Time",
                    "current_page_members":[
                        "[Time].[Last 12 months]"
                    ],
                    "members":[
                        {
                            "full_name":"[Time].[Last 12 months]",
                            "name":"Last 12 months"
                        }
                    ],
                    "selected_set":[
                        "[Time].[All Times]",
                        "[Time].[Last 12 months]",
                        "[Time].[Current year]",
                        "[Time].[Previous year]"
                    ],
                    "duplicate":true
                },
                {
                    "name":"Project",
                    "selected_set":[
                        "[Project].DefaultMember"
                    ]
                },
                {
                    "name":"Issue Type",
                    "selected_set":[
                        "[Issue Type].DefaultMember"
                    ]
                },
                {
                    "name":"Priority",
                    "selected_set":[
                        "[Priority].DefaultMember"
                    ]
                },
                {
                    "name":"Assignee",
                    "selected_set":[
                        "[Assignee].DefaultMember"
                    ]
                }
            ]
        },
        "options":{
        },
        "view":{
            "current":"line_chart",
            "line_chart":{
                "area":false,
                "swap_axes":false,
                "series_options":{
                    "Issues created":{
                        "type":"column",
                        "color":"#B31238"
                    },
                    "Issues resolved":{
                        "type":"column",
                        "color":"#00875A"
                    },
                    "Average resolution days":{
                        "separateAxis":true,
                        "color":"#274380",
                        "type":"spline"
                    },
                    "Open issues":{
                        "separateAxis":true,
                        "color":"#F24B13",
                        "type":"spline"
                    }
                },
                "y_axis":{
                    "1":{
                        "labelSuffix":" days"
                    }
                }
            }
        }
    },
    "cube_name":"Issues",
    "last_import_at":"2020-08-12T19:00:06.000Z"
}