BI 7.0 Query : Changing the infoprovider

[former_member574967]

Hi Experts ,

I have a doubt. there are few queries which is built on the particular infocube say " A". I want to know the way to find how many (total number of queries) are build on that cube. is there any way to find out and also there is one more thing as desribed below :

There are queries which are built on the cube "A" , I need to change it to onther infocube and want the queries to be from cube "B". is it possible to copy them from one infocube to other where the definition reamins the same or do i have to recreate it.? what is the tcode for copying the queries.

Kindly reply,

Thanks & regards,

M.S

[Former Member · Accepted solution]

hi,

Regarding question one, Go to metadata repository under cubes, select your cube, on the right hand pane, you can find the where used list.

under queries you can find what all queries it is used in.

For question 2, you cannot copy the query on to another cube.

You need to rebuild a query.

Hope this helps.

Cheers,

Srinath

[former_member574967 · Accepted solution]

Hi Srinath ,

kindly correct me if i m wrong. I think the tcode RSZC is used to copy the queries from one infoprovider to other.

Thanks & regards,

M.S

[mansi_dandavate · Accepted solution]

Yes thats true... RSZC is used to copy queries accross infoproviders, provided the structure is same...

[rathy_moorthy2 · Accepted solution]

Yes u can RSZC for copying queries,structures, restricted key figure,calculated key figure etc.. from one infoprovider to another where they have the same structure.

Regards,

Rathy

[Former Member · Accepted solution]

Yes Transaction RSZc is to copy query of one infoprovider to other infoprovider.

Regards

Ravi

[Former Member · Accepted solution]

Hi M.S,

Yes, RSZC is used to copy the quer across infoproviders provided the structure is same.

Till now i am unaware of this and got the information after checking back through some other posts in SDN.

Cheers,

Srinath.

[former_member574967 · Accepted solution]

Hi Experts ,

One more question & I am done. The question is :

can we copy queries from cube to multiprovider because i think the structure is not the same. kindly reply.

Thanks & Regards,

M.S

[Former Member · Accepted solution]

You can but multiprovider need to have all the elements.

Regards,

Ravi

[mansi_dandavate · Accepted solution]

No.. It will say target cube not compatible with the source...

However you can try it once in RSZC... Because I think if the target has all the infoobjects that are there in the source and has some additional ones too, it should not give any error...

[former_member574967 · Accepted solution]

Thankyou guys for all your valuable input

Thanks & Regards,

M. S

Edited by: M.S on Aug 3, 2009 11:42 AM

[former_member200211]

hi,

To know number of queries on a Info provider:

Goto Se11, table--> RSRREPDIR, give the name of the info provider and version as "A"(active) and execute. Will give you the technical name and description of the queries and also you can check number of entires ie will give no. of queries on that info provider.

Through transaction RSZC You can copy a query based on one info provider to other info provider only when the target info provider is having all the elements same as the source info provider, the system messages will let you know .

Regards

Lavanya

[mansi_dandavate]

The total number of queries can be found out in QUery Designer...

Just open the query designer and click on query -> Open and click on find, find the infoprovider and you will see all the queries beneath it...

Tcode to copy queries is RSZC...