Master Detail

[sbhamidipati]

I have two independent dimension tables  Channel and Source and one Fact Dimension F connecting to both C and S.
I need to create two chart objects - one with Channel and Facts, the other with F and Facts.

A.  Need to provide drill down for both  C --> S (Sources for a given channel), and  S-->C (Channels for a given source)
B.  Need to connect using Master Detail from first one C-->S i.e. when a channel is drilled down, apply the same channel to possibly S-->C chart or, if that does not work, create another Chart object that synchronizes with C-->S but shows source wise say a cross tab.

How do I model this and create a report?