Queries and workbook
Any suggestion to my question will be greatly appreated.
My issues is:
Cube2 is a subset of cube1 based on some business rules. Cube2 is loaded from Cube1 every week. The key figures are determined by, lets say flight company- flight number combination. So every week the flight company-flight number combinations are different.
Now I am writing query on Cube2.
There is one column named occupied rate.
I am asked to add one new column in the query report. The column should show the max value of occupied rate in the past 12 months. The max value might not be in the cube 2. But the max values are in Cube1 for sure.
My question is if I can input two queries in one workbook, query 2 is built on cube 2, query 1 is built on cube 1. Let query 2 run first, and then query 1 run based on the query 2 results (the flight company-flight number combinations). Or any other way?