cancel
Showing results for 
Search instead for 
Did you mean: 

Number of key Figures used in Query

Former Member
0 Kudos

Hi,

I would like to know the number of queries in a Query,

Is there any way to find out this?

We have nearly 100 queries, and we were asked to find out the top 5 queries in terms of number of key figures.

Thx.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Thejo,

There is no direct way to do this using another BW query simply because the data is not stored in either Masterdata Info Objects/CUBE ODS. They are stored in BW system tables which are not directly accesible by any queries to build using the Query Builder.

Try to locate the system table that holds these Info (Keyfigures + Query Name) and do ABAP Query instead.

Regards,

Jkyle