Change the stream

User permission: Query > Change Stream

A stream is a series of data that comes from a different source. Typically, each business unit or department produces its own stream of data and these individual streams collectively make up the data in a database. If a database has more than one stream, the Stream menu displays in the toolbar, allowing you to switch between those streams. The available streams depend on the database. For example, in a Sales database, you might have a Sales stream, an Inventory stream, and a Budget stream.

You can change the stream both when you are in Summary view and when you select a dimension (filtered view). Click the Stream menu to view your options, then select a stream from the list (the default stream displays at the top).

The grid instantly updates to display the data from the new stream and the Stream button identifies your selection. Some of the dimensions might become unavailable as they do not apply to that stream.

As illustrated above, you can only select one stream at a time. If you want to compare streams side-by-side, use Stream mode.

More about streams:

• Streams do not respond to the Reset button. If you change the stream and then want to revert to the default stream, you need to manually change it back.

• If only one stream has been defined in the underlying database, neither the Streams menu nor the Stream mode option will be available.

• If a 'No results' message displays when you change the stream, this might be simply because the data does not exist. For example, budgets might not exist for individual customers or there might be no orders in the system for a particular branch.