Is there a table which shows me the characteristics that have been used in a query? Thanks
On a BW 3.x (never tried it on BI), the best to analyze this is simply to activate the business content for system statistics (0BWTC_CXX cubes). It works very weel and is easy to use - there is a business content workbook... But you need to decide on which cubes you want to check the usage before that information is kept...
Hope it helps,