can't see bex queries in metadata repository

[Former Member]

Hi Pros,

         I have created a lot of bex query and saved in my favorite, but I can't see them in metadata repository. why.

[KodandaPani_KV · Accepted solution]

Hi

metadata repository we can see both reports custom and standard reports.

Ex- 0PUR_C01 - if you go this cube query technical names you all get the all reports custom and standard reports.

select RSA1-> go to the metadata repository -> select query -> select the CNTR+F after give the query technical name.

please find the below screen shot.

Thanks,

Phani.

[mr_v]

Metadata repository is for both BI Content objects and custom objects.

Did u try searching with query technical name?

[MartinMaruskin]

Hi Yifei,

within the metadata repository you can see both BI Content objects and active objects that were created by users in the systems.

I guess for some reason your BEx queries are not active and therefore they are not visible in the metadata repository. Try to see Bex objects in the table RSRRPDIR. Maybe the queries are just inactive.

cheers

m./