This discussion is archived
3 Replies Latest reply: Apr 2, 2013 10:26 AM by 998980 RSS

Reg: Excluded Section in Pivot view

Bhargav K Newbie
Currently Being Moderated
Hi,,

can any one telme..

how exactly the 'Excluded Section' in the pivot view, will effect the entire report.
In one of my report when i place one column in excluded section, one set of data is coming, when i remove that column in the Excluded section , data is effecting and its changing...why this is happening??
  • 1. Re: Reg: Excluded Section in Pivot view
    Srini VEERAVALLI Guru
    Currently Being Moderated
    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
  • 2. Re: Reg: Excluded Section in Pivot view
    998980 Explorer
    Currently Being Moderated
    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.

    Edited by: A. Kumar on Apr 2, 2013 1:26 PM
  • 3. Re: Reg: Excluded Section in Pivot view
    DNK Explorer
    Currently Being Moderated
    Hi Bhargav,

    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.

    Thanks
    NK

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points