时间戳

首页 > 解决方案 > 如何在 OTBI 中添加多个主题区域

oracle - 如何在 OTBI 中添加多个主题区域

问题描述

我添加了 Workforce Management- Person Real Time 和 Workforce Management- Worker Assignment Real Time 创建具有某些业务字段过滤条件的报告，但是在将 Prefix 添加为 SET VARIABLE ENABLE_DIMENSIONALITY = 1 后出现错误；提前标签。

如何在 OTBI 中跨学科领域不出错？

标签： oraclecloud

解决方案

请检查下面的代码，它正在工作。

转到高级选项卡，将其粘贴到 SQL 部分。

所以基本上有主题领域1.“劳动力管理-实时工人分配事件”2.“劳动力管理-实时工人分配”

    /* How to merge Two Subject Area */
**SET VARIABLE ENABLE_DIMENSIONALITY = 1;
SELECT 0 s_0,
       "Workforce Management - Worker Assignment Event Real Time".
        "Assignment Event Details"."Assignment Number"
          s_1,
       "Workforce Management - Worker Assignment Event Real Time".
        "Assignment Event Details"."Assignment Sequence"
          s_2,
       "Workforce Management - Worker Assignment Event Real Time".
        "Assignment Event Details"."Assignment Status Type"
          s_3,
       "Workforce Management - Worker Assignment Event Real Time".
        "Assignment Event Details"."Assignment Type"
          s_4,
       "Workforce Management - Worker Assignment Event Real Time"."Worker".
        "Employee First Name"
          s_5,
       "Workforce Management - Worker Assignment Event Real Time"."Worker".
        "Employee Last Name"
          s_6,
       "Workforce Management - Worker Assignment Real Time".
        "Worker Assignment Details"."Assignment Sequence"
          s_7,
       "Workforce Management - Worker Assignment Real Time".
        "Worker Assignment Details"."Assignment Status Type"
          s_8,
       "Workforce Management - Worker Assignment Event Real Time".
        "Assignment Event"."Assignment Event Count"
          s_9,
       "Workforce Management - Worker Assignment Real Time".
        "Worker Assignment"."Assignment Count"
          s_10
  FROM "Workforce Management - Worker Assignment Event Real Time"
 WHERE ( ("Worker"."Employee Last Name" = 'Weasley')
        AND ("Worker"."Employee First Name" = 'George')
        AND ("Workforce Management - Worker Assignment Real Time".
              "Worker Assignment Details"."Assignment Status Type" = 'Active'))**

推荐阅读