Multiple Select Statements for a Single Page Report in Cognos10, Bad Performance

[pravin.cognos]

Dear Gurus,

I am using Cognos 10, Oracle 12 and Noetix. Noetix generates the views from the Oracle database and they are published by FWM to Report studio.

I have to create a report using 40 views for inventory module. When I run the report it is taking at least 10 mins to run to generate 100 rows of data in the output. The report fails if I am selecting any other values. The performance is very bad. When I looked into the report SQL, there are 25 blocks of SQL with select statements. The central view is Item_inv and it is getting joined with most of the views in each block. I am not sure why is this happening as the join conditions and relationships are already defined in FWM. How can this be resolved? Please help.

Is it bad to have multiple select statements in a query? If yes, how can I get rid of them?

Thanks,
Pravin

[pravin.cognos]

Dear Gurus

Also I am getting multiple rows where the data is spread across rows.

Ex: If I select particular prompt values, only one row of the data needs to be shown. But my report is showing 34 rows and the data is spread across 34 rows. Can you pls tell me what is the issue?

Thanks
Pravin

[blom0344]

There must be something very wrong with the applied join (strategy) Simply importing views into a framework is ludicrous. you need to perform a modelling step to get a properly functioning framework.

It is  bit hard to give advice without knowing where you are up against.

First question: by what means did you apply joins in the first place?