COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: madhancog on 21 Oct 2009 04:20:24 AM

Title: Views in Framework manager
Post by: madhancog on 21 Oct 2009 04:20:24 AM
Hi Gurus,
   Is there any option to create a View table in Framework.If so please let me know the steps....

Thanks in advance
K.M
Title: Re: Views in Framework manager
Post by: blom0344 on 21 Oct 2009 01:41:16 PM
You can define a SQL object instead of a model query subject. You can then choose the SQL type (Cognos,Native,Pass-through) The last two would have the same effect as a RDBMS dependant SQL view (you can use RDBMS specific functions), but this will lead to an RMDBS specific model..