Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Note

Optimization is applicable only to specific LOD queries.

Step 1: Add a kyvos.cuboid.balance.type property with the value SEMANTIC_MODEL in the Advanced Semantic Level Property.

  1. Open the semantic model.

  2. Go to the Refine Model tab and then click Advanced Properties.

  3. Click Add Property.

image-20240701-101531.png

The property will be added to the Miscellaneous.

image-20240701-101843.png

Step 2: Trigger the REPLICATE_SEMANTIC_MODEL_ON_NODE REST API on the BI Server to ensure that all the cuboids of the semantic model point to a single Query Engine.

Find out the Query Engine node name and replace the semantic model (CUBE_ID) and Query Engine name (QE_NODE_NAME) in the following URL:

http://<CLIENT_IP_ADDRESS>:<PORT>/kyvos/rest/custom/performServerAction?hostName=<Query Engine hostname>&port=<Query Engine port>&instanceName=BI%20Server&component=olapengine&metadata=service&data=%7B"SERVICE_NAME":"REPLICATE_SEMANTIC_MODEL_ON_NODE","CubeID":"<%CUBE_ID%>", "QE_NODE_NAME":"<%QE_NODE_NAME%>"%7D 

Step 3: To replicate the cuboids on Query Engine, restart Query Engine.

  • No labels