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?