Versions Compared

Old Version 5

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Pallavee Dutta

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

(tick) Kyvos Azure Marketplace   (tick) Kyvos GCP Marketplace (tick) 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.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

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. 

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

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

  1. On the dialog box, filter the queries as needed. 

  2. Click Export. All the queries are exported as a bundle containing all the details in a compressed zip file. 

...

  1. Create or edit an existing semantic model where you want to import queries.

  2. 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.

  3. 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.