Portal - Report

[Former Member]

Hi All,

In portal one report is taking long time to display the data however the remaining reports not taking to display the data even 5 sec.

I have executed the same report in WAD; here the report is not taking to display the data even 5 sec.

Please advice

Regards

Ravi

[Former Member]

Hi,

It depends on the how many variables you have created for the query, code you have written and depends on the number of reords you have in cube, if you want to improve performance of the query

Build aggregates

Dont write code in query, try to write in transformations

Dont filter or restrict in queries

Filter and restrict in transformatrions

Regards,

Marasa.