Migrating queries on semantic model

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

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

Query patterns are essential to get better recommendations for a semantic model design. Typically in an organizational setup, all business queries are captured in the Production environment, whereas the semantic model design improvements are performed in the Development environment. For using the same query patterns to get good recommendations on another semantic model across environments, Kyvos allows designers to migrate query patterns from one environment to another using the migration option.

Note

Semantic model designs must be exactly the same in both environments.
Users with read-only or read/write access can export the semantic model queries. Similarly, users with read/write access can import the semantic model queries.
Semantic model queries are exported as a bundle containing all the details in a compressed zip file.
The file size to import or export data for a specific cluster must not exceed the limit specified at the time of cluster configuration.
You can change the size of the query details file for export/import operation by modifying the QUERY_DETAILS_FILE_LIMIT property on Kyvos Manager in the olapengine.properties file.

Exporting queries

To export the semantic model queries, perform the following steps.

Create or edit an existing semantic model from where you want to export queries.
On the Define Semantics tab, click the Actions menu (…), and then select Query Details > Export Query Details.

The Export Query Details dialog box is displayed.

Note

You can include the query patterns by selecting the Include Query Patterns checkbox. See Additional query patterns for more details.

On the dialog box, filter the queries as needed.
Click Export. All the queries are exported as a bundle containing all the details in a compressed zip file.

Importing queries

To import the semantic model queries into another semantic model, perform the following steps.

Create or edit an existing semantic model where you want to import queries.
On the Define Semantics tab, click the Actions menu (…), and then select Query Details > Import Query Details.
The Import Query Details dialog box is displayed.

Click Choose file to navigate to the location of the CSV file that you exported.
Select the file, and click Import. The system displays a summary of imported query details on a semantic model, such as the number of queries successfully imported.
A success message is displayed containing imported query details on a semantic model, such as the number of queries or query fields imported and valid and invalid query field information, among others.
Now, queries are imported and associated with the semantic model recommendation system. You can use the queries to get smart recommendations.
See Semantic model recommendations for more details.