This content has been marked as final. Show 3 replies
Excluded section is only excluding the column from view only and its not same as deleting a column from criteria tab.
All the columns considered in the data showing in pivot table.
Some there are other circumstances... its good not to talk about that.. ;)
If make sense mark
Even if the column is excluded in pivot, it will be there in the query sent to database. If you exclude an attribute, and if it changes the granularity of the report, you have to make sure you set aggregations properly in pivot measures, otherwise you can get unexpected results, and individual row level or even grand totals.1 person found this helpful
Edited by: A. Kumar on Apr 2, 2013 1:26 PM
It is sometimes difficult for us to understand how the BI Server Parses the SQL.
For example for the same report Table view has one sql and Pivot table has another sql.
So always try to rely on DB and try to modify the SQL according to your needs.