Extract Metadata to Excel
HI All
Does anyone know a way to extract a given Hierarchy to Excel broken out by columns for each layer ie a parent in one and children in the other. Using HFM in the past, I recall being able to ...
Forum Discussion
Hi Tahir,
It’s not exactly as you’re asking but you can pull the parent/child relationship from the Dimension Library > Grid View tab in OS workspace. Click the “Grid Settings” button and check the box at the top to “display parent child relationships”. Unfortunately this only shows one column for child and one for parent which will not show the full hierarchy with a column for child level.
The other way to see this visually is to pull a QV that’s unsuppressed and set the expansion filter to Tree Descendants" to see the indentation but without the separate columns (it will be indented within one column).
Hope that’s a useful starting point!
-Nicole
HI Nicole
Many thanks for these suggestions, i have used the QV method but wondered if there is something better. I’ll have a look at the Dimension library method.
Cheers
Tahir