Hi All,
I have the requirement to have few columns as default in the Report Table and some columns will be in the Exclude Sections of the Table, So whenever user wants to add one more column to the report he/she can use the Include/Exclude option by right clicking on any Column Heading.
But every time I include a column BI server generates the physical query and hits the database, which is giving me a huge performance issue.
What I have observed, first time the query runs, it contains all the columns even if they are in Excluded part, So as per my understanding if the Excluded columns have already been fetched data, why BI server hitting the DB every time?
Pls through some light here...
regards,
Abinash