Page Comparison

Note

• From Kyvos 2023.3 onwards, you can cancel Drop partition jobs. 

• From Kyvos Manager, you can set the duration (in hours) to limit the semantic model process time using the BUILD_TIME_THRESHOLD (OlapEngine   property). Once the semantic model process limit is reached, the process will fail. If you resume the semantic model process, it will use the same duration that you set during the initial semantic model process. 

1. From the Toolbox, choose Semantic Model.

2. Select a cube semantic model from the list and click Process. 

3. From the top right of the window, click Schedule Process.

4. From the Job Type list, select the Full Build Process option.

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

6. You can review and alter the design using recommendations.

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

8. Depending upon the type of Aggregation Strategy selected in the cube 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.

9. 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 buildprocess, enter the start and end times, the frequency, date, hours, minutes, and time zone.
     Specify whether to build process once per day or repeat. Kyvos picks the time zone from where the report server is running, as the default time zone.

10. Click Schedule to start the buildprocess.

1. From the Toolbox, choose Semantic Model.

2. Select a cube semantic model from the list and click Process.

3. From the top right of the window, click Schedule BuildProcess.

4. From the Job Type list, select the Incremental BuildProcess option.

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

6. 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 cube semantic model without touching any previous data. The adjustments will be made at the lowest granularity of the measure data. Adjustment build process can be completedquickly and there can be multiple adjustments in a day. The adjustment details are also displayed in the job summary.

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

8. Depending upon the type of Aggregation Strategy selected in the cube 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.

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

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

11. 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 buildprocess, enter the start and end times, the frequency, date, hours, minutes, and time zone.
      Specify whether to build process once per day or repeat. Kyvos picks the time zone from where the report server is running, as the default time zone.

12. Click Schedule to start the buildprocess.

1. From the Toolbox, choose Semantic Model.

2. Select a cube semantic model from the list and click Process. 

3. From the top right of the window, click Schedule BuildProcess.

4. From the Job Type list, select the Test BuildProcess option.

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

6. From Input Data, you can specify the number of last fact data partitions or the number of records to be processed for the test buildprocess.

   Use the Build Source Datasets options to specify whether to materialize datasets with every build process or not.

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

   1. Generate minimal aggregates: Semantic model will be processed with minimal aggregation strategy (lowest level materialization only). Use this option to compute values for only the lowest levels in the hierarchy.

   2. Generate fresh aggregates: Fresh aggregates definition recommendation will be taken and existing aggregates will be deleted (if any).

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

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

9. Optionally, click filter queries to select the queries to be used for the aggregation strategy.
   NOTE: This build process will overwrite existing semantic model data (if any).

10. 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 buildprocess, enter the start and end times, the frequency, date, hours, minutes, and time zone.
      Specify whether to build process once per day or repeat. Kyvos picks the time zone from where the report server is running, as the default time zone.

11. Click Schedule to start the process.

1. From the Toolbox, choose Semantic Model.

2. Select a cube semantic model from the list and click Process. 

3. From the top right of the window, click Schedule BuildProcess.

4. From the Job Type list, select the Upgrade Aggregates option.

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

6. You can review and alter the design using recommendations.

7. Select partitions to update aggregates. 

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

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

10. Optionally, click filter queries to select the queries to be used for the aggregation strategy.
    NOTE: This build process will overwrite existing cube semantic model data (if any).

11. 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 buildprocess, enter the start and end times, the frequency, date, hours, minutes, and time zone.
      Specify whether to build process once per day or repeat. Kyvos picks the time zone from where the report server is running, as the default time zone.

12. Click Schedule to start the buildprocess.