业务实体服务指南

10.4 HotFix 2
- 10.4 HotFix 3
- 10.4
- 10.3 HotFix 1
- 10.3
- 10.2 HotFix 1
- 10.2

上一个下一个

管理自定义报告和向下钻取报告

注册要使用的自定义报告，并将数据条目添加到报告中。然后注册向下钻取报告，并将数据条目添加到向下钻取报告。在根报告中添加或更新数据条目时，可以将向下钻取报告与数据条目相关联。然后您可以在置备工具中使用报告数据填充图表组件，并将根图表链接到向下钻取图表。

在开始之前，请确定要收集的数据。此外，还要确定要配置的向下钻取报告，并将其关联到自定义报告中的数据条目。

要检查已注册的报告，请使用列出报告 REST API。

例如，以下请求可列出注册的根报告和向下钻取报告：

GET http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/list?show=all

要注册自定义报告，请使用注册报告 REST API。

例如，以下请求注册了一个自定义报告：

POST http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/list
{
  "DIMENSION_NAME_1": "Task Priority",
  "DIMENSION_NAME_2": "Task Type",
  "TIMEPERIOD_NAME": "null",
  "RPT_NAME": "Task Priority/Type Report",
  "RPT_DESC": "Metrics for task status/type",
  "METRIC_NAME": "Number of tasks"
 }

以下示例响应显示了已注册的报告：

{
  "ROWID_RPT_CONFIG": "SVR1.2X9N0",
  "DIMENSION_NAME_1": "Task Priority",
  "DIMENSION_NAME_2": "Task Type",
  "TIMEPERIOD_NAME": "null",
  "RPT_NAME": "Task Priority/Type Report",
  "RPT_DESC": "Metrics for task status/type",
  "METRIC_NAME": "Number of tasks",
  "RPT_TYPE": "null"
}

该请求在

ROWID_RPT_CONFIG

参数中返回报告 ID。

要在根报告中添加数据条目，请使用添加或更新报告数据 REST API。

此后，可以将向下钻取报告与数据条目相关联。

例如，以下请求可将数据条目添加到报告中：

POST http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/data/SVR1.2X9N0
[
  {
    "DIMENSION_VALUE_1": "High",
    "DIMENSION_VALUE_2": "AVOSBeMerge",
    "TIMEPERIOD_VALUE": "null",
    "METRIC_VALUE": "3",
    "DRILLDOWN_RPT_ID": "null"
  },
  {
    "DIMENSION_VALUE_1": "High",
    "DIMENSION_VALUE_2": "AVOSBeReviewNoApprove",
    "TIMEPERIOD_VALUE": "null",
    "METRIC_VALUE": "0",
    "DRILLDOWN_RPT_ID": "null"
 },
 {
    "DIMENSION_VALUE_1": "High",
    "DIMENSION_VALUE_2": "AVOSBeUpdate",
    "TIMEPERIOD_VALUE": "null",
    "METRIC_VALUE": "0",
    "DRILLDOWN_RPT_ID": "null"
 }
 ...
]

要注册向下钻取报告，请使用注册报告 REST API。

例如，以下请求可注册向下钻取报告：

POST http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/list
{
  "DIMENSION_NAME_1": "Task's Owner",
  "DIMENSION_NAME_2": "null",
  "TIMEPERIOD_NAME": "null",
  "RPT_NAME": "Task's Owner per Task Priority and Task Type",
  "RPT_DESC": "Number of tasks for each users for Task Priority/Task Type",
  "METRIC_NAME": "Number of Tasks"
 }

以下示例响应显示了已注册的向下钻取报告：

{
  "ROWID_RPT_CONFIG": "SVR1.48P5G",
  "DIMENSION_NAME_1": "Task's Owner",
  "DIMENSION_NAME_2": "null",
  "TIMEPERIOD_NAME": "null",
  "RPT_NAME": "Task's Owner per Task Priority and Task Type",
  "RPT_DESC": "Number of tasks for each users for Task Priority/Task Type",
  "METRIC_NAME": "Number of Tasks",
  "RPT_TYPE": "High/AVOSBeMerge"
}

该请求在

ROWID_RPT_CONFIG

参数中返回向下钻取报告 ID。

要在向下钻取报告中添加数据条目，请使用添加或更新报告数据 REST API。

例如，以下请求可将数据条目添加到向下钻取报告中：

