Obiee 11g Hierarchy

Question

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.

Gianni Ceresa · Answer

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

Thomas Dodds · Answer

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

Gianni Ceresa · Answer

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.