In dimensions with large member sets, you can easily define selections using the Dimension Browser shortcut menu. Right-clicking dimension member names enables selection by familial relationship and data source-specific options:
Icon | Shortcut Menu Command | Selects: |
|---|---|---|
| Also Select Children | Currently selected member and its children (one level below) |
| Also Select Descendants | Currently selected member and its descendants |
| Select Parent | Direct parent of the selected member |
| Also Select Ancestors | Currently selected member and its ancestors |
| Also Select Siblings | Currently selected member and members on one level with identical parent ancestor |
| Select Dim Bottom | All dimension members on the lowest level of the hierarchy |
| Select Dim Top | Highest ancestor |
| Also Select Level | Currently selected dimension member and all dimension members on one level |
| Also Select Generation | Currently selected dimension member and all dimension members in one generation |
| Also Select Previous | A number of previous members at one dimension level |
| Also Select Subset | An Essbase member subset |
Substitution Variables | Sets a substitution variable as the dimension selection | |
| Select Attribute | A selection from a list of attribute dimensions |
User Defined Fields | Financial Management—One of three pre-defined attribute values . Select members featuring these attribute values and compose compound selection statements with AND and OR operators | |
Dynamic Time Series | Essbase Dynamic Time Series selection (for example: History To Date, Quarter To Date) | |
Search | Locates dimension members in large dimensions with search criteria, and adds found members to the Selection list | |
Find In Tree | Locates dimension members in large dimensions Expands the dimension hierarchy, but does not add found members to the Selection list |
