The community of Analytics developers are invited to follow and participate in the developer network. OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

I then want to display the following data derived from this chunk of queries:a) aggregate transactionCount from all warehousesb) aggregate transactionCount grouped by warehouse country (e.g for all US warehouses, for all German warehouses)c) top 10 warehouses with most transactions

Would the query run faster if 1) I put the chunk of queries + queries for a), b) and c) all in ONE dataset and then link that dataset to all the charts, or2) put chunk of queries + queries for a) in ONE dataset, chunk of queries + queries for b) in ANOTHER dataset ... etc

Or is there an even faster way than #1 and #2 in computing answers for a) b) and c)?