Hi, I have a report wherein there are plenty of charts and cross tab reports. But all these reports data sets are same...So, I have created a master query Q1 which just contains the detail data. I then use TF for different set of reports and apply the filter specific to the queries.
I have even enabled the local cache use for the master query Q1.
On approx there are 15 TF on the master Query Q1.
Will this approach have any effect on performance...If so, tell me the other approach in solving the performance issue...
Srik