Print Page - Join between Table and Stored Procedure

Title: Join between Table and Stored Procedure
Post by: cognosun on 17 Mar 2016 09:09:42 AM

Can we join a Stored Procedure Query subject with an existing Table Query Subject in Framework Manager.

Title: Re: Join between Table and Stored Procedure
Post by: cognosun on 17 Mar 2016 10:17:02 PM

Thoughts ?

Title: Re: Join between Table and Stored Procedure
Post by: MFGF on 22 Mar 2016 08:18:54 AM

Quote from: cognosun on 17 Mar 2016 09:09:42 AM
Can we join a Stored Procedure Query subject with an existing Table Query Subject in Framework Manager.

Hi,

Yes you can. I'm surprised you didn't just try it though - adding a relationship in FM takes seconds to do.

I'd expect the join would be performed locally on the Cognos server rather than within the database.

Cheers!

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: cognosun on 17 Mar 2016 09:09:42 AM