We have few cubes in our system and each one with 'hell' lot of queries. I'm trying to identify which of these queries are used most often so that I can delete the rest.
Is there any way where I could find like.. say for a particular cube, how many times a query is being accessed?
I'm trying to dig into Technical Content cubes/queries but couldn't find much.
Would appreciate if someone helps me in this..