Článek přečtěte do 13 min.

Datový kanál Oracle Fusion HCM Analytics dokáže extrahovat data oblasti odpovědnosti (AOR) z Oracle Fusion Cloud HCM a načíst je do přidruženého Oracle Autonomous Data Warehouse (ADW). Správci zabezpečení Fusion Analytics pak mohou využít data AOR k nastavení vlastního zabezpečení podle níže uvedených kroků.

  1. Konfigurace dat.
  1. Vytvořte úlohy rozšíření dat.

Navigace: Konzola Fusion Analytics -> Konfigurace dat -> Rozšíření dat.

  1. Vytvořte dvě úlohy rozšíření pro extrahování verzí stromu hierarchie a dat hierarchie organizace se sloučenými řádky.
    Poznámka: S nadcházejícím vydáním Fusion Analytics Warehouse budou oba níže uvedené objekty zobrazení k dispozici po aktivaci funkční oblasti Fusion HCM Security Configuration, po které se můžete podívat na odpovídající tabulky v krocích k vytvoření proměnných relace a přeskočit další augmentace.
  1. Rozšíření dat pro extrahování verzí stromu hierarchie.

Použité VO: CrmAnalyticsAM.PartiesAnalyticsAM.FndTreeVersionVO. 

  1. Vyberte Vytvořit typ rozšíření dimenze.
  2. Vyberte typ datové sady doplňkového zdroje dat.
  3. Vyberte Pilíř řízení lidského kapitálu.
  4. Vyberte typ tabulky zdroje poskytnuté zákazníkem.
  5. Zadejte zdrojovou tabulku, tj. CrmAnalyticsAM.PartiesAnalyticsAM.FndTreeVersionVO . 
  6. Klepněte na tlačítko Další.
  7. Vyhledejte a vyberte následující atributy:
    1. Postavení
    2. EffectiveStartDate
    3. EffectiveEndDate
  8. Přijměte výchozí nastavení pro přírůstkový klíč.
  9. Klepněte na tlačítko Další.
    DA3
  10. Přijměte výchozí nastavení pro datum extrahování a klepněte na tlačítko Další.
  11. Zadejte Název, např. Verze stromu hierarchie.
  12. Zadejte Popis.
  13. Zadejte příponu tabulky, např. HIER_TREE_VERSION
  14. Předmětové oblasti ponechte prázdné.
  15. Vyberte Spustit nyní pro plán.
  16. Klepněte na tlačítko Dokončit.
  1. Rozšíření dat pro extrahování dat hierarchie organizace složených řádků.

Použité VO: HcmTopModelAnalyticsGlobalAM.OrganizationAM.OrgTreeBIRVOForFscm

  1. Vyberte Vytvořit typ rozšíření dimenze.
  2. Vyberte typ datové sady doplňkového zdroje dat.
  3. Vyberte Pilíř řízení lidského kapitálu.
  4. Vyberte typ tabulky zdroje poskytnuté zákazníkem.
  5. Zadejte zdrojovou tabulku, tj. HcmTopModelAnalyticsGlobalAM.OrganizationAM.OrgTreeBIRVOForFscm. 
  6. Klepněte na tlačítko Další.
  7. Vyhledejte a vyberte následující atributy:
  • PředekPk1Value
  • Pk1Value
  • Vzdálenost
  • FndTreeVersionEffDateEOLastUpdateDate
  • FndTreeVersionEffDateEOLastValidationDate
  1. Přijměte výchozí nastavení pro  přírůstkový klíč.
  2. Ujistěte se, že jsou pro datum extrahování vybrány sloupce FndTreeVersionEffDateEOLastUpdateDate a  FndTreeVersionEffDateEOLastValidationDate. 
    DA10
  3. Klepněte na tlačítko Další.
  4. Zadejte Název, např. Data hierarchie organizace RF.
  5. Zadejte Popis.
  6. Zadejte příponu tabulky, např. RF_ORG_HERE_DATA.
  7. Předmětové oblasti ponechte prázdné.
  8. Vyberte Spustit nyní pro plán.
  9. Klepněte na tlačítko Dokončit.

