Creating an Ad Hoc Pivot Table with the Analyzer

     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 

1. 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