Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reporting : Multiple Queries
- Thread starter Benouche
- Start date
Hello Benouche,
Your question is a bit puzzling. 2 separate queries will always give you 2 datasets, regardless if you work with one universe or with 2 universes. A union query will give you one dataset, but is limited to one dataprovider.
I'm not sure what you mean with inserting data in 1 array.
If you mean showing the combined result in 1 row in a table, all dimensions in the table should be from from the linked kind meaning they should be retrieved in both queries and be linked in the report (If the names are the same, BO will automatically link them)
BO will automatically perform a full outer join between datasets. Build a table with the dimensions from query 1 and measures from both queries. This will give you one row for a given combination of dimensions. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
Your question is a bit puzzling. 2 separate queries will always give you 2 datasets, regardless if you work with one universe or with 2 universes. A union query will give you one dataset, but is limited to one dataprovider.
I'm not sure what you mean with inserting data in 1 array.
If you mean showing the combined result in 1 row in a table, all dimensions in the table should be from from the linked kind meaning they should be retrieved in both queries and be linked in the report (If the names are the same, BO will automatically link them)
BO will automatically perform a full outer join between datasets. Build a table with the dimensions from query 1 and measures from both queries. This will give you one row for a given combination of dimensions. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
- Status