How to avoid the case statement in data item

[inu]

Hi

There are 10s of data item , each of which having case statement... it means its applying on each row,.. degrading the performance..
Can we avoid this, is there any other solution ...

I really appreciate the response...

Regards,
Inam

[hespora]

If you do not want them on row level, create a subquery to your existing query and have the case statements in there. Then, they will run at aggregated level as is the output of your query.

[inu]

If you do not want them on row level, create a subquery to your existing query and have the case statements in there. Then, they will run at aggregated level as is the output of your query.

Thanks a lot...Can you please tell me how to create subquery in cognos report studio...

No idea , boss.


Regards,
Inam,

[hespora]

In your query explorer, click on queries. Now, drag a query item from your toolbox into the working area. Inside the working area, drag your existing query to the right of the newly created query.

[inu]

In your query explorer, click on queries. Now, drag a query item from your toolbox into the working area. Inside the working area, drag your existing query to the right of the newly created query.

Thanks, so will it create subquery? I just checked it ,,, not like that...


Regards,
Inam