Question:
What is the best approach to the following requirement:
- Would like to create one "Master" query.
- Would like to be able to present the results in various formats when data is returned, such as an enterprise level, subsidiary level, line-of-business, profit center, transactional level.
- Same data, different looks at it, all based on the master query.
What is the best way to effect this?
Answer:
If you're using web reporting, I don't know.
If you're using workbooks, there are a couple of ways to do this:
1. If the output format is identical for each level, you can use input Variables so the user requests the level at time of submission.
2. You can create (and save) multiple workbooks based on the same query. Use filters in the workbooks for the various detail levels (different level for each workbook). Filters (or 'local' query definition) can also be used to display different columns/rows in each workbook.