When you run a query on a single data source, the results are stored in the microcube for that document. In one Web Intelligence document, you can add more than one query based on one or more universes in the SAP BI Platform.
Each universe is designed for a specific functional area. When you work with both sales data and customer demographics, you use two separate universes. For example, your organization may use one universe to access product line sales data and another universe to access customer data. You can include data from both universes in a single Web Intelligence document.
A universe is not the only data source you can use in Web Intelligence. You can also use data from Excel spreadsheets, text files, CSV files, BW queries, SAP HANA views, or SAP Datasphere views in your document.
Using multiple queries in a Web Intelligence document offers several benefits.
- Combine data from different sources: You can merge data from two universes to build a more complete report.
- Improve report performance: Instead of running one large query, you can split it into smaller, faster ones.
- Separate levels of detail: Use one query for summary data and another for detailed data.
- Work around system limits: You can prepare data in one query to use in another with merged dimensions.
Data Projection from a Single Query into Different Report Elements
Watch the video to project data from a single query to different report elements.
Data Projection from Multiple Queries Using a Single Universe
You can create multiple queries in the same document using the same universe. Each query can use different filters, even though all queries use the same universe.
For example, you can show sales revenue by year and quarter for 2025 in the first table. In a second table, you can show sales revenue by state and store name for all years. In this case, you need to create two queries on the same universe, each with a different data scope.
To add a new query, select Add Query in the Query panel.
Data Projection of Queries From Multiple Universes
Watch the video to work with multiple queries.
Refreshable Queries
You can choose which queries to refresh when you refresh a document. After you refresh a document with several queries, you can choose not to refresh certain queries during later refreshes.
In this case, the query keeps the data from the previous refresh, which is stored in the microcube. This can improve refresh speed if you do not need to update queries with data that does not change.
Let's Summarize What You've Learned
- Combine data from multiple queries to create comprehensive reports using different data sources in one document.
- Use multiple queries to improve report performance, separate detail levels, and work around system limits.
- Project data from a single query into different report elements to display varied information.
- Create multiple queries from the same universe with different filters to show different data scopes.
- Selectively refresh queries to optimize document performance and update only necessary data.