Versions Compared

Old Version 23

changes.mady.by.user NIDHI BHANDARI

Saved on

compared with

New Version 24

changes.mady.by.user NIDHI BHANDARI

Saved on

Key

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

...

Aura tab collection
paramsJTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJ3aWR0aCUyMiUzQTElMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyM2NjY2VjZiUyMiU3RCU3RCU3RCU3RA==

Aura tab
summaryKyvos versions up to 2024.1
paramsJTdCJTIydGl0bGUlMjIlM0ElMjJLeXZvcyUyMHZlcnNpb25zJTIwdXAlMjB0byUyMDIwMjQuMSUyMiU3RA==

  1. Login to Kyvos Manager and navigate to Properties > queryengine.properties .

  2. In the queryengine.properties, search for the DS_CONNECTION_CONF property

    • The default value will be Blank  

    • Set this value as SET memory_limit='10GB'; SET THREADS to 1; and then save it. 

  3. Restart the Query Engine services from the Kyvos Manager dashboard.

For memory configuration, perform the following post-deployment steps.

  1. Open the Kyvos Java options page in Kyvos Manager and Navigate navigate to the Query Engine section. 

  2. If Configure Heap memory for Query Engine is set as Auto, no change is required. 

  3. If Configure Heap memory for Query Engine is set as Manual, reduce Off-Heap memory by 10 GB. 
    For Example, Suppose the total machine memory is 128 GB, whereas 45 GB is assigned to Heap, and 66 GB is assigned to Off-Heap. In that case, you need to set Heap as 45 GB and Off-Heap as 56 GB so Kyvos can use the remaining 10 GB internally for the new data store-based architecture. 

Aura tab
summaryKyvos 2024.1.1 onwards
paramsJTdCJTIydGl0bGUlMjIlM0ElMjJLeXZvcyUyMDIwMjQuMS4xJTIwb253YXJkcyUyMiU3RA==
Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Before enabling Kyvos Analytical Store, ensure that Query Engine cluster is running with the required (Full, high, moderate, or Low) capacity, and disable cluster scaling. For more details about cluster scaling, see the Managing system scheduling and capacity sectionthis, set the value of ELASTIC_DEPLOYMENT should be set as Disable.

  1. Login to Kyvos Manager and navigate to Properties > global.properties To enable this feature, set .

  2. Set the value of the ENABLE_KYVOS_ANALYTICAL_STORE property to 'Yes.' After configuring the Kyvos Data Store value, you must disable cluster scaling. Achieve this by setting the ELASTIC_DEPLOYMENT property to 'Disable.as Yes.

  3. Restart all Kyvos services (BI Server, Query Engine, and Kyvos Web Portal) from the Kyvos Manager dashboard. This will ensure that

  4. Open the Kyvos Java options page in Kyvos Manager and navigate to the Query Engine section, and ensure that the Configure Heap memory for Query Engine is set as Auto. Kyvos will now automatically configure memory used for the Analytical Store.

Enhancements in Kyvos Analytical Store

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

Support for

Kyvos Analytical Store is certified only when the cuboid replication type is set to 'Local' on the semantic model. You can do this through the kyvos.cuboid.replication.type property.

  • Support for Decimal type measures:The Kyvos Analytical store efficiently stores, retrieves, and queries big decimal measures created via Kyvos. This release supports reading 128-bit decimal numbers via Parquet files with the help of a fixed-length byte array.

  • Kyvos Analytical Store statistics:With this release, users can now see Kyvos Analytical Store statistics on the Activity Monitor. To view the Kyvos Analytical Store information, navigate to the Activity Monitor, then click the Query Engine. A detailed view dialog box is displayed. The information displays the total number of available Analytical Store connections and the number of connections currently being used. Users can also check the total amount of memory available and the percentage of memory used.

    image-20240118-093934.png

  • Support for Parent-Child Hierarchy (PCH): With this release, Kyvos supports processing and browsing the semantic models having parent-child hierarchy, alternate hierarchy, and custom rollups in the Kyvos Analytical Store.

  • Support for attribute level smart aggregates: This release supports attribute level smart aggregates in Kyvos Analytical Store.