Create Custom Groups

Custom groups are a convenient and powerful way to create aggregations or sets of attribute elements in a way that doesn’t exist in the data source; for instance, a new region combining states. Custom groups also provide a way to create automatic groups or bands based on a qualification. Each set in a custom group can have its own filtering, which might be based on other elements, like revenue range and product type for a segmented analysis of high selling electronics.

1. In the top right corner, click Create New Object.
2. In the Create New window, if you are connected to multiple projects, select the project from the drop-down list on the left.
3. Click Custom Group.



4. To add a custom group element, click Add new element.

5. To delete an element, right-click it and choose Delete. You can multi-select elements for deletion.

6. Complete the definition of the custom group element in Element Type.

   

7. Click here to add a filter element type.

   1. Define a qualification using a custom expression or use the Search box to browse for an attribute.

      

      

   2. If necessary, click New Qualification to combine filters and then change operators.

      

   3. Add additional filters as necessary.

8. Click here to add a banding element type.

   1. Select attribute(s) for the distribution of elements in Distribute elements of attributes in band.

   2. Choose a metric and select Percentage, Rank, or Value banding.

   3. Choose a Banding Type.

      

   4. Set the corresponding criteria.

9. Repeat for as many custom group elements as necessary. You can duplicate a custom group element by selecting it and clicking Copy .

   

10. Click Save.

11. Optionally type a description in User Comments and click OK.

Define VLDB Properties for Custom Groups

Set VLDB properties for the custom group to customize the SQL that is generated and determine how data is processed by the Analytical Engine. VLDB properties provide support for unique configurations and optimize performance in special scenarios. They alter the syntax of a SQL statement to take advantage of unique, database-specific optimizations.

The VLDB property for custom groups allows you to define how the custom group interacts with the report filter.

1. In the Custom Group Editor, click Advanced Properties.

2. Custom Group Interaction with Report Filter: Choose one of the following options:

   • No interaction - static custom group: Report filter qualifications are not applied to custom groups that use metric qualifications or banding qualifications. Filtering is only applied after the custom group has been evaluated.

   • Apply report filter to custom group: Report filter qualifications are applied to custom groups and are used to determine the values for each custom group element.

   • Apply report filter to custom group, but ignore related elements from the report filter: Report filter qualifications that do not qualify on attribute elements that are used to define the custom group elements are applied to custom groups. These filter qualifications are used to determine the values for each custom group element. For example, a report filter that qualifies on the Customer attribute is not applied to a custom group that also uses the Customer attribute to define its custom group elements.

3. Click OK to save the change.