You can quickly able to create ad hoc analysis by
dragging and dropping your report data into the pivot table, and also you can
able to save this as a layout for the report.you can apply filters also to
this.Data what we are using in this are from source XML so we
cant able to perform number formatting.
About
Online Analyzer Toolbar
New – It creates a new pivot table structure. If you want
to save click save before you click new.
Export – It helps you to export and save this as BI
Publisher Layout
Move decimal Left – It help to add additional decimal
position
Move decimal right –
It helps to remove decimal postion
Creating an Interactive Pivot Table
- From the report viewer click actions and then select analyzer
2. Analyzer
Interface will display the fields on the left pane and empty pivot table on the
right
3. To
filter by department name drag and drop dname from left pane to page item area
on the right.
4.To
view Job wise employee wise salary drag and drop fields from left pane to row
field in the analyzer.
5. Now
you can click Job, Ename to open and close, corresponding to that field values
will change
Saving your Interactive Pivot table as Layout
1. You
can save your analyzer by clicking export on the tab that appears on the top
2. Then it will be saved as BI Publisher .xpt then it will have all the
featured of a BI Publisher layout
3.Close
the Online Analyzer
4. On
the action Menu click Edit Report
5. From
the report editor ,click View a List to display the layouts in the list view.
6.Locate
your new layout in the Layout table and select a locale for it
7.Click
save
