Document toolboxDocument toolbox

Job summary

Owned by Sarabjeet Kaur
Last updated: Nov 20, 2023
4 min read

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

  • 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. To view details for individual jobs performed in a process, click Show Job details. The details are displayed in a new browser tab.

Note
From Kyvos 2023.2 onwards, you can view job details for fact adjustment jobs (running in a local mode, on the BI Server), including the job name, start time, end time, and total time. Click the Show Job Details link to view the details. Additionally, on the Show Job Details page, you can download the job logs.

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

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

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



Copyright Kyvos, Inc. All rights reserved.