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!
This was last published in September 2005

Dig Deeper on SAP business warehouse

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close