Job summary

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

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Kyvos allows you to view job summaries for various jobs, such as semantic model processes, email jobs, cache population, data profiling jobs, process progress, and so on. 

For example, the email jobs summary displays details of the sender and receiver for the worksheet/workbook/dashboard shared over email.

You can also download summary logs.

Once a job is complete, you can view the details in the job summary. No admin access is required to view the Job Summary.

The jobs summary shows the following items:

• General Information

  • Job type

  • Job Number

  • Size on disk

  • Semantic Model Process time or Total time is taken (how long it took to process the semantic model)

  • Completion Time (date and time at which the semantic model process was completed)

  • Status: Success, Failed, or Partial Success. 
    In case of a partially successful job, the Measure Datasets which are not processed are marked as Partially Processed, and the dataset containing invalid rows is marked as [Invalid] .

    Info

    • From Kyvos 2023.3 onwards, the Update Aggregate build will display a progress bar. This progress bar shows the status of the processed cuboids, elapsed time, and percentage of the processed cuboids.
      
    • With the Kyvos 2023.1 release onwards, d uring the Update Aggregate build, if some cuboids are successful and others fail, the build is marked as a Partial Success with the percentage of successful cuboids displayed on the Job Summary. Additionally, the newly created cuboid is now marked as browsable.
      You can also view the log details of the input cuboid versus the output cuboid along with Measure Datasets by using the Download Logs option. 

• Build Inputs is displayed in the Summary only in case of incremental build and shows:

  • Process - All Newer Data, Only Fact Adjustments

  • Replace partition - None, Auto

• Physical view

  • Dimensions along with metadata size, hierarchy, levels, and attributes (if present)
    Additionally, the summary also shows if there are any parent-child relationships, alternate paths, or custom rollups in the hierarchies

  • Dimension count with types, such as regular dimension or time type dimension. In the case of the time type dimension, the hierarchy type, such as pre-defined hierarchy or custom time hierarchy is also shown.

  • Additionally, the summary also shows SCD member count

  • Count of distinct members/dimension

  • Count of rows read in from a file

  • Measures along with metadata size, functions used, IsAdjusted tag (in case of fact adjustment incremental build) 

• Partition strategy shows updated partition information (if Replace Partitions option is selected) and sliding window data dropped information (if new data is added and older deleted)

• Details is displayed in the summary only in the case of update aggregates build and show the status and which partitions are updated, typically All. 

• Aggregation strategy shows details for aggregation strategy mode, precompute level threshold, and selective hierarchy materialization. C lick Show Aggregates to view the details of each aggregate in a separate tab.

• Advanced Properties

  • Modified properties

  • Inherited properties

  • Default properties 

• Cuboid details, including cuboid count, size information, and total cuboid summary

• Time Information shows how long it took for:

  • Data transformation (to calculate transformations)

  • Create build cluster

  • Extract test data

• Miscellaneous information such as semantic model metadata size, Server version, and so on.

• Errors or warnings if any

To view the build summary, perform the following steps. 

1. From the Toolbox, choose Semantic Models.

2. Select a semantic model and click Process. 

3. Do one of the following:

   1. Right-click a build job from the list and choose Job Summary.

   2. From the Actions menu (...) menu choose Job Summary.

4. Navigate between different sections in the summary using the slider on the right. Click a section name to view the corresponding summary.
   

   

5. Download the semantic model process logs from a semantic model by using Download logs.

   You can also Data Profile Result, and then click Download logs. The log file is not available until the build finishes.

   By default, build logs are only stored for 30 days. You can manage this duration by specifying the value for BUILD_LOG_PURGE_INTERVAL property in the olapengine.properties through Kyvos Manager.

6. To view details for individual jobs performed in a process, click Show Job details. The details are displayed in a new browser tab.

   

6. To view aggregates, click Show Aggregates, and detailed information on aggregates is displayed in a new browser tab.

7. See the Consolidated Summary tab to view a consolidated summary of all the process jobs executed on the semantic model.

8. Click Close.

In the case of AWS deployments, the build summary will indicate whether Elastic MapReduce ( EMR )  is being created as part of the process.

Reporting an issue to Kyvos

From Kyvos 2023.5 onwards, you can report an issue that occurred during a query execution on the semantic model. You will view a Report an Issue link on the Job summary page. Click the link, and it will open a Report an Issue dialog box. The Job summary is attached by default. You can also upload additional details like log file if needed.

To report an issue, perform the following steps.

1. From the Toolbox, choose Semantic Models.

2. Select a semantic model and click Process. 

3. Double-click the Failed status in the Status column, which will open the Job Summary dialog.

4. Do one of the following:

   1. Right-click a build job from the list and choose Job Summary.

   2. From the Actions menu (...) menu choose Job Summary.

5. In the Job Summary dialog, click the Report an Issue link at the bottom of the page.

6. The Report an Issue to Kyvos dialog box is displayed.

   

7. On the Report an Issue dialog, you can do the following:

   1. Summary of the issue is displayed by default. You can modify the summary as needed.

   2. Describe the issue in details description by default. You can modify the description as needed.

   3. The error summary is attached by default. The Upload button is disabled and it is enabled only when you click Choose file to upload a specific summary file for better understanding of the error.

   4. Enter your email address where you would like to receive notifications and acknowledgments. 

8. Click Submit.