Changing the materialization of levels

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

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

Instead of removing a level, you can partially materialize it in the hierarchy. You can also reduce or increase the level of materialization. After you change the materialization of a level, you need to do an incremental process.

Note

Kyvos supports naming semantic model entities in the ENTITY_format, such as DIMENSION_ , DIM_ , and MEASURE_ , and so on.
You can't delete a level because it may break the hierarchy.

To change the materialization of a level, perform the following:

Open a semantic model and select Refine.
Click the Aggregation Strategy tab.
Confirm that the Mode is set to Expert (User Driven).
Set a value for the Precompute level threshold, which uses the kyvos.process.precompute.hierarchy.levels property.
To select the level on which you want to change partial materialization, click the Actions menu (...) next to Selective hierarchy materialization.
You can view the current value settings and click to the right of the names of the values to change the settings.
Click Apply.
Click Save.
Process the semantic model. See Scheduling semantic model processes

Related topics