Report Design to be developed from SQL(Not Iport SQL option)

[tarunkrdas2013]

I have a sql which needs to be developed in a List Report in a similar fashion as in  SQL attached here at this thread ,not through Import SQL option.
Can anyone suggest me how do i achieve  the same

[Lynn]

I have a sql which needs to be developed in a List Report in a similar fashion as in  SQL attached here at this thread ,not through Import SQL option.
Can anyone suggest me how do i achieve  the same

Use Framework Manager to create a package that reflects the data required for reporting and use that as the source for your reporting.

[BigChris]

Given a quick look at the SQL it might be worth considering a cube as well...

[tarunkrdas2013]

Thanks Lynn and BigChris for reply,as of now i am looking to find a way to achieve it from RS only by creating filters and joins at report level (because we already have FM package with all the data items),if all these data items are available in FM package ,what will be the best way to achieve the result

[bdbits]

If your FM model has been designed correctly, you will not need any of that SQL. The best way to achieve the result is to have proper modeling in the package, then use the Cognos features and functions as was intended by those who created Cognos.

Putting all of that into a Report Studio set of queries would be a maintenance nightmare and is unnecessary.