Is it possible to change the cube used by a BW query? We have a number of identical cubes representing a quarter's history data. Rather than build a unique BW query for each quarter, I would like to build one query and change the cube it points to.
Good question -- but as of BW 3.0B you are not able to change the InfoProvider that a query uses. Fortunately for you, your solution only requires making four query definitions in the Query Designer. I've seen companies who do this sort of thing by month, and I'm sure there is someone out there that does it by week! Just for fun you could always time your drag and drop skills and see how quickly you can build the subsequent queries!
Dig Deeper on SAP business warehouse
ODS objects support detailed information for reporting needs but can cause query performance issues. Peter Scott considers the options for BW ...
In this expert response, Peter Scott exposes how to query only negative projects in SAP BW reporting.
Enhance SAP BW report printing for Web application templates by using the advice in this expert response by Peter Scott.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.