Analytic Groups
Analytic Groups are an essential component in the creation of Analytic Tasks and their Runs in dab Nexus. You can use them to create freely definable groups of analyses and easily manage and access them. This allows you to customize the analyses to the specific needs and requirements of your company.
Furthermore, an Analytic Group together with the required analyses is the prerequisite for you to be able to create analytic tasks in the workspaces area. This step ensures that all required analyses are available and ready for use. With Analytic Groups, you can also easily share packages with other users in dab Nexus and work together on data-driven projects.
You can create an Analytic Group by clicking on Content Studio -> Analytic Groups and on + Analytic Group:
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700577762033/ag-erstellen-1.png)
Analytic Steps
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700578233117/ag-erstellen-2.png)
- Enter a name for the Analytic Group
- Tab: Analytic Step -> Here is a list of the different areas that you can set (you can find more information on each area further down in this article)
- Analytic Steps -> Select the analyses you want to include in your Group - you can add as many analyses as you like
Hold the Shift-key on your keyboard and left-click on a desired checkbox to select or deselect all analysis steps of a module.
![]() | The BaseTable and all Analytic Steps are selected |
![]() | One or more Analytic steps are selected, but not the BaseTable |
- Parameter (Optional) -> You can define default values for individual parameters - where you can define default values for task creation that never or only very rarely change. Of course, you can change this value when creating the task if necessary.
Result Tables
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700578291573/image.png)
- Tab: Result Tables (Optional)
- Result Tables -> On the left you can see a list of the tables that are saved as Result Tables after a run has been completed.
- Restrictions -> Add filters here to further restrict results when saving. With Allow & Deny lists, for example, you can allow or deny certain currencies, which means that they either remain in the Result Table or are sorted out.
- Filters
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700640886657/image.png)
- If you click on the + next to Filters at the bottom left, this selection window appears. You can choose between different operators here:
Operator | Description | Example |
= | Equal -> Both values are equal | 100 = 100 |
<> | Not Equal -> Both values are not equal | 100 <> 99 |
< | Less as -> One value is less than the other | 99 < 100 |
> | Greater as -> One value is greater than the other | 100 > 99 |
<= | Less equal -> One value is less than or equal to the other | 99/100 <= 100 |
>= | Greater equal -> One value is greather than or equal to the other | 100 >= 99/100 |
Like | One value contains parts of the other value, also requires the % sign | %est is contained in Test |
- Use the floppy disk icon to save the filter selection
- You can exit this view by pressing the X
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700641167857/ag-filter-2.png)
- You can use the Add Filter button to create a filter for each results table
- Select the field you want to filter in the dropdown on the left
- Select the filter you want to use for the selected field from the dropdown on the right
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700641171319/ag-filter-3.png)
- Here you can see the use of the % sign in combination with the LIKE operator
If you apply several filters to a results table (as in the screenshot above), these are combined with an AND.
- Allow & Deny Lists
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700641416763/ag-filter-5.png)
- At the bottom left under the filters you can see the existing Allow & Deny Lists (in this article you can find out how to create such lists)
- By clicking on one of these lists, you can see the values it contains (here in the example currencies)
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700641416466/ag-filter-4.png)
- Use the Add List button in the middle to add an Allow & Deny List for one of the results tables
- Use the slider at the front to set whether the values contained in the list should be permitted (Allow) or prohibited (Deny) -> depending on this selection, such values are then available in the results table or are sorted out
- In the dropdown on the left, you specify for which field in which results table this restriction should apply -> here the Currency field in the BKPF
- In the dropdown on the right you specify which Allow & Deny List should be used -> here is the list with the currencies from above
- Columns -> For each results table, specify which of the available columns should ultimately be output and saved. You can drag the columns from Available Columns to Selected Columns or change the sorting of these columns using drag & drop.
User Exits
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700578339560/image.png)
- Tab: User Exits (Optional)
- Analytic Steps -> Shows you the tables for which User Exits can be created
- User Exits -> Existing User Exits can be selected in the middle (the user exits must first be created under Content Studio -> User Exits - you can find out how to create user exits in this article).
Options
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700578390086/image.png)
- Tab: Options (Optional)
- Description -> Enter a description
- Customize Extraction Package -> Here you have the option of creating an Extraction Package based on this analytic group or creating a suitable extraction package for this analytic group. You can select an existing package under Package and a variant next to it (the standard variant is called Default).
- Teams -> Add existing teams to this Analytic Group
- Users -> Add existing users to this Analytic Group
- Create or Create & Close -> As soon as all settings have been entered, the analytic group can be saved -> Create & Close creates it, this view is automatically exited and you return to the overview of existing analytic groups. A message for the successful creation of the group appears here.
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700580192857/ag-erstellen-6.png)
In the overview, you will now see the Analytic Group you have just created, with the optional description to the right of the name of the Analytic Group. The individual analytic steps are listed below this. If you hover over the name of the group with the mouse pointer, you will see three dots. You can use these to edit (Edit), copy (Clone) or delete (Delete) the analytic group.
We recommend that you test your Anayltic Group before using it in your production environment or for production purposes to ensure that it works as intended.
Changes of Analytic Groups
Changes to an analytic group can affect active and scheduled Tasks that have been assigned to this group. When you save the changes, you will receive a corresponding message again.
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700637994546/ag-edit-1.png)
You can edit each of these groups in the overview list of Analytic Groups. To do this, click on the three dots next to the name and then on Edit.
You can now adjust all possible settings for the analytic group, just as you did when you created it.
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700637998321/ag-edit-2.png)
If you click on Save or Save & Close in the top right-hand corner, you will be asked whether you really want to save the adjustments -> clicking on Force edit can affect tasks that use this Analytic Group.
Deletion of Analytic Groups
If you delete an Analytic Group that is assigned to an active, scheduled Task, this Task is deactivated and cannot be reactivated. Before deleting, you will receive another message showing you this information.
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700638624973/image.png)
If you want to delete Analytic Groups that are no longer required or were created by mistake, you can click on the three dots to the right of the name and then on Delete.
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700638695477/ag-delete-2.png)
Here you can either cancel the process or confirm that you really want to delete the group.
![](https://files.helpdocs.io/sqxl6n6710/articles/qz58nb3k2j/1700638698536/ag-delete-3.png)
As already mentioned in the warning above, you will again receive a message informing you of assigned and scheduled tasks that use this analytic group.
Here too, you can either cancel the process or force the deletion, which results in all active tasks that use this analytic group being deactivated.