How cube joined data sources ??? cube machanism

How cube makes join in transformer between two data sources or multiple data sources.

This is unique features provided by cognos cube, link magic provided by cognos.

When you create cube with multiple data sources cube transformer do not have provision to create join between data sources. Then how cube is establishing join and when we open cube in power play studio its showing data without any issue even there are no relation defined in data sources.


Answar :

• Transformer Cube mechanism itself making join between facts and dimensions.
• How its making join : Dimension table key ( primary key ) with Fact table key ( foreign key ).
• Cube making eque join automatically in between facts and dimensions.

Any body know out of these please advise.