POST http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/data/SVR1.48P5G
[
  {
    "DIMENSION_VALUE_1": "admin",
    "DIMENSION_VALUE_2": "null",
    "TIMEPERIOD_VALUE": "null",
    "METRIC_VALUE": "0",
    "DRILLDOWN_RPT_ID": "null"
 },
  {
    "DIMENSION_VALUE_1": "srmgr2",
    "DIMENSION_VALUE_2": "null",
    "TIMEPERIOD_VALUE": "null",
    "METRIC_VALUE": "0",
    "DRILLDOWN_RPT_ID": "null"
 },
 {
    "DIMENSION_VALUE_1": "mgr2",
    "DIMENSION_VALUE_2": "null",
    "TIMEPERIOD_VALUE": "null",
    "METRIC_VALUE": "0",
    "DRILLDOWN_RPT_ID": "null"
 }
]

要将向下钻取报告与报告中的数据条目相关联，请使用添加或更新报告数据 REST API。在

DRILLDOWN_RPT_ID

参数中指定向下钻取报告 ID。

例如，以下请求将向下钻取报告与数据条目相关联：

POST http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/data/SVR1.2X9N0
[
  {
    "DIMENSION_VALUE_1": "High",
    "DIMENSION_VALUE_2": "AVOSBeMerge",
    "TIMEPERIOD_VALUE": "null",
    "METRIC_VALUE": "5",
    "DRILLDOWN_RPT_ID": "SVR1.48P5G"
  }
]

要检索报告配置和数据，请使用获取报告配置和数据 REST API。

例如，以下请求可检索报告配置和数据：

GET http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/data/SVR1.2X9N0

以下示例响应显示了报告配置和数据：

{ 
  "metadata":{ 
    "fieldsMetadata":[ 
      "DIMENSION_VALUE_1",
      "DIMENSION_VALUE_2",
      "TIMEPERIOD_VALUE",
      "METRIC_VALUE",
      "DRILLDOWN_RPT_ID"
    ],
    "ROWID_RPT_CONFIG": "SVR1.2X9N0",
    "DIMENSION_NAME_1": "Task Priority",
    "METRIC_NAME": "Number of tasks",
    "DIMENSION_NAME_2": "Task Type",
    "TIMEPERIOD_NAME": "null",
    "RPT_NAME": "Task Priority/Type Report",
    "RPT_DESC": "Metrics for task status/type",
    "RPT_TYPE": "null"
  },
  "data":[ 
    [ 
      "High",
      "AVOSBeMerge",
      "null",
      "3",
      "SVR1.48P5G"
    ],
    [ 
      "High",
      "AVOSBeReviewNoApprove",
      "null",
      "0",
      "null"
    ],
    [ 
      "High",
      "AVOSBeUpdate",
      "null",
      "0",
      "null"
    ],
    [ 
      "High",
      "AVOSBeFinalReview",
      "null",
      "0",
      "null"
    ]
    ...
  ]
}

要检索已注册的报告（包括自定义报告和向下钻取报告），请使用列出报告 REST API。

例如，以下请求可列出注册的根报告和向下钻取报告：

GET http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/list?show=all

以下示例响应显示了已注册的根报告和向下钻取报告：

[ 
  { 
    "ROWID_RPT_CONFIG": "SVR1.2X9N0",
    "DIMENSION_NAME_1": "Task Priority",
    "METRIC_NAME": "Number of tasks",
    "DIMENSION_NAME_2": "Task Type",
    "TIMEPERIOD_NAME": "null",
    "RPT_NAME": "Task Priority/Type Report",
    "RPT_DESC": "Metrics for task status/type",
    "RPT_TYPE": "null"
  },
  { 
    "ROWID_RPT_CONFIG": "SVR1.48P5G",
    "DIMENSION_NAME_1": "Task's Owner",
    "DIMENSION_NAME_2": "null",
    "TIMEPERIOD_NAME": "null",
    "RPT_NAME": "Task's Owner per Task Priority and Task Type",
    "RPT_DESC": "Number of tasks for each users for Task Priority/Task Type",
    "METRIC_NAME": "Number of Tasks",
    "RPT_TYPE": "High/AVOSBeMerge"
  }
]

要删除报告，请使用删除报告 REST API。

例如，以下请求删除了一个报告：

DELETE http://localhost:8080/cmx/report/localhost-orcl-DS_UI1/data/SVR1.2X9N0

自定义报告

下载指南

发送反馈

社区

Knowledge Base

成功门户

Rename Saved Search

目录

业务实体服务指南

业务实体服务指南

管理自定义报告和向下钻取报告

管理自定义报告和向下钻取报告