Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Queries and workbook

Hi All,

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, let’s 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?

Thanks

Not what you were looking for? View more on this topic or Ask a question