Versions Compared

Version Old Version 7 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

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

...

  1. You can further modify the design to add dimensions, measures, define dimensions and measure properties, and so on. Refer to Working with Semantic Models to know more.

  2. Click the Next button.

  3. The Review and Process tab shows the entities designed till now.

  4. Here, you can choose process semantic model to create workbooks or connect semantic model to BI tools. Choose any of the following options:

    • I want to execute the test process now: Select this option to run the test build and click Process Now.
      You can further choose:

      1. Job Connection: Select a connection for job execution.

      2. Input Data: Here, you can specify the number of fact data partitions to be used for the test data process.

      3. Process: Select Metadata and Data or Metadata only. This is applicable only when the semantic model is processed with Kyvos Compute.

        • Metadata and Data: Selecting this option will populate both the dimension metadata cache and data (Kyvos Analytical Store). Queries will be served from Kyvos Analytical Store.

        • Metadata Only: The system will populate only dimension metadata cache. Your queries will be submitted directly to the underlying data source.

      4. Keep: Click one of the following options tokeep the Aggregated data or Raw Data. This is applicable only when the semantic model is processed with Kyvos compute and raw data querying is enabled. Additionally, the Both option must be selected when you schedule Process Full Data for a semantic model.

      5. Aggregated Data: The system will keep the aggregated data (and update it in subsequent semantic model processing as per the query patterns) in Kyvos Analytical store. This data will be used to serve the aggregates queries.

      6. Raw Data: The system will keep the aggregated data (and update it in subsequent semantic model processing as per the query patterns) raw data in Kyvos Analytical store. This data will be used to serve the aggregates queriesthose queries for which smart aggregates are not available in the Kyvos Analytical store.

      7. Both: The system will keep aggregated and raw data both.

    • I want to execute the build later: Select this option if you want to review your design and entities before proceeding with the build. In this case, your design is saved, and you can access the semantic model from Toolbox at any time.

  5. Click Process Now.

  6. Once you have launched the test data process data, click View Job Progress to see the job status.
    The system shows the job status in the semantic model designer, as shown in the following figure.

    At the successful completion of your test data process, you can start creating visualization and then generate recommendations to further optimize your design.

...