infoobjects in query

[Former Member]

Is there a table which shows me the characteristics that have been used in a query? Thanks

[former_member188325 · Accepted solution]

not sure about any such table..Did you try to get this info from metadata repository?

Metadata repository-->Serach for your Query and Display details..

[Former Member · Accepted solution]

Thanks for this, its not what I want - I have 30 queries off an infoprovider and want to check which characteristics/kf have been used

[edwin_harpino · Accepted solution]

hi Niten,

try

RSZELTDIR field MAPNAME = query technical name, get SELTUID

RSZELTXREF - SELTUID = RSZELTDIR-SELTUID get all TELTUID

then

characteristics-> RSZSELECT ELTUID = RSZELTXREF-TELTUID get IOBJNM

keyfigures -> RSZRANGE ELTUID = RSZELTXREF-TELTUID get IOBJNM

check

hope this helps.

[Former Member · Accepted solution]

Edwin, thanks for that hope all is good with you otherwise. Take Care

Sorry to bring this back up - the table/path that Edwin has provided in previous thread is great in finding the characteristics but does not identify the key figures does anyone know of a table for the key figures? Thanks

Message was edited by:

Niten Shah

[Former Member]

Hi,

On a BW 3.x (never tried it on BI), the best to analyze this is simply to activate the business content for system statistics (0BWTC_CXX cubes). It works very weel and is easy to use - there is a business content workbook... But you need to decide on which cubes you want to check the usage before that information is kept...

Hope it helps,

Rodolphe