Two alternate hierarchies SQL BI Datawarehouse

Question

Could you please advice how can I implement this kind of hierarchy in SQL?

enter image description here

As you can see there is a multiple-parent hierarchy . It is an alternate hierarchy based on the business requirements where an account can have many parents. Ex: Chemical Revenue has Product Revenue and Chemical Contribution as parents.

Here is an [similar question](http://stackoverflow.com/q/25644784/3630826) you could reference. — Jaugar Chang, Sep 21 '14 at 13:32

score 0 · Accepted Answer · answered Apr 18 '16 at 12:11

0

The problem was solved by implementing the solution posted hier : http://www.bi4all.pt/node/136

answered Apr 18 '16 at 12:11

Pirvu Georgian

657
1
12
37

Two alternate hierarchies SQL BI Datawarehouse

1 Answers1