Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Analysis - Show Managers Direct and Indirect Structure

Received Response
301
Views
2
Comments
Harminder Banga-283414
Harminder Banga-283414 Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Summary:

OTBI Analysis - Show Managers Direct and Indirect Structure 

Content (required):

I am looking to show a manager's indirect structure, for example, I like to know everyone working for Manager X. Manager X has 10 Direct reports and 50 indirect. Within OTBI please recommended best was to show this

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics & AI Lead

    Try this : Difference Between Secured and Unsecured Assignment Manager Folders in Workforce Management - Worker Assignment Real Time (Doc ID 2240566.1)

    Use the unsecured assignment manager folder to pull the columns.

  • Andrew_Schmitz
    Andrew_Schmitz Rank 5 - Community Champion

    I believe I found this on here before previously (I guess I cannot attach a catalog file)


    XML:


    <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160">

      <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Workforce Management - Worker Assignment Real Time&quot;" withinHierarchy="true">

       <saw:columns>

         <saw:column xsi:type="saw:regularColumn" columnID="cb91a240c12f49629">

          <saw:columnFormula>

            <sawx:expr xsi:type="sawx:sqlExpression">"Assignment Manager List Unsecured"."Manager Name"</sawx:expr></saw:columnFormula></saw:column>

         <saw:column xsi:type="saw:regularColumn" columnID="cda047e2cbc9f3e5a">

          <saw:columnFormula>

            <sawx:expr xsi:type="sawx:sqlExpression">"Assignment Manager List Unsecured"."Person Name"</sawx:expr></saw:columnFormula></saw:column>

         <saw:column xsi:type="saw:regularColumn" columnID="cc2d9a7780047ce9f">

          <saw:columnFormula>

            <sawx:expr xsi:type="sawx:sqlExpression">CASE WHEN "Assignment Manager List Unsecured"."Person Level" = 1 THEN 'Direct' ELSE 'Indirect' END</sawx:expr></saw:columnFormula>

          <saw:tableHeading>

            <saw:caption fmt="text">

             <saw:text>Assignment Manager List Unsecured</saw:text></saw:caption></saw:tableHeading>

          <saw:columnHeading>

            <saw:caption fmt="text">

             <saw:text>Direct/Indirect Report?</saw:text></saw:caption></saw:columnHeading></saw:column>

         <saw:column xsi:type="saw:regularColumn" columnID="c56ed65528949e586">

          <saw:columnFormula>

            <sawx:expr xsi:type="sawx:sqlExpression">"Assignment Manager List Unsecured"."Person Level"</sawx:expr></saw:columnFormula>

          <saw:displayFormat>

            <saw:formatSpec visibility="hidden" suppress="suppress" wrapText="true"/></saw:displayFormat>

          <saw:columnHeading>

            <saw:displayFormat>

             <saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>

         <saw:column xsi:type="saw:regularColumn" columnID="ceadb095c13b41027">

          <saw:columnFormula>

            <sawx:expr xsi:type="sawx:sqlExpression">COUNT(DISTINCT "Assignment Manager List Unsecured"."Person Name")</sawx:expr></saw:columnFormula>

          <saw:tableHeading>

            <saw:caption fmt="text">

             <saw:text>Assignment Manager List Unsecured</saw:text></saw:caption></saw:tableHeading>

          <saw:columnHeading>

            <saw:caption fmt="text">

             <saw:text> Count</saw:text></saw:caption></saw:columnHeading></saw:column></saw:columns>

       <saw:columnOrder>

         <saw:columnOrderRef columnID="cb91a240c12f49629" direction="ascending"/>

         <saw:columnOrderRef columnID="c56ed65528949e586" direction="ascending"/>

         <saw:columnOrderRef columnID="cda047e2cbc9f3e5a" direction="ascending"/></saw:columnOrder></saw:criteria>

      <saw:views currentView="0">

       <saw:view xsi:type="saw:compoundView" name="compoundView!1">

         <saw:cvTable>

          <saw:cvRow>

            <saw:cvCell viewName="titleView!1"/></saw:cvRow>

          <saw:cvRow>

            <saw:cvCell viewName="tableView!2"/></saw:cvRow>

          <saw:cvRow>

            <saw:cvCell viewName="tableView!1"/></saw:cvRow></saw:cvTable></saw:view>

       <saw:view xsi:type="saw:titleView" name="titleView!1"/>

       <saw:view xsi:type="saw:tableView" name="tableView!1" scrollingEnabled="false">

         <saw:edges>

          <saw:edge axis="page" showColumnHeader="true"/>

          <saw:edge axis="section"/>

          <saw:edge axis="row" showColumnHeader="true">

            <saw:edgeLayers>

             <saw:edgeLayer type="column" columnID="cb91a240c12f49629"/>

             <saw:edgeLayer type="column" columnID="cda047e2cbc9f3e5a"/>

             <saw:edgeLayer type="column" columnID="cc2d9a7780047ce9f"/>

             <saw:edgeLayer type="column" columnID="c56ed65528949e586"/></saw:edgeLayers></saw:edge>

          <saw:edge axis="column" showColumnHeader="rollover"/></saw:edges></saw:view>

       <saw:view xsi:type="saw:tableView" name="tableView!2" scrollingEnabled="false">

         <saw:edges>

          <saw:edge axis="page" showColumnHeader="true"/>

          <saw:edge axis="section"/>

          <saw:edge axis="row" showColumnHeader="true">

            <saw:edgeLayers>

             <saw:edgeLayer type="column" columnID="cb91a240c12f49629"/>

             <saw:edgeLayer type="column" columnID="cc2d9a7780047ce9f"/>

             <saw:edgeLayer type="column" columnID="ceadb095c13b41027"/></saw:edgeLayers></saw:edge>

          <saw:edge axis="column" showColumnHeader="rollover"/></saw:edges></saw:view></saw:views>

      <saw:prompts scope="report" subjectArea="&quot;Workforce Management - Worker Assignment Real Time&quot;">

       <saw:promptStep buttonsPosition="side">

         <saw:individualPrompts>

          <saw:prompt xsi:type="saw:columnFilterPrompt" columnID="c7" subjectArea="&quot;Workforce Management - Worker Assignment Real Time&quot;" required="false">

            <saw:formula>

             <sawx:expr xsi:type="sawx:columnExpression" formulaUse="code">

               <saw:columnFormula formulaUse="display">

                <sawx:expr xsi:type="sawx:sqlExpression">"Assignment Manager List Unsecured"."Manager Name"</sawx:expr></saw:columnFormula>

               <saw:columnFormula formulaUse="code">

                <sawx:expr xsi:type="sawx:sqlExpression">DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Assignment Manager List Unsecured"."Manager Name")</sawx:expr></saw:columnFormula></sawx:expr></saw:formula>

            <saw:promptOperator op="in"/>

            <saw:promptUIControl xsi:type="saw:browse" maxChoices="-1" includeAllChoices="true" enableSelectByCodeColumn="false" showCodeColumnValue="false">

             <saw:customWidth width="120" using="custompixels"/></saw:promptUIControl>

            <saw:promptDefaultValues type="allChoices" usingCodeValue="true"/>

            <saw:constrainPrompt type="none"/>

            <saw:setPromptVariables>

             <saw:setPromptVariable location="value" type="none" variableFormula=""/></saw:setPromptVariables>

            <saw:promptSource xsi:type="saw:allChoices"/></saw:prompt></saw:individualPrompts>

         <saw:customWidth width="120" using="custompixels"/>

         <saw:title/></saw:promptStep></saw:prompts></saw:report>