Sharing sets between reports

When you are working with dimensional data, you can share a set to make it available for inclusion in multiple reports.

You must first create a set in a source crosstab report, create a shared set definition, then refer to it in a target report.

A shared set definition is copied from one report to another. As a result, the set definition must not depend on any context from the source report. For example, it must meet the following criteria:

  • It cannot reference other shared sets.
  • It cannot reference other data items.
  • It cannot contain calculated members.

You cannot change the definition of a shared set from within the target report. However, you can carry out other set operations on it, such as excluding a member or creating a top 10 list.

Procedure

  1. In the source crosstab report, create a set that you want to share.
  2. Select the set, click the Show properties icon Show properties icon, and in the Properties pane, in the Sharing property, enter a name and description for the set.
  3. Save the report.
  4. Click the Insertable objects icon Insertable objects, and then click the Source tab source tab. Select the data source name, and from the More More icon in the application bar menu in the application bar, select Add shared set report.
  5. Select the source report that contains the shared set definition.
    If it does not exist, a new tab named Shared sets is created in the Insertable objects panel.
    Shared set
  6. Optional: To add, delete, or change the order of reports on the Shared sets tab, from the More More icon in the application bar menu in the application bar, select Manage shared set reports.
  7. Create or open a crosstab target report that you want to refer to the shared set definition.
  8. In the Insertable objects panel, click the Shared sets tab. Open the source report that contains the shared set definition that you want to use.
  9. Add the shared set definition into your target report.
  10. Select the shared set in the target report, click the More icon More icon in the application bar in the toolbar, and click Edit Set.
  11. In the Set definition box, select the shared set.
  12. Click Edit edit icon.
    The Set Reference Properties window opens.
  13. Set the Inclusion property.
    1. Select Run time to retrieve the latest shared set definition every time that the report runs.
    2. Select Design time to store the shared set definition in the target report.
      This definition is used until you refresh it.
  14. Click OK, then save the report.