|
Your SAP Resource » Publications » SAP Experts » BI Expert Online |
|
|
SAP BI/BW/BusinessObjects
|
Part of the
|
|
|
|
|
|
|
|
Knowledgebase » Volume 3 (2005) » Issue 6 (July) Quick Tip
|
|
Learn how to copy a query to a new InfoProvider even when the characteristics differ. This workaround, which uses the debug mode, saves time because you don't have to spend hours recreating a query you want to reuse. |
Categories: BEx, Data Management
Perhaps, like me, you have spent countless hours successfully creating great queries that contain complex structures for a particular InfoProvider. Then, down the road, you find you need this exact query again for another InfoProvider, but the new InfoProvider has a single characteristic that differs from the one that was the object of your original query. Using SAP transaction RSZC (copying queries between InfoCubes), query definitions can be copied only for use on InfoProviders with the same characteristics. If the key bfigures and characteristics of the new InfoProvider do not match the original 100 percent, this standard method fails.
So close and yet so far, right? I’ll show you a way, however, to copy the query definition from one InfoProvider to another, regardless of the characteristics of the new target. This method works with both BW 2.x and 3.x installations.
Would you like to see the full version of this article?If you are an electronic license holder to BI Expert, please click here to log in. If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in the BI Expert online knowledgebase — click here to see the available subscription options. Or call 1-781-751-8799 to speak directly with a subscription and licensing specialist about customized access for you and your team. Isn't your SAP implementation worth world-class information support? |
|
Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@bi-expertonline.com.
|
