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
Quote from: TKD on 07 Dec 2015 03:40:44 PM
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.
Given a quick look at the SQL it might be worth considering a cube as well...
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
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.