Create a multiple universe report
Overview
You can create a custom report using data from multiple universes in WorldShare Report Designer. Before creating a multiple universe report, there are a few things you should know.
- In order to generate reports using data from multiple universes, there must be a common data point in each universe. (e.g., Item Barcode and LHR Item Barcode )
- Queries are used in Web Intelligence to access data. Rather than having to know the specifics of formal Structured Query Language (SQL), you only need to know which universe the data that you want is stored in, the data object requested, and its basic relationships to get started.
- Reports are built in the Query Panel using report objects.
For an overview of the Query Panel, see About Report Designer.
Note: Report Designer times out after 20 minutes of inactivity.
Watch a video
Multiple universe reports
Run time: 12:46
In this video, you’ll learn how to create multiple universe reports in WorldShare Report Designer. People also refer to this task as making cross-universe reports, or merging data from different universes.
Create a query for the first universe
- In the left navigation, click Report Launch Pad.
- Select Web Intelligence from the Applications drop-down list in the upper right-hand toolbar.
- Click the New button ().
- Double-click Universe.
- From the Universe dialog, double-click the universe from which you want to create your first query.
- In the Query Panel, select the report objects and query operators you want to include in your query.
- (Optional) Click Refresh above the Data Preview panel to produce a preview of the data that will be generated once your query is run. Verify that your desired data is included.
- (Optional) By default, the query will be named Query 1. You can rename your query to better identify it (e.g., Acquisitions query).
- Right-click the query name tab and select Rename from the pop-up menu.
- From the Rename query dialog, enter a new name in the New value form field.
- Click OK.
- (Recommended) Click Run Query.
Create a query for the second universe
- Click the Edit Data Provider button ().
- From the Query Panel, navigate to Add Query > From the universe.
- From the Add Query dialog, double-click the universe from which you want to create your second query.
- Select the report objects and query filters you want to include in your query. One of the query filters you add to the second universe should be a report object you included in the query for the first universe. This report object must exist in both universes and is known as the match point. To add a match point:
- Select the report object you've decided to use as your match point (e.g., Item Barcode) and add it to the Query Filters pane.
- Click the Define filter type button () and then select Result from another query from the pop-up menu. The Available Objects dialog opens.
- Select your match point report object from the Available Objects dialog (e.g., Item Barcode).
- Click OK.
- (Optional) Click Refresh above the Data Preview panel to produce a preview of the data that will be generated once your query is run. Verify that your desired data is included.
- (Optional) By default, the query will be named Query 2. You can rename it to better identify it (e.g., Acquisitions query).
- Right-click the query name tab and select Rename from the pop-up menu.
- From the Rename query dialog, enter a new name in the New value form field.
- Click OK.
- Click Run Queries. The Add Query dialog opens.
- Select the Include the result objects in the document without generating a table radio button from the Add Query dialog and click OK. The initial report results will appear, but need to be merged.
Merge data
- From the Report screen, navigate to Data Access > Merge.
- From the Available Objects dialog:
- Click the common data point you want to merge on from your first query.
- Press Ctrl and click the common data point from your second query.
Note: The data point may not have the same name across universes (e.g., Item Barcode vs. LHR Item Barcode). - Click OK.
Add report objects from second query to the report
Web Intelligence has a rule that only objects from a single universe can be displayed in one table together. If you attempt to add a report object that is not in both universes to your multiple universe report, the report object will not appear and all other report objects from that universe query will be grayed out in the Available Objects panel.
You can create a variable and associate it with your desired merged report object (i.e., the match point you set up between universes) to resolve this issue.
To create a variable:
- From the Available Objects pane, right-click the Variables folder.
- Select New from the pop-up menu.
- From the Create Variable dialog:
- Enter a name for the variable in the Name form field. This name cannot match the name of any existing report object.
- Select Detail from the Qualification drop-down menu.
- Click the ... button () for under Associated dimension.
- From the Objects and Variables dialog, under Merged Dimensions, double-click the report object that you are using as a match point between universes.
- Click OK. The Objects and Variables dialog closes.
- From the Available Objects panel, double-click the object for which you want to create a variable.
- (Optional) Repeat steps 1-4 for additional match points.
- To add a variable to the report, select the variable and drag it to the desired location in the report.