Page Comparison

From the Toolbox, choose Semantic Model.

Select a semantic model from the list and click Process. 

From the top right of the window, click Schedule Job.

From the Job Type list, select the Process Full Data option.

Select the job connection that you want to use. In case there are multiple job connections in the underlying registered files in the semantic model, semantic model validation will be triggered on the default Hadoop connection.

You can review and alter the design using recommendations.

If the last job failed, you can resume from the last failure state. Click Resume to confirm. Use the job Source Datasets options to specify whether to materialize datasets with every job or not.

Depending upon the type of Aggregation Strategy selected in the semantic model design, you can add additional query patterns or analyze query patterns using the corresponding links. 

1. Optionally, click filter queries to select the queries to be used for the aggregation strategy.

2. The system will automatically generate aggregates definitions based on the latest data profiles, all available historical queries, and additional query patterns.

Select Process as Metadata and Data or Metadata only. This is applicable only when Kyvos compute -based processing and raw data querying is enabled on the semantic model.

• 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

  • Aggregated Data: The system will

  populate only dimension metadata cache. Your queries will be submitted directly to the underlying data source.

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

2. Raw Data: The system will keep the raw data in Kyvos Analytical store. This data will be used to serve those queries for which smart aggregates are not available in the Kyvos Analytical store.

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

Choose to run once, now, or set up a recurring schedule. With each option, you can also view or change the properties currently in use.

• If you choose Once, select a date, time, and time zone.

• To set up

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

  • Raw Data: The system will keep the raw data in Kyvos Analytical store. This data will be used to serve those queries for which smart aggregates are not available in the Kyvos Analytical store.

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

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

Choose to run once, now, or set up a recurring schedule. With each option, you can also view or change the properties currently in use.

• If you choose Once, select a date, time, and time zone.

• To set up a recurring process, enter the start and end times, the frequency, date, days, week, moths, hours, minutes, and time zone.
  Specify whether to job once per day or repeat. Kyvos picks the time zone from where the report server is running, as the default time zone.

• You can also specify configure semantic model job schedules for specific days of the week using a recurring schedule. This includes flexible options to schedule jobs on non-consecutive days, such as alternating days, specific weekdays, or any custom combination of days.

Click Schedule to start the process.

Use the Replace Partition option to update the already processed data. This option drops out old data and adds current data - keeping the partition size constant. See Replace Partitions.

Depending upon the type of Aggregation Strategy selected in the semantic model design, you can select any of the following:

1. Generate additional aggregates, keeping the existing ones (if any): Additional aggregates definition recommendation will be taken keeping existing aggregates as it is.

2. Use existing aggregates definition: No new aggregates definition recommendation will be taken, aggregates will be created using the existing definition only.

Add additional query patterns or analyze query patterns using the corresponding links. 

Optionally, click filter queries to select the queries to be used for the aggregation strategy.

Select Process as Metadata and Data or Metadata only. This is applicable only when Kyvos compute-based processing is enabled on the semantic model.

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

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.

Raw Data: The system will keep the raw data in Kyvos Analytical store. This data will be used to serve those queries for which smart aggregates are not available in the Kyvos Analytical store.

Select a semantic model from the list and click Process.

From the top right of the window, click Schedule Job.

From the Job Type list, select the Process Incremental Data option.

Select the Job connection that you want to use. In case there are there are multiple job connections in the underlying datasets in the semantic model, semantic model validation will be triggered on the default Hadoop connection.

All Newer Data: Detects and processes all the new data in the files used in semantic model design.

Semantic Model.

Select a semantic model from the list and click Process.

From the top right of the window, click Schedule Job.

From the Job Type list, select the Process Incremental Data option.

Select the Job connection that you want to use. In case there are there are multiple job connections in the underlying datasets in the semantic model, semantic model validation will be triggered on the default Hadoop connection.

From the Process list, select any of the following:

1. All Newer Data: Detects and processes all the new data in the files used in semantic model design.

2. Only Fact Adjustment: Detects and processes only adjustable measures in fact files used in semantic model design. In this case, the old data is not overridden, and the adjustment data can be incrementally loaded in the semantic model without touching any previous data. The adjustments will be made at the lowest granularity of the measure data. Adjustment job can be completedquickly and there can be multiple adjustments in a day. The adjustment details are also displayed in the job summary.

Use the Replace Partition option to update the already processed data. This option drops out old data and adds current data - keeping the partition size constant. See Replace Partitions.

Depending upon the type of Aggregation Strategy selected in the semantic model design, you can select any of the following:

1. Generate additional aggregates, keeping the existing ones (if any): Additional aggregates definition recommendation will be taken keeping existing aggregates as it is.

2. Use existing aggregates definition: No new aggregates definition recommendation will be taken, aggregates will be created using the existing definition only.

Add additional query patterns or analyze query patterns using the corresponding links. 

Optionally, click filter queries to select the queries to be used for the aggregation strategy.

Choose to run once, now, or set up a recurring schedule. With each option, you can also view or change the properties currently in use.

• If you choose Once, select a date, time, and time zone.

• To set up a recurring process, enter the start and end times, the frequency, date, days, week, moths, hours, minutes, and time zone.
  Specify whether to job once per day or repeat. Kyvos picks the time zone from where the report server is running, as the default time zoneis running, as the default time zone. You can also specify configure semantic model job schedules for specific days of the week using a recurring schedule. This includes flexible options to schedule jobs on non-consecutive days, such as alternating days, specific weekdays, or any custom combination of days.

• Click Schedule to start the process.