General OBIEE

Get Involved. Join the Conversation.

Topic

    Rinku Gautam
    Customer hierarchy using BI Analysis (or OTBI)
    Topic posted June 18, 2019 by Rinku GautamRed Ribbon: 250+ Points, tagged Analyses, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip 
    119 Views, 6 Comments
    Title:
    Customer hierarchy using BI Analysis (or OTBI)
    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

    Comment

     

    • ravikiran goda

      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

      • Rinku Gautam

        Hi Ravi,

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

         

        Thanks,

        Rinku

        • ravikiran goda

          Hi Rinku,

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

           

          Regards,

          Ravi

          • Rinku Gautam

            Hi Ravi,

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

             

            Thanks,

            Rinku

            • ravikiran goda

              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

    • Andrea Del Sorbo

      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" 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;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>