cancel
Showing results for 
Search instead for 
Did you mean: 

infoobjects in query

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188325
Active Contributor
0 Kudos

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
0 Kudos

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

0 Kudos

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
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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