Oracle Transactional Business Intelligence

Products Banner

Customer hierarchy using BI Analysis (or OTBI)

215
Views
6
Comments

Content

Hi All,

I need to build a customer hierarchy report using BI Analysis (or OTBI).

It should display Party Name, Party Usage and Primary Address.

Can anyone help me in achieving above.

 

Thanks,

Rinku

Comments

  • hi Rinku,

    Please provide us the screenshots from Fusion UI for these columns so that I can provide you the subject area and columns from OTBI

     

    Regards,

    Ravi

  • Hi Ravi,

    Please find attached screenshot of Manage Hierarchies. It would be great if you could also share a handy report.

     

    Thanks,

    Rinku

    Hierarchy.jpg

  • Hi Rinku,

    can you please provide us the navigation from Fusion>Navigator to till Hierarchy>hierarchy members

     

    Regards,

    Ravi

  • Hi Ravi,

    Setup and Maintenance > Manage Hierarchies > Enter Hierarchy name > Click on the result to open the resultant hierarchy 

     

    Thanks,

    Rinku

  • Hi Rinku,

    There is no seeded report for this

    You need to create a BI Publisher report by using the below tables

    You have to join these tables Hz_Parties, HZ_CUST_ACCT_SITES_ALL,  HZ_CUST_SITE_USES_ALL ,hz_party_sites and hz_locations
    Hz_parties contains party name
    HZ_CUST_SITE_USES_ALL contain Party Usage
    Locations contain address you have to join with Hz_party_sites

     

    Regards,

    Ravi

  • Hi,

    with OTBI is possible to get this information with the subject area "Marketing - CRM Lead to Order"

    Regards

    Andrea

    ---This is an example of SQL of OTBI

    SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7, s_8, s_9, s_10, s_11, s_12, s_13, s_14, s_15, s_16 FROM (
    SELECT
       0 s_0,
       "Marketing - CRM Lead to Order"."Customer"."Corporate Account Name" s_1,
       "Marketing - CRM Lead to Order"."Customer"."Level 1 Account Name" s_2,
       "Marketing - CRM Lead to Order"."Customer"."Level 2 Account Name" s_3,
       "Marketing - CRM Lead to Order"."Customer"."Level 3 Account Name" s_4,
       "Marketing - CRM Lead to Order"."Customer"."Level 4 Account Name" s_5,
       "Marketing - CRM Lead to Order"."Customer"."Level 5 Account Name" s_6,
       "Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" s_7,
       "Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name" s_8,
       CAST(NULL AS VARCHAR(1)) s_9,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Corporate Account") s_10,
       CAST(NULL AS VARCHAR(1)) s_11,
       CAST(NULL AS VARCHAR(1)) s_12,
       CAST(NULL AS VARCHAR(1)) s_13,
       CAST(NULL AS VARCHAR(1)) s_14,
       CAST(NULL AS VARCHAR(1)) s_15,
       FILTER(COUNT(*) USING ("Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" ="Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name")) s_16
    FROM "Marketing - CRM Lead to Order"
    WHERE
    (FILTER(COUNT(*) USING ("Customer"."Level 6 Account Name" = "Customer"."Level 7 Account Name")) <> 1)
    UNION ALL
    SELECT
       s_0 s_0,
       s_1 s_1,
       s_2 s_2,
       s_3 s_3,
       s_4 s_4,
       s_5 s_5,
       s_6 s_6,
       s_7 s_7,
       s_8 s_8,
       s_9 s_9,
       s_10 s_10,
       s_11 s_11,
       s_12 s_12,
       s_13 s_13,
       s_14 s_14,
       s_15 s_15,
       s_16 s_16
    FROM (
    SELECT
       1 s_0,
       "Marketing - CRM Lead to Order"."Customer"."Corporate Account Name" s_1,
       "Marketing - CRM Lead to Order"."Customer"."Level 1 Account Name" s_2,
       "Marketing - CRM Lead to Order"."Customer"."Level 2 Account Name" s_3,
       "Marketing - CRM Lead to Order"."Customer"."Level 3 Account Name" s_4,
       "Marketing - CRM Lead to Order"."Customer"."Level 4 Account Name" s_5,
       "Marketing - CRM Lead to Order"."Customer"."Level 5 Account Name" s_6,
       "Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" s_7,
       "Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name" s_8,
       "Marketing - CRM Lead to Order"."Customer"."Level 8 Account Name" s_9,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Corporate Account") s_10,
       CAST(NULL AS VARCHAR(1)) s_11,
       CAST(NULL AS VARCHAR(1)) s_12,
       CAST(NULL AS VARCHAR(1)) s_13,
       CAST(NULL AS VARCHAR(1)) s_14,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 8 Account Name") s_15,
       FILTER(COUNT(*) USING ("Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" ="Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name")) s_16
    FROM "Marketing - CRM Lead to Order"
    WHERE
    (FILTER(COUNT(*) USING ("Customer"."Level 6 Account Name" = "Customer"."Level 7 Account Name")) <> 1)
    ) q1 
    WHERE
    s_10 IN ('300000024857636')
    UNION ALL
    SELECT
       s_0 s_0,
       s_1 s_1,
       s_2 s_2,
       s_3 s_3,
       s_4 s_4,
       s_5 s_5,
       s_6 s_6,
       s_7 s_7,
       s_8 s_8,
       s_9 s_9,
       s_10 s_10,
       s_11 s_11,
       s_12 s_12,
       s_13 s_13,
       s_14 s_14,
       s_15 s_15,
       s_16 s_16
    FROM (
    SELECT
       2 s_0,
       "Marketing - CRM Lead to Order"."Customer"."Corporate Account Name" s_1,
       "Marketing - CRM Lead to Order"."Customer"."Level 1 Account Name" s_2,
       "Marketing - CRM Lead to Order"."Customer"."Level 2 Account Name" s_3,
       "Marketing - CRM Lead to Order"."Customer"."Level 3 Account Name" s_4,
       "Marketing - CRM Lead to Order"."Customer"."Level 4 Account Name" s_5,
       "Marketing - CRM Lead to Order"."Customer"."Level 5 Account Name" s_6,
       "Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" s_7,
       "Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name" s_8,
       "Marketing - CRM Lead to Order"."Customer"."Level 8 Account Name" s_9,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Corporate Account") s_10,
       CAST(NULL AS VARCHAR(1)) s_11,
       CAST(NULL AS VARCHAR(1)) s_12,
       CAST(NULL AS VARCHAR(1)) s_13,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 7 Account Name") s_14,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 8 Account Name") s_15,
       FILTER(COUNT(*) USING ("Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" ="Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name")) s_16
    FROM "Marketing - CRM Lead to Order"
    WHERE
    (FILTER(COUNT(*) USING ("Customer"."Level 6 Account Name" = "Customer"."Level 7 Account Name")) <> 1)
    ) q2 
    WHERE
    s_15 IN ('300000024859213')
    UNION ALL
    SELECT
       s_0 s_0,
       s_1 s_1,
       s_2 s_2,
       s_3 s_3,
       s_4 s_4,
       s_5 s_5,
       s_6 s_6,
       s_7 s_7,
       s_8 s_8,
       s_9 s_9,
       s_10 s_10,
       s_11 s_11,
       s_12 s_12,
       s_13 s_13,
       s_14 s_14,
       s_15 s_15,
       s_16 s_16
    FROM (
    SELECT
       3 s_0,
       "Marketing - CRM Lead to Order"."Customer"."Corporate Account Name" s_1,
       "Marketing - CRM Lead to Order"."Customer"."Level 1 Account Name" s_2,
       "Marketing - CRM Lead to Order"."Customer"."Level 2 Account Name" s_3,
       "Marketing - CRM Lead to Order"."Customer"."Level 3 Account Name" s_4,
       "Marketing - CRM Lead to Order"."Customer"."Level 4 Account Name" s_5,
       "Marketing - CRM Lead to Order"."Customer"."Level 5 Account Name" s_6,
       "Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" s_7,
       "Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name" s_8,
       "Marketing - CRM Lead to Order"."Customer"."Level 8 Account Name" s_9,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Corporate Account") s_10,
       CAST(NULL AS VARCHAR(1)) s_11,
       CAST(NULL AS VARCHAR(1)) s_12,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 6 Account Name") s_13,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 7 Account Name") s_14,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 8 Account Name") s_15,
       FILTER(COUNT(*) USING ("Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" ="Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name")) s_16
    FROM "Marketing - CRM Lead to Order"
    WHERE
    (FILTER(COUNT(*) USING ("Customer"."Level 6 Account Name" = "Customer"."Level 7 Account Name")) <> 1)
    ) q3 
    WHERE
    (s_14 IN ('300000024862588')) OR (s_14 IN ('300000024862554'))
    UNION ALL
    SELECT
       s_0 s_0,
       s_1 s_1,
       s_2 s_2,
       s_3 s_3,
       s_4 s_4,
       s_5 s_5,
       s_6 s_6,
       s_7 s_7,
       s_8 s_8,
       s_9 s_9,
       s_10 s_10,
       s_11 s_11,
       s_12 s_12,
       s_13 s_13,
       s_14 s_14,
       s_15 s_15,
       s_16 s_16
    FROM (
    SELECT
       4 s_0,
       "Marketing - CRM Lead to Order"."Customer"."Corporate Account Name" s_1,
       "Marketing - CRM Lead to Order"."Customer"."Level 1 Account Name" s_2,
       "Marketing - CRM Lead to Order"."Customer"."Level 2 Account Name" s_3,
       "Marketing - CRM Lead to Order"."Customer"."Level 3 Account Name" s_4,
       "Marketing - CRM Lead to Order"."Customer"."Level 4 Account Name" s_5,
       "Marketing - CRM Lead to Order"."Customer"."Level 5 Account Name" s_6,
       "Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" s_7,
       "Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name" s_8,
       "Marketing - CRM Lead to Order"."Customer"."Level 8 Account Name" s_9,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Corporate Account") s_10,
       CAST(NULL AS VARCHAR(1)) s_11,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 5 Account Name") s_12,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 6 Account Name") s_13,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 7 Account Name") s_14,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 8 Account Name") s_15,
       FILTER(COUNT(*) USING ("Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" ="Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name")) s_16
    FROM "Marketing - CRM Lead to Order"
    WHERE
    (FILTER(COUNT(*) USING ("Customer"."Level 6 Account Name" = "Customer"."Level 7 Account Name")) <> 1)
    ) q4 
    WHERE
    (s_13 IN ('300000024862588')) OR (s_13 IN ('300000024866303'))
    UNION ALL
    SELECT
       s_0 s_0,
       s_1 s_1,
       s_2 s_2,
       s_3 s_3,
       s_4 s_4,
       s_5 s_5,
       s_6 s_6,
       s_7 s_7,
       s_8 s_8,
       s_9 s_9,
       s_10 s_10,
       s_11 s_11,
       s_12 s_12,
       s_13 s_13,
       s_14 s_14,
       s_15 s_15,
       s_16 s_16
    FROM (
    SELECT
       5 s_0,
       "Marketing - CRM Lead to Order"."Customer"."Corporate Account Name" s_1,
       "Marketing - CRM Lead to Order"."Customer"."Level 1 Account Name" s_2,
       "Marketing - CRM Lead to Order"."Customer"."Level 2 Account Name" s_3,
       "Marketing - CRM Lead to Order"."Customer"."Level 3 Account Name" s_4,
       "Marketing - CRM Lead to Order"."Customer"."Level 4 Account Name" s_5,
       "Marketing - CRM Lead to Order"."Customer"."Level 5 Account Name" s_6,
       "Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" s_7,
       "Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name" s_8,
       "Marketing - CRM Lead to Order"."Customer"."Level 8 Account Name" s_9,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Corporate Account") s_10,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 4 Account Name") s_11,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 5 Account Name") s_12,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 6 Account Name") s_13,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 7 Account Name") s_14,
       IDOF("Marketing - CRM Lead to Order"."Customer"."Customer"."Level 8 Account Name") s_15,
       FILTER(COUNT(*) USING ("Marketing - CRM Lead to Order"."Customer"."Level 6 Account Name" ="Marketing - CRM Lead to Order"."Customer"."Level 7 Account Name")) s_16
    FROM "Marketing - CRM Lead to Order"
    WHERE
    (FILTER(COUNT(*) USING ("Customer"."Level 6 Account Name" = "Customer"."Level 7 Account Name")) <> 1)
    ) q5 
    WHERE
    (s_12 IN ('300000024862588')) OR (s_12 IN ('300000024863020'))
    ) djm ORDER BY 1, 2 ASC NULLS FIRST, 11 ASC NULLS FIRST, 10 ASC NULLS FIRST, 16 ASC NULLS FIRST, 9 ASC NULLS FIRST, 15 ASC NULLS FIRST, 8 ASC NULLS FIRST, 14 ASC NULLS FIRST, 7 ASC NULLS FIRST, 13 ASC NULLS FIRST, 6 ASC NULLS FIRST, 12 ASC NULLS FIRST
    FETCH FIRST 75001 ROWS ONLY

     

     

     

    ---This is an example of XML

    <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:xsd="http://www.w3.org/2001/XMLSchema&quot; xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160">   
       <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;Marketing - CRM Lead to Order&quot;" withinHierarchy="true">      
          <saw:columns>         
             <saw:column xsi:type="saw:hierarchicalColumn" hierarchyID="Customer" tableName="&quot;Customer&quot;" dimensionID="Customer" columnID="c8b0b4c64509de4e4">            
                <saw:hierarchyLevels>               
                   <saw:hierarchyLevel levelID="Corporate Account"/>               
                   <saw:hierarchyLevel levelID="Level 8 Account Name"/>               
                   <saw:hierarchyLevel levelID="Level 7 Account Name"/>               
                   <saw:hierarchyLevel levelID="Level 6 Account Name"/>               
                   <saw:hierarchyLevel levelID="Level 5 Account Name"/>               
                   <saw:hierarchyLevel levelID="Level 4 Account Name"/>               
                   <saw:hierarchyLevel levelID="Level 3 Account Name"/>               
                   <saw:hierarchyLevel levelID="Level 2 Account Name"/>               
                   <saw:hierarchyLevel levelID="Level 1 Account Name"/>               
                   <saw:hierarchyLevel levelID="Customer Name"/></saw:hierarchyLevels></saw:column>         
             <saw:column xsi:type="saw:regularColumn" columnID="ce115722b587e4eef">            
                <saw:columnFormula>               
                   <sawx:expr xsi:type="sawx:sqlExpression">"Customer"."Level 1 Account Name"</sawx:expr></saw:columnFormula></saw:column>         
             <saw:column xsi:type="saw:regularColumn" columnID="cedab1da1739cab8d">            
                <saw:columnFormula>               
                   <sawx:expr xsi:type="sawx:sqlExpression">"Customer"."Level 2 Account Name"</sawx:expr></saw:columnFormula></saw:column>         
             <saw:column xsi:type="saw:regularColumn" columnID="c358d5af07bf457b3">            
                <saw:columnFormula>               
                   <sawx:expr xsi:type="sawx:sqlExpression">"Customer"."Level 3 Account Name"</sawx:expr></saw:columnFormula></saw:column>         
             <saw:column xsi:type="saw:regularColumn" columnID="c0fcb4bd165afaacf">            
                <saw:columnFormula>               
                   <sawx:expr xsi:type="sawx:sqlExpression">"Customer"."Level 4 Account Name"</sawx:expr></saw:columnFormula></saw:column>         
             <saw:column xsi:type="saw:regularColumn" columnID="c3ed2e268a9a32055">            
                <saw:columnFormula>               
                   <sawx:expr xsi:type="sawx:sqlExpression">"Customer"."Level 5 Account Name"</sawx:expr></saw:columnFormula></saw:column>         
             <saw:column xsi:type="saw:regularColumn" columnID="c09ffac3d8fd243f6">            
                <saw:columnFormula>               
                   <sawx:expr xsi:type="sawx:sqlExpression">"Customer"."Level 6 Account Name"</sawx:expr></saw:columnFormula></saw:column>         
             <saw:column xsi:type="saw:regularColumn" columnID="c1e926e38f074f5b8">            
                <saw:columnFormula>               
                   <sawx:expr xsi:type="sawx:sqlExpression">"Customer"."Level 7 Account Name"</sawx:expr></saw:columnFormula></saw:column>         
             <saw:column xsi:type="saw:regularColumn" columnID="c3c7bb5ebfc5e84dd">            
                <saw:columnFormula>               
                   <sawx:expr xsi:type="sawx:sqlExpression">FILTER(COUNT(*) USING ("Customer"."Level 6 Account Name" = "Customer"."Level 7 Account Name"))</sawx:expr></saw:columnFormula></saw:column></saw:columns>
          <saw:filter>
             <sawx:expr xsi:type="sawx:comparison" op="notEqual">
                <sawx:expr xsi:type="sawx:sqlExpression">FILTER(COUNT(*) USING ("Customer"."Level 6 Account Name" = "Customer"."Level 7 Account Name"))</sawx:expr>
                <sawx:expr xsi:type="xsd:decimal">1</sawx:expr></sawx:expr></saw:filter></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="pivotTableView!1"/></saw:cvRow></saw:cvTable></saw:view>      
          <saw:view xsi:type="saw:titleView" name="titleView!1"/>      
          <saw:view xsi:type="saw:pivotTableView" name="pivotTableView!1" scrollingEnabled="true">         
             <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="c8b0b4c64509de4e4">
                         <saw:drillState>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Corporate Account"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024857636</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups></saw:drillStep>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Level 7 Account Name"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024862588</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups>
                               <saw:drillParents>
                                  <saw:drillParent columnID="c8b0b4c64509de4e4" levelID="Level 8 Account Name">
                                     <saw:members xsi:type="saw:stringMembers">
                                        <saw:value>300000024859213</saw:value></saw:members></saw:drillParent></saw:drillParents></saw:drillStep>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Level 6 Account Name"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024862588</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups>
                               <saw:drillParents>
                                  <saw:drillParent columnID="c8b0b4c64509de4e4" levelID="Level 7 Account Name">
                                     <saw:members xsi:type="saw:stringMembers">
                                        <saw:value>300000024862588</saw:value></saw:members></saw:drillParent></saw:drillParents></saw:drillStep>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Level 5 Account Name"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024862588</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups>
                               <saw:drillParents>
                                  <saw:drillParent columnID="c8b0b4c64509de4e4" levelID="Level 6 Account Name">
                                     <saw:members xsi:type="saw:stringMembers">
                                        <saw:value>300000024862588</saw:value></saw:members></saw:drillParent></saw:drillParents></saw:drillStep>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Level 7 Account Name"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024862554</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups>
                               <saw:drillParents>
                                  <saw:drillParent columnID="c8b0b4c64509de4e4" levelID="Level 8 Account Name">
                                     <saw:members xsi:type="saw:stringMembers">
                                        <saw:value>300000024859213</saw:value></saw:members></saw:drillParent></saw:drillParents></saw:drillStep>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Level 7 Account Name"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024862644</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups>
                               <saw:drillParents>
                                  <saw:drillParent columnID="c8b0b4c64509de4e4" levelID="Level 8 Account Name">
                                     <saw:members xsi:type="saw:stringMembers">
                                        <saw:value>300000024859247</saw:value></saw:members></saw:drillParent></saw:drillParents></saw:drillStep>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Level 8 Account Name"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024859213</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups>
                               <saw:drillParents>
                                  <saw:drillParent columnID="c8b0b4c64509de4e4" levelID="Corporate Account">
                                     <saw:members xsi:type="saw:stringMembers">
                                        <saw:value>300000024857636</saw:value></saw:members></saw:drillParent></saw:drillParents></saw:drillStep>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Level 6 Account Name"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024866303</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups>
                               <saw:drillParents>
                                  <saw:drillParent columnID="c8b0b4c64509de4e4" levelID="Level 7 Account Name">
                                     <saw:members xsi:type="saw:stringMembers">
                                        <saw:value>300000024862554</saw:value></saw:members></saw:drillParent></saw:drillParents></saw:drillStep>
                            <saw:drillStep drillType="down">
                               <saw:QDR>
                                  <saw:staticMemberGroup>
                                     <saw:groupType>
                                        <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:groupType>
                                     <saw:hierarchyMembers>
                                        <saw:hierarchyLevelMembers>
                                           <saw:hierarchyLevel levelID="Level 5 Account Name"/>
                                           <saw:members xsi:type="saw:stringMembers">
                                              <saw:value>300000024863020</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>
                                  <saw:target>
                                     <sawx:columnRefExpr columnID="c8b0b4c64509de4e4"/></saw:target></saw:QDR>
                               <saw:selectionGroups>
                                  <saw:selectionGroup columnID="c8b0b4c64509de4e4" groupID="0"/></saw:selectionGroups>
                               <saw:drillParents>
                                  <saw:drillParent columnID="c8b0b4c64509de4e4" levelID="Level 6 Account Name">
                                     <saw:members xsi:type="saw:stringMembers">
                                        <saw:value>300000024866303</saw:value></saw:members></saw:drillParent></saw:drillParents></saw:drillStep></saw:drillState></saw:edgeLayer>                  
                      <saw:edgeLayer type="column" columnID="ce115722b587e4eef"/>                  
                      <saw:edgeLayer type="column" columnID="cedab1da1739cab8d"/>                  
                      <saw:edgeLayer type="column" columnID="c358d5af07bf457b3"/>                  
                      <saw:edgeLayer type="column" columnID="c0fcb4bd165afaacf"/>                  
                      <saw:edgeLayer type="column" columnID="c3ed2e268a9a32055"/>                  
                      <saw:edgeLayer type="column" columnID="c09ffac3d8fd243f6"/>                  
                      <saw:edgeLayer type="column" columnID="c1e926e38f074f5b8"/>                  
                      <saw:edgeLayer type="column" columnID="c3c7bb5ebfc5e84dd"/></saw:edgeLayers></saw:edge>            
                <saw:edge axis="column" showColumnHeader="rollover"/></saw:edges></saw:view></saw:views></saw:report>

    Customer Hierarchy.jpg