7.6.2  Report Partitioning

Bursting relies on the action of partitioning, or splitting, a report based on a username (or role)/data value pair. A report can only be partitioned on one data element (Table or Section), and you must perform the partition mapping using Style Studio. Partitions are created by running a query against a live data source and retrieving a list of unique rows, then mapping that data set to another query result set. The users and roles are defined in the Enterprise Manager and cannot be changed in Style Studio. See the Users Tab section of the Administration Reference for more information.

Walkthrough

You will now implement a simple example report and set its bursting conditions. (This example is available as bursting1.srt in the examples\docExamples\design directory.)

1. Click the 'New' button in the Style Studio toolbar. This opens the 'New Asset' dialog box.

2. In the left panel, select the 'Report' node. From the right 'Types' panel, select 'Blank Tabular Report' and click 'OK'.

3. Expand the Style Studio Toolbox panel. (Select 'Toolbox Pane' from the Style Studio 'Window' menu.)

4. Click the 'Table' button in the Toolbox panel. This opens the 'Data Binding' dialog box for a new Table.

5. Under the Data tab, bind the table to the 'All Sales' query from the 'Orders' data source.

6. In the Grouping & Summarization tab, specify grouping by 'Employee' and summarization by 'Total'.

 

7. Press 'Finish' to close the dialog box.

8. Select 'Bursting' from the Style Studio 'Report' menu. This opens the 'Report Bursting' dialog box.

9. Select 'Enable Report Bursting'.

10. Select 'Table1' as the partition element, and select 'Employee' as the 'Partition Column'.

 

11. Click on the User tab.

12. In the 'User Mapping' panel, select the 'Orders' > 'Sales by Employee' query from the 'Query' menu.

This query returns the names of each user for whom you will filter and burst the data. You can also create this mapping for roles using a query that returns role names.

13. Select 'First Name' as the 'User'. This is the column that returns the user names on which the data will be filtered.

Similar settings can be used in the Role tab to perform role map­ping.

14. In the 'Data Mapping' pane select 'First Name' as the 'Employee' value.

 

15. Click on 'OK' to save the bursting settings, and save the report.

16. Save the report into the current working repository with the name “Bursting Example”. (See Saving a Report into the Working Repository.)

This completes the first phase of implementing report bursting. To complete the example and then run the report for multiple users, see Report Bursting in Administration Reference.

<< 7.6.1 Implementing Report Bursting © 1996-2013 InetSoft Technology Corporation (v11.5) 7.7 Localization/Internationalization >>