<legend id="h4sia"></legend><samp id="h4sia"></samp>
<sup id="h4sia"></sup>
<mark id="h4sia"><del id="h4sia"></del></mark>

<p id="h4sia"><td id="h4sia"></td></p><track id="h4sia"></track>

<delect id="h4sia"></delect>
  • <input id="h4sia"><address id="h4sia"></address>

    <menuitem id="h4sia"></menuitem>

    1. <blockquote id="h4sia"><rt id="h4sia"></rt></blockquote>
      <wbr id="h4sia">
    2. <meter id="h4sia"></meter>

      <th id="h4sia"><center id="h4sia"><delect id="h4sia"></delect></center></th>
    3. <dl id="h4sia"></dl>
    4. <rp id="h4sia"><option id="h4sia"></option></rp>

        Page tree
        Skip to end of metadata
        Go to start of metadata

        针对在eazyBI中做好的报告,我们可以让第三方系统通过rest的这种方式进行调用 ,获得数据后进行按自己的业务计算,将报告显示在自己的环境中。

        接口

        /plugins/servlet/eazybi/accounts/2/export/report/119-06.json

        其中参数包括

        值说明
        accountid如示例的:2
        reportid如示例的:119-06
        format

        如:json

        格式支持:

        • csv
        • xls
        • json
        • pdf
        • png


        返回值

        {
            "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"
        }



        • No labels