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
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