​

  1. Bezpečnostní rozšíření.
    1. Vytvořte vlastní roli aplikace dat ve Fusion Analytics.

Navigace: Konzola Fusion Analytics -> Zabezpečení -> Role aplikací.

  1. Klikněte na  Nová aplikační role.
  2. Zadejte název role aplikace, tj. Custom AOR Org Hierarchy Data Security.
  3. Zadejte Popis, např. Nastavení zabezpečení dat hierarchie organizace AOR.
  4. Vyberte typ role Správa přístupu k datům na úrovni řádku (datová role).
  5. Klikněte na Uložit.
    CS1

    1. Vytvořte vlastní skupinu.

Navigace: Konzola Fusion Analytics -> Zabezpečení -> Skupiny.

  1. Klikněte na Nová skupina.
  2. Zadejte název skupiny, např. Custom AOR Organization Hierarchy Data Security Group.
  3. Zadejte Popis.
  4. Klikněte na Uložit.
    1. Přiřaďte roli aplikace uživatelských dat skupině.
  5. Hledejte pomocí Custom AOR a vyberte Custom AOR Organization Hierarchy Data Security Group.
  6. Klepněte na Role aplikací.
  7. Klikněte na Přidat mapování.
  8. Vyhledejte a vyberte roli aplikace Custom AOR Org Hierarchy Data Security.
  9. Vyhledejte a vyberte požadovanou pracovní roli, např.  pracovní role Core Analysis Duty.
  10. Klikněte na Uložit.
    CS2

​

Poznámka: Roli aplikace Custom AOR Org Hierarchy Data Security  můžete přidat do dalších předem sestavených a vlastních skupin na základě vašich požadavků.

    1. Přidejte uživatele do vlastní skupiny.
  2. Klikněte na Uživatelé.
  3. Klikněte na Přiřadit uživatele.
  4. Vyhledejte uživatele a vyberte Suzanne.Martha.
  5. Klikněte na Přiřadit.
    1. Přidejte uživatele do licenční skupiny.
  2. Prohledejte skupiny a vyberte FAW Licensed HCM Authors. (Pouze pokud chcete, aby uživatelé mohli vytvářet svůj vlastní obsah, jinak můžete také přiřadit uživatele ke spotřebitelům HCM s licencí FAW.)
  3. Klikněte na Uživatelé.
  4. Vyhledejte uživatele Suzanne.Martha.
  5. Pokud uživatel není nalezen, klikněte na Přiřadit uživatele.
  6. Vyhledejte uživatele a vyberte Suzanne.Martha. Klikněte na Přiřadit.
    1. Zobrazit Členství ve skupinách uživatelů.

Navigace: Konzola Fusion Analytics -> Zabezpečení -> Uživatelé.

  1. Vyhledejte uživatele a vyberte Suzanne.Martha.
  2. Zobrazit Skupiny.
    CS4

3. Rozšíření sémantického modelu.

A. Vytvořte pobočku.

Navigace: Konzola Fusion Analytics -> Rozšíření sémantického modelu -> Uživatelská rozšíření.

  1. Klikněte na Vytvořit větev.
  2. Zadejte Název, např. Proměnná relace zabezpečení dat hierarchie organizace HCM.
  3. Zadejte Popis, např. Nastavení zabezpečení dat hierarchie organizace AOR.
  4. Klikněte na Hotovo.
  1. Přidat proměnné relace.
  1. Klikněte na Přidat proměnné relace ve vyskakovacím okně Přidat krok.
  2. Zadejte Název kroku, např. HCM AOR Org Hierarchy Session Variables.
  3. Zadejte Popis.
  4. Klepněte na tlačítko Další.
  5. Zadejte název inicializačního bloku , např.  HCM_AOR_ORG_HIERARCHY.
  6. Zadejte  Popis.
  7. Zadejte dotaz SQL.

