Where used listing for Query Variables

[former_member204618]

Can someone tell me how to get this list from the metadata repository or from the transport connector?

I have read this thread but this isn't working for us.

Is there some config that is required which we have missing?

We are running BI7 SP19 if this helps.

Thanks

Craig

[former_member184494]

Craig,

You will have to set transport collection to necessary objects .. and then ideally when you collect the variabler you should be able to see the same...

[former_member204618]

Arun,

Thanks for your reply but Grouping is already set to "Only Necessary Objects" and Collection Mode is set to "Collect Automatically". Have even tried In Dataflow before and Afterwards to no avail.

Any other ideas?

Thanks

Craig

[former_member184494]

Craig,

I just tried what was mentioned in the post and it works - you transfer the variable to the right side - then right click on the same and select "Display Description " and you will have another window that opens up - this window has the details of the query variable followed by the queries it is used in.

I am on SP18 BI7.0

Edited by: Arun Varadarajan on Mar 17, 2009 8:04 PM

[former_member204618]

Arun,

Yeah I figured as much, but this is why I am thinking we have something missing, config or otherwise.

Cause all I get when I do this is a new window with just the Variable details and nothing else, no where used list at all i.e.

Page Creation Date: 17.03.2009 15:12:03

Technical name: V_FSTMONTH

Object version: Active version

System: BWDCLNT200

Description (Short): 1st of Month to Toda

Description (Long): 1st of Month to Today

Last Changed On 17.03.2009 13:25:39

Last Changed by ARMSTEC

Is there something I need to get our Basis Team to do ?

Thanks

Craig

[Former Member]

Hello,

not sure if this help you or not,,,but can you try the table RSZGLOBV .I guess this will only show the query name for the variables used as input type.

give the variable name here see the query name if it shows up.

Just one question are you trying to find the where used list of customer exit variable??

Thanks

Ajeet

[former_member204618]

Thanks for the suggestions but I have found that V_RSZGLOBV is much better and gives me what I need. I am still wondering why the standard where used isn't working for us.

Thanks

Craig