Where-used list of an attribute (either display or navigational)

[Former Member]

Dear all,

Is there a way to get the Where-used list of a navigational/display attribute? Basically, I would like to see in which all reports an attribute is used.

regards,

AtlaJ

[Former Member · Accepted solution]

Dear Siggi and Vikash,

The procedure you mentioned only gives the following about an infoobject:

1. All characteristics where this infoobject is used as attibute.

2. All BW objects (cubes, infosurces, reports etc.) where this is infoobject is used at all

But what it doesn't provide is: In which all reports this infoobject is really used when activated as a navigational attribute in a cube (or) as a dsiplay attribute together with the parent characteristic.

Thanks.

[edwin_harpino · Accepted solution]

hi AtlaJ,

try this program (se38)

you will see xxx__yyy for navigation attribute.

hope this helps.

REPORT ZZZ_IO_QUERY.

tables : RSZRANGE, "table

RSZELTXREF,

RSZELTTXT,

RSRREPDIR,

RSZSELECT,

RSZCOMPDIR.

data : begin of IT_RSZSELECT occurs 0,

iobjnm like RSZSELECT-iobjnm,

eltuid like RSZSELECT-eltuid,

end of IT_RSZSELECT,

begin of IT_RESULT occurs 0,

iobj like RSZSELECT-iobjnm,

iobjnm like RSZSELECT-iobjnm,

infocube like rszeltxref-infocube,

compid like rszcompdir-compid,

txtlg like rszelttxt-txtlg,

laytp like rszeltxref-laytp,

end of IT_RESULT.

data : iobj2 like RSZSELECT-iobjnm,

l_count type I.

select-options : IOBJ for RSZSELECT-IOBJNM.

write 😕 'Infoobject : ', IOBJ+3.

write at /20(30) 'Name'.

write at 50(15) 'Infocube'.

write at 65(30) 'Query Tech Name'.

write at 95(50) 'Description'.

loop at IOBJ.

l_count = 0.

concatenate '%' iobj-low into iobj2.

select iobjnm eltuid

from rszselect

into table it_RSZSELECT

where ( iobjnm in IOBJ or

iobjnm like IOBJ2 )

and objvers = 'A'.

loop at it_RSZSELECT.

it_result-iobj = iobj.

it_result-iobjnm = it_RSZSELECT-iobjnm.

select *

from rszeltxref

where teltuid = it_RSZSELECT-eltuid

and objvers = 'A'.

• Query description

• field txtlg

select *

from rszelttxt

where eltuid = rszeltxref-seltuid

and objvers = 'A'.

endselect.

• Query technical name

• field compid

select *

from rsrrepdir

where compuid = rszeltxref-seltuid

and objvers = 'A'.

endselect.

endselect.

it_result-infocube = rszeltxref-infocube.

if it_result-infocube = ''.

it_result-infocube = rsrrepdir-infocube.

endif.

it_result-compid = rsrrepdir-compid.

it_result-txtlg = rszelttxt-txtlg.

it_result-laytp = rszeltxref-laytp.

append it_result.

endloop.

sort it_result by infocube.

loop at it_result.

l_count = l_count + 1.

write at / l_count.

write at 20(30) it_result-iobjnm.

write at 50(15) it_result-infocube.

write at 65(30) it_result-compid.

write at 95(50) it_result-txtlg.

endloop.

endloop.

• table that store navigation attribute info : RSDCUBEIOBJ(infocube),RSDATRNAV(characteristic)

[Former Member · Accepted solution]

I think this may have worked well back in 2006, but it misses a number of query usages with BEx 7.x now in 2015. I suggest using function module RSZ_I_BASIC_CHA_WHERE_USED instead. You could write a wrapper program around it, and output the table entries populated by the function module to get a complete list of BEx queries that use the characteristic.

Regards,

Steve

[Former Member]

Hi AHP,

It works. Great. Thank you.

AtlaJ

[Former Member]

Dear Siggi and Vikash,

The procedure you mentioned only gives the following about an infoobject:

1. All characteristics where this infoobject is used as attibute.

2. All BW objects (cubes, infosurces, reports etc.) where this is infoobject is used at all

But what it doesn't provide is: In which all reports this infoobject is really used when activated as a navigational attribute in a cube (or) as a dsiplay attribute together with the parect characteristic.

Thanks.

[Former Member]

Hi,

Go to that attribute (infoobject), upper menu >EDIT>where used list.

regards

Vikash

[Former Member]

Hi,

if you goto the infoobject maintenance and click on the where-used-list, you get the information where it is used as nav or disp attribute. You will get the other information from the meta data repository. It will normally give you a list of queries using the object.

regards

Siggi