Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can I change the InfoProvider that a query uses?

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.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close