Framework Mgr Question

[Vick]

We are working on a project to convert some microstrategy reports to Cognos. I have 3 tables A, B and C. Both B and C join A(fact) and B and C join each other on delivery type.
Now, B and C are required to join each other only when columns are being pulled from all 3  tables else they don't need to join to each other but just to table A. How do I implement this using Framework Manager.

Please see attached diagram


Thanks,
Vic

[cognos810]

Hello Vick,
Create an alias shortcut of table C and join it to Table B on the Delivery type column. Remove the current join between B and C.
Now you should have Table B joined to A, Table C joined to A and Alias of table C joined to table B.
In any report query when you need to pull data from all three tables, make sure to pull the columns for Table C from the Alias query subject and not from the original Table C. This way, the direct join between the C and A will not kick-in.

Would it work?

-Cognos810