Skip to content
  • Register

    • Oracle Transactional Business Intelligence

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

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Log In
    Register

    Quick Links

    Categories

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

    Customer hierarchy using BI Analysis (or OTBI)

    258
    Views
    6
    Comments
    Rank 2 - Community Beginner
    in Oracle Transactional Business Intelligence

    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

    Tagged:

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Log In
    Register

    Comments

    • Rank 6 - Analytics Lead

      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

    • Rank 2 - Community Beginner

      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

    • Rank 6 - Analytics Lead

      Hi Rinku,

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

       

      Regards,

      Ravi

    • Rank 2 - Community Beginner

      Hi Ravi,

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

       

      Thanks,

      Rinku

    • Rank 6 - Analytics Lead

      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

    • Rank 1 - Community Starter

      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

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Log In
    Register