Hierarchical Elements or "Members" are individual items found in each hierarchy. For example elements of the Country hierarchy may include Australia, Namibia and United States.
The Elements Tree exposes the member elements within a selected attribute or hierarchy. Users can browse the individual elements and then add the required elements to the query - either through manual selection or with functions exposed in the interface or written through logic. Elements are also used to create quick formulas, lists, or parameters based on the given selections made in the elements tree.
- Click here for details on how to use the elements tree to build queries.
From the Dimensions Panel
To browse the elements tree of a hierarchy in the Dimensions panel, right click on the hierarchy and click View Elements.
From the Drop Zones
To view the elements of a hierarchy from the drop zones, right click on the hierarchy chip and select View Elements.
From the drop zones, you can also double click on the clue hierarchy chip to open its elements tree.
Elements Tree Features
The elements tree operates almost identically across both SQL and MDX data sources. There are a few small, subtle differences, especially on multi-level regular hierarchies.
Elements can be manually added to the query by selecting their checkbox, or removed from the query by deselecting their checkbox. You can also add or remove all elements in the hierarchy by selecting or deselecting the checkbox beside the hierarchy name.
If the entire hierarchy was selected, you can deselect it by clicking the hierarchy label. If only some of the elements in the hierarchy were selected, you can deselect them by clicking the deselect button.
By default, Selection Mode is enabled, meaning that any selected element will be added to the query.
Switch to Elimination Mode to automatically select and strike-through all elements in the tree, and deselect the elements that should be included in the query. Click here for details on adding elements to the query from the Elements Tree.
A key capability of the element trees is their ability to drive custom element ordering in visualizations. By default, when elements are selected, they are ordered according to their NATURAL sort order as defined in the hierarchy definition. However, if a users hand-picks the elements they want, in the order they want, and then elects to use "Custom Sort Order" from the sorting wizard or context menu Quick Sort, the elements will appear in the order they were picked.
After that, users can also use the "Set Element Order" dialog from the context menu to adjust the custom element order.
From the Create Calculations drop down, you can access tools for defining calculations.
- Formula: open the Formula editor, where you can construct custom formulations in PQL or MDX.
- List: open the List editor, where you can build a custom list of elements.
- List Builder: open the List Builder dialog, where you can build or import a list of elements.
- New formula from selections: create a new formula from the selected elements. When in Elimination mode, the formula will be based on unselected elements.
- New list from selections: create a new list from the selected elements. When in Elimination mode, the list will be based on unselected elements.
Toggle the Formulations icon to show or hide custom formulations. By default, formulations are displayed in a tree format; click the drop down to switch to a list view.
Click the search icon to expose the search bar, where you can search for elements within the current hierarchy. If Show Formulations is enabled (see above), the search will also return custom calculations and lists matching your search string.
By default, the search will return elements and formulas whose caption begins with the given string:
To search for elements and formulas whose caption contains the given string, insert an asterisk * before the search string:
To close the search bar, click the search icon again.
Click the search drop down to access the Members Search wizard, where you can search elements and then add them to the query and use them to build custom lists.
Click the refresh icon to refresh metadata for custom lists, and to re-fetch the list of elements within the given hierarchy without clearing the server cache. This action does not refresh data model metadata; to refresh model metadata use the Refresh_Metadata function.