The HFM Metadata Utility, a free utility that allows you to import HFM metadata files (.app format) into Excel and export edited content back into Excel, has been updated to allow users to run basic hierarchy queries. Download the latest version of the utility here.
With the updated tool, you can now run five queries: Compare Base Members, Find Duplicates Under Parent, Find Shared Parents, List Shared Parent Members, and List Shared Base Members.
Running a query is simple. Enter your queries on the Query tab and click on the Run Queries button:
Review the output on the Query Result tab.
Below is an example of each query.
1. Compare Base Members
This query compares base members under two parents in the same hierarchy and returns a list of base members that are children of one parent, but not the other. The comparison is performed on both sides, so the result includes (1) all base members that are children of Parent1 but not Parent2 and also (2) base members that are children of Parent2 but not Parent1.
Sample query:
Hierarchy:
Result:
2. Find Duplicates Under Parent
This query finds members that appear twice under a parent. It finds both base and parent member duplicates. Enter '#root' in the Parent1 field to find all duplicates in the hierarchy.
Sample query:
Hierarchy:
Result:
3. Find Shared Parents
This query finds parent members in a hierarchy that are children of both parent members entered.
Sample query:
Hierarchy:
Result:
4. List Shared Parent Members
This query lists all shared parent members (members that have more than one parent) in a hierarchy. Each member is followed by a sorted list of the parents under which it appears.
Sample query:
Hierarchy:
Result:
5. List Shared Base Members
This query lists all shared base members in a hierarchy. Each member is followed by a sorted list of the parents under which it appears. Note in this example that the children of Revenue appear twice in the hierarchy but are under the same parent in both cases. They are duplicate in the hierarchy but not shared.
Sample query:
Hierarchy:
Result:
Other Good Things To Know...
- The Query Results tab is cleared when new metadata is loaded. Queries on the Query tab remain. Simply rerun the queries to see results for the new metadata.
- The Query and Query Result tabs can be moved or deleted without affecting the rest of the utility.
Disclaimer
Download the Updated Utility
