Hyperlink or Drill Between Webi Reports based on condition

[yash14]

Hi,

I created 4 webi reports:

1.Universe Reference (Hyperlink to 2)

2.TableFile Reference (Hyperlink to 3 IF SourceFlag is 'Y' ELSE Hyperlink to 4)

3.Source Reference

4.TableFile Reference(Alias)

Based on SourceFlag Dependent ID will change, If SourceFlag='Y' then Dependent Id=Source Refernce ID else TableFile Reference.

I need to drill down or Hyperlink between these reports, Can someone please suggest how to achieve this in BO V3.1 SP7.