Poznámka: Podle potřeby upravte hodnoty pro TREECODE a RESPONSIBILITY_TYPE v dotazu SQL.

<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">SELECT</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        'AORDEPTLIST',</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DD.DEPARTMENT_ID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    FROM</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_FA_X_HIER_TREE_VERSION FTV,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_FA_X_RF_ORG_HIER_DATA  DWAOR,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_ASG_RESPONSIBILITY_D   DWAR,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_USER_PERSON_D          DWUP,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_DEPARTMENT_D           DD</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    WHERE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        1 = 1</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TO_NUMBER(DWAOR.PK1VALUE) = DD.DEPARTMENT_ID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREESTRUCTURECODE = 'PER_ORG_TREE_STRUCTURE'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.TREECODE='PRJORGHRY'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.STATUS = 'ACTIVE'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TRUNC(SYSDATE) BETWEEN FTV.EFFECTIVESTARTDATE AND FTV.EFFECTIVEENDDATE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREEVERSIONID = DWAOR.TREEVERSIONID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREECODE = DWAOR.TREECODE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.RESPONSIBILITY_TYPE = 'HR_REP'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.ORGANIZATION_TREE_CODE = FTV.TREECODE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.PERSON_ID = DWUP.PERSON_ID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND UPPER(DWUP.USERNAME) = UPPER( ':USER')</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND SYSDATE BETWEEN DWAR.START_DATE AND NVL(DWAR.END_DATE, SYSDATE)</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TO_NUMBER(DWAOR.ANCESTORPK1VALUE) = NVL(DWAR.TOP_ORGANIZATION_ID, TO_NUMBER(DWAOR.ANCESTORPK1VALUE))</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.DISTANCE > DECODE(DWAR.INCLUDE_TOP_HIER_NODE, 'N', 0,(DWAOR.DISTANCE - 1))</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.DISTANCE < NVL(DECODE(DWAR.HIERARCHY_LEVELS, '-99999', '', DWAR.HIERARCHY_LEVELS),</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">                                 DWAOR.DISTANCE + 1)</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    UNION ALL</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    SELECT</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        'AORBULIST',</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DBU.BUSINESS_UNIT_ID</span></span></span></span></span></span>

<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    FROM</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_FA_X_HIER_TREE_VERSION FTV,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_FA_X_RF_ORG_HIER_DATA  DWAOR,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_ASG_RESPONSIBILITY_D   DWAR,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_USER_PERSON_D          DWUP,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_BUSINESS_UNIT_D        DBU</span></span></span></span></span></span>

<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    WHERE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        1 = 1</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TO_NUMBER(DWAOR.PK1VALUE) = DBU.BUSINESS_UNIT_ID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREESTRUCTURECODE = 'PER_ORG_TREE_STRUCTURE'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.TREECODE='PRJORGHRY'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.STATUS = 'ACTIVE'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TRUNC(SYSDATE) BETWEEN FTV.EFFECTIVESTARTDATE AND FTV.EFFECTIVEENDDATE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREEVERSIONID = DWAOR.TREEVERSIONID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREECODE = DWAOR.TREECODE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.RESPONSIBILITY_TYPE = 'HR_REP'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.ORGANIZATION_TREE_CODE = FTV.TREECODE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.PERSON_ID = DWUP.PERSON_ID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND UPPER(DWUP.USERNAME) = UPPER(':USER')</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND SYSDATE BETWEEN DWAR.START_DATE AND NVL(DWAR.END_DATE, SYSDATE)</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TO_NUMBER(DWAOR.ANCESTORPK1VALUE) = NVL(DWAR.TOP_ORGANIZATION_ID,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">                                                    TO_NUMBER(DWAOR.ANCESTORPK1VALUE))</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.DISTANCE > DECODE(DWAR.INCLUDE_TOP_HIER_NODE, 'N', 0,(DWAOR.DISTANCE - 1))</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.DISTANCE < NVL(DECODE(DWAR.HIERARCHY_LEVELS, '-99999', '', DWAR.HIERARCHY_LEVELS),</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">                                 DWAOR.DISTANCE + 1)</span></span></span></span></span></span>

