Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Lookup value and circular dependency

HI all,    Here's an issue with the following.    I have one fact table that has a a one to many relationship to 3 dimension tables. Obviously I have id to the fact table.    I can create a hi...
  • Anonymous's avatar
    Anonymous
    7 years ago

    OK, I solved this by myself.

     

    Instead of trying to use lookup, I used firstnonblank. 

     

    This does the trick and I built my hierarchy with it. 

     

    F