COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Data Modules => Topic started by: Blessed2 on 15 May 2020 10:24:53 AM

Title: Data Module Relationships: SQL expression builder
Post by: Blessed2 on 15 May 2020 10:24:53 AM
Within the relationship builder for Data Modules is there a way to edit the relationship expression using sql statements?  In the Relationship Editor for FM, the ability to edit and create your own SQL is available in the Expression builder at the bottom for users needing to create more complex relationship statements.
Title: Re: Data Module Relationships: SQL expression builder
Post by: bus_pass_man on 15 May 2020 10:44:49 AM
If you upgrade to 11.1.4 or higher you can define relationship operators. 


There's no relationship expression functionality.
Title: Re: Data Module Relationships: SQL expression builder
Post by: Blessed2 on 15 May 2020 10:52:34 AM
Ok, thank you.
We are on 11.1.5.  Was looking for the same flexibility and control to manually model complex relationships within the Data Module as what is available within Framework Manager.  Maybe they will add the functionality in upcoming versions.