5 Replies Latest reply on Jan 24, 2017 9:35 PM by Gianni Ceresa

    Obiee 11g Hierarchy

    997009

      Hello,

       

      I want to create a hierarchy from two dimension tables. Table 1 Customers, Table 2 Products.

      The hierarchy should have two levels 1.Customers.Customer_Name, 2.Products.Category.

       

      These two tables doesn't have a common key to join.

       

      Can we achieve this??

       

      Thanks.

        • 1. Re: Obiee 11g Hierarchy
          Gianni Ceresa

          Hi,

          Why do you want that?

          The result will be the same product categories to be repeated again and again many many time for all your customers, doesn't really make sense.

          And the link between custom and product category is probably only your fact table with sales.

           

          These few things make it a kind no-sense hierarchy, that's why I ask you what is reason behind this request ...

          • 2. Re: Obiee 11g Hierarchy
            997009

            I want it like a hierarchical column.

            Suppose I have client XYZ and the Sales is 100$

            when they click on XYZ they should see like Category 1=20$, Category 2=80$.

             

            I did a drill down report right now. But they asked if this can be achieved, instead of going to different report when clicked and return back to main report.

            • 3. Re: Obiee 11g Hierarchy
              Gianni Ceresa

              As said I suspect your only way to link customer and product is using the fact table.

              So if you imagine a join between the customer table, the fact table and the product table you easily see how bad it is because of the number of lines returned.

              So you can do it, sure, it's just not the ideal way.

               

              What you did now is a way better solution (navigation) or even just 2 analysis next to each other with master/detail link to pass the customer to the one showing the detail by product.

              • 4. Re: Obiee 11g Hierarchy
                Thomas Dodds

                Why not specify a preferred drill path from Customer Detail Level to Product Detail Level?  Maybe I'm missing something ...

                • 5. Re: Obiee 11g Hierarchy
                  Gianni Ceresa

                  You aren't missing anything Thomas Dodds

                  I was a bit too much against the "original need" and forgot to think a bit wider...

                   

                  So the preferred drill path is the cleanest solution as long as the requirement isn't to drill somewhere else in the next analysis