COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: LukeMal on 14 Aug 2013 11:16:20 AM

Title: Stored Procedures/Framework Manager - dynamic datasource
Post by: LukeMal on 14 Aug 2013 11:16:20 AM
Hi!

I'm working on Cognos 8.4.0.
Currently I have about 10 datasources to support.

I've already created one FM model which has macros/parameters inserted in every Query Subject (at DataSource Layer).

The case is that some of my reports are based on Stored Procedures (MS SQL) and there is a need to have same "dynamic datasource" feature pluged in...


My issue is that I can find any solution to cover the need...


Please let me know if you had any similar cases or have any ideas how to carry this out.


Thanks!
LM