Copy Calculated/Restricted Keyfigures between DIFFERENT InfoProviders

[Former Member]

Hello Gurus,

I am struggling with a problem and there doesn't seem to be any clear help on the web. But maybe you can help me.

How can one copy a restricted keyfigure from one infoprovider to another different one when all the infoobjects used for the restricted keyfigure are present in both the providers? (multicubes)

And of course TCode RSZC doesn't work with non-identical infoproviders.

Thank you very much for your help!

Marius

[cornelia_lezoch · Accepted solution]

Hello Marius,

when copying query objects from one provider to the other, the target provider must include at least all objects, that the source provider includes. Means you would have to include all char and key figures into the target, then do the copy and then you could delete the objects which you don´t need.

regards

Cornelia

[Former Member · Accepted solution]

Thank you Cornelia, but this method was clear for me from the begining... it is not an option though... there are about 30 InfoObjects (and another 40 Multiproviders) so there has to be another way. And there is a way because there is an article on BWExpertOnline which describes an easy method (unfortunately this answer is not worth a thousand dollar subscription for me):

Quick Tip

Copy Queries Between InfoProviders Painlessly

by Joerg Boeke, syskoplan AG BEx Analyzer, InfoCubes, Performance, Query, Debug Mode, InfoProvider

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.

Source: [http://www.bw-biexpertonline.com/archive/Volume_03_(2005)/Issue_06_(July)/V3I6A2.cfm?session=|http://www.bw-biexpertonline.com/archive/Volume_03_(2005)/Issue_06_(July)/V3I6A2.cfm?session=]

The above mentioned method handles the copying of queries but when we copy the queries we copy the restricted/calculated keyfigures also.

Does anybody know this painless method?

I thank you in advance.

Marius

Edited by: Marius Grunca on Feb 12, 2008 6:35 PM

[former_member188975 · Accepted solution]

Hi Marius,

That method is using RSZC in the debug mode (or through SE37 > RSZ_I_COPY_QRY_TO_CUBE). I think it has been mentioned in the forum as well that you can bypass the 'matching' reqt by debugging through this, though I have not tried it myself.

Hope this helps...

[Former Member · Accepted solution]

Wow... thank you very much Bhanu! Very nice job. Just telling me about the debug option helped me a lot.

[Former Member · Accepted solution]

Hi Marius,

Would you please help to tell me more detail on how to copy the query from one infocube to another infocube with regardless the characteristic & key figure mapping? I am currently require to re-create most of the queries to an new Infocube which having lesser characteristic than the original one. Your advise is really appreciated.

Thank you.

Cheers,

SLK

[Former Member · Accepted solution]

Hello Smily,

You will find a quite detailed step-by-step explanation of the procedure here:

It is easier than it looks and it really worked for me on BI 7.0.

Hope this helps. Goodday.

[Former Member · Accepted solution]

Hi Marius,

I would like to award points to you but seem like it could not be awarded in this post. So I could only greet many many thanks to you here.

Cheers,

SLK

[Former Member · Accepted solution]

You are welcome, Smily. That's why we are here... to help each other.

Marius