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 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 connection that you want to use. In case there are multiple build connections in the underlying registered files in the cubesemantic model, cube 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 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 or not.

8. Depending upon the type of Aggregation Strategy selected in the cube 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 build, enter the start and end times, the frequency, date, hours, minutes, and time zone.
     Specify whether to build 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 build.

1. From the Toolbox, choose Semantic Model.

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

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

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

5. Select the Build connection that you want to use. In case there are there are multiple build connections in the underlying registered files datasets in the cubesemantic model, cube 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 cube semantic model design.

   2. Only Fact Adjustment: Detects and processes only adjustable measures in fact files used in cube semantic model design. In this case, the old data is not overridden, and the adjustment data can be incrementally loaded in the cube without touching any previous data. The adjustments will be made at the lowest granularity of the measure data. Adjustment build 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 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 build, enter the start and end times, the frequency, date, hours, minutes, and time zone.
      Specify whether to build 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 build.

1. From the Toolbox, choose Semantic Model.

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

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

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

5. Select the Build connection that you want to use. In case there are there are multiple build connections in the underlying registered files in the cubesemantic model, cube 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 build.

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

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

   1. Generate minimal aggregates: Cube Semantic model will be built 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 will overwrite existing cube 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 build, enter the start and end times, the frequency, date, hours, minutes, and time zone.
      Specify whether to build 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 buildprocess.

1. From the Toolbox, choose Semantic Models.

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

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

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 connections in the underlying registered files in the cubesemantic model, cube 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 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.
    NOTE: This build will overwrite existing cube 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 build, enter the start and end times, the frequency, date, hours, minutes, and time zone.
      Specify whether to build 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 build.