To define a set:
You can select the arrow next to to return to the Smart View Panel.
Default dimensions for the connection are displayed in the Smart Query Panel and on the worksheet. The Smart Query ribbon is displayed.
If the dimension exists in Row, Column, or Point of View , you can also start typing the dimension name in order to select it.
For POV dimensions, the members you specify in this step are available for selection from drop-down menus in the Point of View section. You can also enter these names directly.
Note:
When working with very long member names in Essbase, the Smart Query attempts to verify that the name works with Essbase. During the verification process, a numeric (for example, (1), (2), etc.) is appended to the long member name, signifying the number of verification attempts, up to 10 attempts. With each verification attempt, the numeric is incremented by one. Once the 10 attempts are completed, Smart Query proceeds with the last attempt, (9), so you can expect to see (9)
appended to the member name.
Optional: Select Other to define members with MDX expressions (see the Essbase documentation) in Custom Member Expression.
MDX queries must be at least three characters long to accommodate the simplest member expression; for example, two operands and an operator. The OK button here is enabled only after the expression entered is validated.
Queries are given default names, but if you choose to rename an MDX query, do not use the following characters:
Brackets ([ ])
Double quotation marks (”) or their XML-encoded representation (""", """, """, """, """)
Single quotation marks (') or their XML-encoded representation ("'","'","'","'","'")
This setting applies only to the set for which it is selected. When there are multiple sets in a Smart Query, members are displayed in the grid for all sets in which they are selected even if Allow Duplicates in Set is not selected. For example, if Jan, Feb, and Mar are selected as members for one set, and Level 0 members of Year are selected in another set in the same query, then Jan, Feb, and Mar will each appear twice in the grid because they are members of both sets.