We are on BW 3.5.The issue is:In production, I have lot of queries which are not used anymore,but this queries are still available under the specified Cubes/Ods.Hence, the user has to scroll up/down or find the queries which are newly created or freequently used.
Is there a way with which i can move all the old queries to one folder/infoarea ? So, that there is a clear visibility of old queries/less used and the ones freequently used in Bex.
Also, is there a possibility of achieving this by creating different roles and assigning the queries ?
Your replies are greatly appreciated.