Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When you process a semantic model, you can set up a schedule for when it gets refreshed, and you can specify whether you want to create an incremental or full process. Use a data profile build process to help optimize the processing of the semantic model. When you use semantic model recommendations on an already processed semantic model, you can use the update aggregates option to update only the aggregates in the semantic model.

...

  • Click Schedule Job. Use this option to create a full, incremental, or test data process and update aggregates.

  • Click the Actions menu (...) menu and click Add Other Jobs. Build Process jobs include dropping partitions, cache, and data profile.

...

  • Full data process: Recreates the semantic model with all available data, including recalculating all aggregations. This option can be slow, depending on the size of your data.

  • Incremental data process: Updates only the latest changes to an existing semantic model. This option is faster than a full buildprocess. For example, use it to update the semantic model with daily changes. You can also replace already processed data using the replace partition option.
    NOTE: You can run an incremental build process only on a successfully built processed semantic model.
    In an incremental buildprocess, you can process the following:

    • All new data: Detects new incremental data in all the files used in the cube semantic model design and processes it.

    • Only fact adjustments:Detects incremental data only in the fact files used in the cube semantic model design and processes only the adjustable measure.

  • Test data process: Processes the semantic model on the sample data. You can choose the number of rows, aggregation, and data partitions to be considered in this process.

  • Update Aggregates: Updates only the aggregates in a process to improve query time. You can also specify the partition to use for updating aggregates. 
    NOTE: You can schedule this build process only on a successfully built processed semantic model.

Other Process Jobs

  • Drop Partition: Drops a whole partition from the process. This option is only available if you are using partitions.

  • Cache buildprocess: Sets up cache rules and specifies actions for historical and metadata queries.

  • Data Profile: Sets profiling options, sampling options, and properties to help you optimize building processing a semantic model. 

Deprecated process types

Use consolidation builds processes to merge incremental processes into a consolidated semantic model that improves query performance. For example, if you do an incremental build process daily, you may want to do a monthly consolidation buildprocess.

  • Consolidation process: Consolidates the original full process and subsequent incremental data processes to create a single full current semantic model. You can combine or combine and balance processes. If there are query performance issues with incremental data processes, use the Combine and balance process option to improve query performance.

  • Forced Update Partition : Replaces a whole partition in the process. This option is only available if you are using partitions. In its place, use the incremental process option and the replace partition option.

...