If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data Module Relationships: SQL expression builder

Started by Blessed2, 15 May 2020 10:24:53 AM

Previous topic - Next topic

Blessed2

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.

bus_pass_man

If you upgrade to 11.1.4 or higher you can define relationship operators. 


There's no relationship expression functionality.

Blessed2

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.