Join between Table and Stored Procedure

[cognosun]

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

[cognosun]

Thoughts ?

[MFGF]

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.