Skip to Content
0
Former Member
Nov 08, 2005 at 02:40 AM

Listing your queries - Have you found 0BW_TC08 useful? Alternatives?

28 Views

Hi,

I would like list my existing queries, by InfoProvider to provide an easily accessible inventory what is there. Ideally, I'd like to show the technical name, text description, by whom and when they were last changed.

I activated the BC Virtual Cube 0BWTC_C08, and find that it can list queries with these values, however if I add the characteristic InfoCube to the Rows, the Query names and other details are lost (i.e ## Not assigned).

I'd also like to limit the list to those queries we have created and so (usind standard query 0BWTC_C08_Q108 as a template) tried restricting the characteristic "Business Content Release" to # (i.e not related to the standard BC), but this causes an error

"Internal error in program CL_RSDD_VCUBE and method COLLECT_CHA_ATR-14-".

For a straight list of queries, I found creating an Infoset on characteristic 0TCTQUERY ok, but unfortunately 0TCTQUERY doesn't include InfoProvider as an attribute.

I'd also like to look at reporting when each query was last executed to enable a spring-clean of queries no longer used. Does anyone have any pointers for doing this?

Many thanks and Regards

Adrian