<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    UNION ALL</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    SELECT</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        'AORLELIST',</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        LED.LEGAL_EMPLOYER_ID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    FROM</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_FA_X_HIER_TREE_VERSION FTV,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_FA_X_RF_ORG_HIER_DATA  DWAOR,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_ASG_RESPONSIBILITY_D   DWAR,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_USER_PERSON_D          DWUP,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        DW_LEGAL_EMPLOYER_D       LED</span></span></span></span></span></span>

<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">    WHERE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        1 = 1</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TO_NUMBER(DWAOR.PK1VALUE) = LED.LEGAL_EMPLOYER_ID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREESTRUCTURECODE = 'PER_ORG_TREE_STRUCTURE'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.TREECODE='PRJORGHRY'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.STATUS = 'ACTIVE'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TRUNC(SYSDATE) BETWEEN FTV.EFFECTIVESTARTDATE AND FTV.EFFECTIVEENDDATE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREEVERSIONID = DWAOR.TREEVERSIONID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND FTV.TREECODE = DWAOR.TREECODE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.RESPONSIBILITY_TYPE = 'HR_REP'</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.ORGANIZATION_TREE_CODE = FTV.TREECODE</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAR.PERSON_ID = DWUP.PERSON_ID</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND UPPER(DWUP.USERNAME) =  UPPER(':USER')</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND SYSDATE BETWEEN DWAR.START_DATE AND NVL(DWAR.END_DATE, SYSDATE)</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND TO_NUMBER(DWAOR.ANCESTORPK1VALUE) = NVL(DWAR.TOP_ORGANIZATION_ID,</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">                                                    TO_NUMBER(DWAOR.ANCESTORPK1VALUE))</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.DISTANCE > DECODE(DWAR.INCLUDE_TOP_HIER_NODE, 'N', 0,(DWAOR.DISTANCE - 1))</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">        AND DWAOR.DISTANCE < NVL(DECODE(DWAR.HIERARCHY_LEVELS, '-99999', '', DWAR.HIERARCHY_LEVELS),</span></span></span></span></span></span>
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Courier New"">                                 DWAOR.DISTANCE + 1)</span></span></span></span></span></span>
  1. Klepněte na tlačítko Další.
    cs11

  1. Zadejte tři proměnné:
    1. AORDEPTLIST
    2. AORBULISTA
    3. AORLELIST
  2. Zaškrtněte Row-wise Initialization.
  3. Zadejte popisy.
  4. Zadejte výchozí hodnoty, např. -1.
    CS8
  5. Klepněte na tlačítko Dokončit.

 

Poznámka: Ujistěte se, že názvy proměnných relace jsou uvedeny velkými písmeny.

  1. Sloučit pobočku s hlavní pobočkou.

Sloučit větev Proměnná relace zabezpečení dat hierarchie organizace HCM s hlavní větví. Pokyny naleznete v části Sloučení větví přizpůsobení s hlavní větví.

  1. Nakonfigurujte krok zabezpečení dat.

Navigace: Konzola Fusion Analytics -> Rozšíření sémantického modelu -> Konfigurace zabezpečení.

  1. Klikněte na  Krok zabezpečení dat.
  2. Zadejte název kroku přizpůsobení, např. HCM AOR Org Hierarchy Based Data Security Setup.
  3. Zadejte popis kroku.
  4. V rozevíracím seznamu Role aplikace  vyberte možnost Vlastní zabezpečení dat hierarchie organizace AOR.
    CS9

