Managing Data Sources in a Story Report

You can create stories with visualizations using data from one or more data sources, also referred to as ''queries''.

After creating a story, you must create a new Data Source using the Query Builder. When you have successfully created the first query, you are redirected to the Story canvas.

You can build multiple queries for a Story. To edit or delete an existing data source or build another data source, select Add, Edit, or Delete Data Sources.

Choose Edit Data Source or Delete Data Source, followed by the name of an existing query to edit or delete it, or choose Add New Data Source to create a new one.

When using the add or edit data source options, the Query Builder will load. After you add or edit the query, you are again redirected to the Story canvas.

You can create stories with visualizations using data from multiple queries or data sources. Blending data sources lets you join a primary data source with secondary data sources that contain common linked dimensions. For example, you can blend data from a Job Information data source with User Information data. Blending can be done within individual charts.

To blend data, you will use linked dimensions.

For example, you may want to display the total value of one-time bonuses per Job Title. The employee's job title is returned in the data source Job Information, which includes the User ID field. You also have a second data source on Basic User Information, which includes the User ID field as well. The Basic User Information also includes related tables to display the one-time bonus values for each employee. You could link these two data sources on the dimension User ID so that you can chart your requirement.

To link two data sets for blending data in a story:

1. In the story, create two or more queries (data sources) that can logically be linked with one another.
2. On the Story Designer page, select Link Dimensions.
3. On the left-hand side, select the primary data source.
4. On the right-hand side, select the other data source that you want to link to your primary data source.
5. From both data sources, select the dimensions that can be linked logically.
6. Choose Set.
7. Choose Done.