COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pooja on 17 Nov 2009 06:32:48 PM

Title: report w/o FM...??????
Post by: pooja on 17 Nov 2009 06:32:48 PM
Is it possible to generate the report with out using FM at all..????
If YES....then how..??????(on SQL server 2005 )

Thankx in advance
Title: Re: report w/o FM...??????
Post by: Kalyan cognoise on 18 Nov 2009 01:21:35 AM
It is possible..Use Tabular sql.

Kalyan
Title: Re: report w/o FM...??????
Post by: DSR on 18 Nov 2009 03:02:52 AM
Hi,

For Creating report without FM....You need to create Data Source in Cognos connection and then you can write your SQL by using that Data Source for report.

Regards,
Sanjeev
Title: Re: report w/o FM...??????
Post by: vinu on 18 Nov 2009 03:20:03 AM
You can create a report with out FM, but you should have a package in cognos connection to open report studio.

1.create a data source in cognos connection.
2.Open Report Studio
3.create a query in query explorer.
4.drag SQL from insertable objects into query
5.Write your own sql to create report
6.assign datasource to SQL from Properties pane.




Thanks,
Venu