Best way to identify old / unused members
PLIMJan 28 2013 — edited Jan 29 2013Hi all
We have had our Planning app for nearly 4 years now and to keep it nice and lean we are wanting to do a review of our dimensions and remove all members which havent been used in the last 2 years.
Just wondering if there are any recommended ways on identifying the members which havent been used in the last 2 years?
Currently the only way we can think of is to either do an MDX query or a Smart View query to list members that have no YearTotal amount from 2010 onwards but this creates the risk of removing
1) members that have just been created
2) members that have movement within the year but total to zero
Any suggestions?
Edited by: PLIM on Jan 30, 2013 8:37 AM - clarifying question