Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Kyvos needs existing query patterns to provide appropriate recommendations. You can define additional query patterns to be used as input by the recommendation system to recommend both partition and aggregation strategies. Define query patterns in addition to or instead of doing a test data process and creating queries to fine-tune those recommendations.

When you are defining a smart aggregation strategy, you can add additional query patterns that group by, summarize on, or filter by the fields you specify. In the Query Patterns dialog, the checkboxes are active for the fields that you can use. For example, you may be able to filter by or group by a dimension, attribute, or level. Then you can summarize or filter using measures. Numbers are displayed next to the column headings to let you know how many fields are used for grouping, summarizing, or filtering. 

Open

Viewing query patterns

To view the query patterns, perform the following steps. 

1. Click the Actions menu (...) next to Revert and Save.

2. Select Query Details > Set Query Patterns.  
   The Query Patterns dialog box is displayed. You must follow the instructions starting from step 6 mentioned in the procedure (To define query patterns) that follows.

3. Click the Actions menu (...) and click Get Recommendations. 

4. In the Input tab, click the Add additional query patterns link. Follow the instructions starting from step 6 in the procedure (To define query patterns) that follows.

5. While viewing the semantic model, click Refine, then Aggregation Strategy, and follow the steps in the procedure that follows.

Defining query patterns

To define query patterns, perform the following steps.

1. From the Toolbox, choose Semantic Models.

2. Select a semantic model and click Refine.

3. Click the Aggregation Strategy tab.

4. Choose a mode: Smart. 

5. For inputs, click the Actions menu (...) and click Get Recommendations. 

6. In the Input tab, click the Add additional query patterns link.

7. In the Query Patterns dialog, click the checkboxes to group by, summarized on, or filter by the various fields. You can scroll down or use search to find the fields you want to use.

8. You can also collapse all or select all fields to group by, summarize on, or filter by.

9. Once you have created a query pattern, you can click the icon near the bottom left of the dialog box to copy it. 

10. After you define your query pattern, click Save. The query is automatically named.

11. To change the name of the query pattern, right-click the query name, choose Rename, then enter a new name.

12. Click Close and finish configuring your smart strategy using smart mode.

After you have added additional query patterns, you can choose either Recommend strategy and select Fresh aggregates or Additional aggregates. Then, you should do a full process to see the results.

Adding additional query patterns

To add additional query patterns, perform the following steps. 

1. While viewing the Query Patterns dialog box, click the Plus icon next to Query Patterns.

2. Start creating the new query pattern. 

3. Click Save when you have finished. 

Adding additional query patterns

To remove query patterns, perform the following steps.

1. While viewing the Query Patterns dialog box, click Search and type a name if needed to search for the query you want to remove.

2. Right-click the query pattern to remove and click Delete. 

3. Click Delete to confirm.

Related topics

• Using aggregates

• Analyzing queries