One of my current SAP webi report taking more than 2 minutes for execution. We have used on fact table and it has huged data.
If i collect sql from webi report and execute in query analyser then it is taken max 35 sec, but more than 2 minutes in UI.
Could you please let me know steps / procedure / guidelines to optimize SAP webi 3.1 reports or universe?
Client has given benchmark as 1 minute or less than that?
thanks in advance.