Cognos server getting down by adding SQL block in Report Studio

[Karanag]

Hi ,

I am facing one issue while I create cognos report using pure SQL block after 3-4 normal runs ,there is some isssu, all the report not get loaded even not able to open report studio. Behind that in FM I am using 7 database tables and pulling directly those in cognos. By referring that package I have created some report using SQL block there is some performace issue is coming.
Could anyone please help me in this.

Thanks,
Karan

[sunosoft]

I did not get much stuff....however why u r using SQL objects if you have already developed package ?

[Karanag]

I don't have relationship among the tables yet I just pull all the tables in FM and deploying package using the same table I dont have proper package developed. That is why I ma using SQL block in report studio and based on that I am creating queries for getting expected result.

[sunosoft]

Then how you are developing reports ? one table one report ? or your report is having columns fro all these 7 tables ? in the second you will be definitely get stuck. I am not the expert but what i feel is when you put columns from different tables(not having any joins/relationships) in a list report,cognos will try to create relationship/joins by itself and i do not think it will be good for you by any means.

[Karanag]

I am pulling the data from two to three tables in one report and I am doing this by using Sql block and there I am creating sql query by joining these tables then result data I am fetching  into the list report.

[MFGF]

I am pulling the data from two to three tables in one report and I am doing this by using Sql block and there I am creating sql query by joining these tables then result data I am fetching  into the list report.

If you are coding SQL in your report, you are not using the Framework package objects. If I can give you an analogy, what you're doing here is equivalent to buying a shiny new car, then pushing it to your destination, and subsequently complaining about the performance and discomfort. Your approach is fundamentally flawed, and you need to think very hard about investing in some training to understand the most effective way of using the product you have invested lots of money in.

MF.