On OpenPlace, there is a solution named Unused Member Analysis (UMA) which allows a user to view members across the dimension types which do not have data. Additionally, you can check whether the members have annotations (text) written against them. For any members which do not have data, you can delete them in bulk from the solution.
