Selection Schemas: Dictionaries

Selection schema is a repository object used in dictionary to automatically select elements based on specified criteria. Selection schemas are created as dictionary children; they are not displayed in the object navigator, but can be used in all the objects that use the parent dictionary.

TIP. For details about applying of selection schemas, see the Using Selection Schema article.

A selection schema primitive is a rule based on which elements are selected. All primitives are applied in the order of creation.

NOTE. MDM dictionaries always work with the principal elements of the dictionary. The user cannot create a selection schema based on elements of default alternative hierarchies.

Selection schemas can be managed in the Selection Schemas dialog box available in the tools and object navigator of Foresight Analytics Platform: Dashboards, Analytical Queries (OLAP), Reports.

To open the Selection Schemas dialog box from the object navigator, select the Selection Schemas item in the context menu of the required dictionary.

To open the Selection Schemas dialog box from a tool of Foresight Analytics Platform tools:

Go to the Selection side panel tab.
Select the Edit item in the drop-down menu:

The Selection Schema button located on the Selection ribbon tab.
The Advanced Selection > Apply Selection Schema item in the context menu of the dimension element on the side panel.
The Advanced Selection > Apply Selection Schema item in the dimension menu on the side panel.

To create a new schema select the [New Schema] element in the Schema drop-down list.

To edit the existing selection schema, select it in the Schema drop-down list.

To add a primitive, click the Add button and select selection schema in the drop-down list:

Select all.
Select by list.
Select descendants.
Select level
Always select level (it works for the existing selection).
Always select with parents (it works for the existing selection).
Always select with descendants (it works for for the existing selection).
Use application macro.

Several primitives can be added for one selection schema.

To edit an existing primitive:

Click the Edit button.
Double-click the primitive.

The Edit Primitive dialog box opens:

In the dialog box:

Select the action in the drop-down list:

It selects selected elements.
It deselects selected elements.

Specify the elements, for which the rule is applied, in the dictionary elements tree.

A standard context menu is available when the user works with selection in the Edit Primitive dialog box.

To change the order of the primitives in the list use the Down and Up buttons.

To view the result of all primitives application click the View Result button.

To delete the primitive, select it in the primitive list and click the Delete button.

To save the selected selection schema, click the Save As button displayed on the same level with the Schema field.

In the opened window specify name and identifier of the selection schema.

To delete the selected schema from the Schema list, click the Delete button located to the left from this list.

The selection schema contents is dynamically based on macro execution result.

Macro must be a static (Shared) method of a class
Macros signature must look as follows:

Public Class <class name>: Object
    Public Shared Sub <schema name>(<SelectionParam>, <GroupParam>: IDimSelection);
    Begin
        ...
    End Sub <schema name>;
End Class <class name>;

Parameters:
SelectionParam. The dimension selection, in which it is required to edit elements (select or deselect)

GroupParam. A group of elements, where selection schema is applied. If this parameter is equal to Null, all elements of the selection are handled.

On creating and editing a primitive that uses macro to select dictionary elements, the Method of Element Selection dialog box opens:

The dialog box shows a list of available Fore and Fore.NET assemblies, forms and units. The Methods area displays the class tree of the object selected in the repository list.

The Methods area displays the child elements (methods) for each class if they correspond with the required signature. If no methods are available, the class is not displayed.

Double-click the method to select it and close the dialog box.

On clicking the OK button, the Select Elements from Macro primitive is added to the primitive list. The OK button is available if:

The method is selected from the method list.
The only one method is displayed in the method list.