Tento příklad ukazuje tři objekty, které mají být zabezpečeny. Přidejte další objekty podle svých požadavků.

  1. Vyberte Logické objekty z rozevíracího seznamu Dostupné objekty.
  2. Přetáhněte následující dostupné objekty z levého panelu na objekt, který chcete zabezpečit.
    1. Fakt – Zadání
    2. Skutečnost – událost přiřazení
    3. Dim – Dělník
  3. Pro všechny výrazy argumentů filtru použijte následující a klikněte na Uložit.
<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Oracle Sans",sans-serif">(("Core"."Dim - Department"."Department Identifier"=VALUEOF(NQ_SESSION.AORDEPTLIST) and "Core"."Dim - Organization Hierarchy"."Tree Code"='PRJORGHRY')</span></span></span></span></span></span>

<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Oracle Sans",sans-serif">OR ("Core"."Dim - HCM - HR Business Unit"."Business Unit Identifier"=VALUEOF(NQ_SESSION.AORBULIST) and  "Core"."Dim - Organization Hierarchy"."Tree Code"='PRJORGHRY')</span></span></span></span></span></span>

<span style="font-size:11pt"><span style="line-height:normal"><span style="tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Oracle Sans",sans-serif">OR ("Core"."Dim - Legal Employer"."Legal Employer Identifier"=VALUEOF(NQ_SESSION.AORLELIST)  and  "Core"."Dim - Organization Hierarchy"."Tree Code"='PRJORGHRY' ))</span></span></span></span></span></span>
  1. Klepněte na tlačítko Dokončit.
    Spojené státy

 

  1. Publish the Model.
    Create a Tag

Navigace: Konzola Fusion Analytics -> Rozšíření sémantického modelu -> Uživatelská rozšíření.

Pokyny naleznete v části Označování kroků hlavní pobočky.

  1. Klikněte na Vytvořit značku.
  2. Zadejte Název, např. HCMAOR_OrgHier.
  3. Zadejte Popis.
  4. Z rozevíracího seznamu Krok vyberte položku  Proměnné relací hierarchie organizace HCM AOR.
  5. Klikněte na Hotovo.
  6. Publikovat.

Pokyny naleznete v části Publikování modelu.

  1. Vyberte Main (HCMAOR_OrgHier) z rozevíracího seznamu User Extensions.
  2. Přijměte výchozí nastavení Vše pro konfigurace zabezpečení.
  3. Klikněte na Publikovat.
  4. Validace.
    1. Ověřte rozšíření dat.

Navigace: Konzola Fusion Analytics -> Konfigurace dat -> Rozšíření dat.

 

  1. Ověřte, zda je úloha rozšíření dat úspěšně aktivována:
    • Stav potrubí  ukazuje  Aktivace dokončena.
    • Stav sémantického modelu  zobrazuje  Přeskočeno.
  1. Ověřte, zda jsou vyplněny tabulky skladu  DW_FA_X_HIER_TREE_VERSION a DW_FA_X_RF_ORG_HIER_DATA  vytvořené úlohami rozšíření.
  2. Připojte se ke schématu OAX_USER instance ADW přidružené k FAW a proveďte následující dotazy.
    SQL2
    SQL1

    1. Hierarchie organizace Ověření zabezpečení dat AOR.
  2. Požádejte uživatele s členstvím v roli aplikace HCM View All Data Security nebo skupině administrátorů služby Fusion Analytics, aby se přihlásili do Fusion Analytics a spustili vizualizaci dat (DV) zobrazující celkový počet zaměstnanců a počet zaměstnanců pod konkrétním uzlem AU Content Business Unit přidružené k AOR.

Celkový počet zaměstnanců je 2 835 a obchodní jednotka má 14.
DV1

 

  1. Nechte uživatele Suzanne.Martha přihlásit a spustit stejné DV. Je použito zabezpečení dat AOR.

Celkový počet zaměstnanců je 14 a obchodní jednotka má 14.
DV2

​

Když se uživatel Suzanne.Martha přihlásí do FAW a spustí DV, výraz filtru dat použitý v kroku konfigurace zabezpečení dat se použije ve vygenerovaném fyzickém SQL dotazu.
SQL.

Zdroj: Oracle