Versions Compared

Old Version 1

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user DocReviewer

Saved on

Key

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

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

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

  • Kyvos supports naming cube semantic model entities in the  ENTITY_  format, such as  DIMENSION_,  DIM_,   and  MEASURE_, and so on.

  • From Kyvos 2023.2 onwards, you no longer need to perform an extra click on the Attributes folder to view attributes in third-party tools. If a dimension contains attributes, the Attribute folder, which typically holds these attributes, will not be displayed when connecting the semantic model to third-party tools. Instead, you will see a tree structure comprising the dimensions and attributes (without the parent Attribute folder) you provided in the semantic model designer.

To add a dimension attribute, perform the following steps. 

  1. From the Toolbox, click Semantic Models.

  2. Select a semantic model from the list. 

  3. Do one of the following:

    1. Click the plus sign, and a dimension named Dimension is added with a default level and attribute. 

    2. Locate the dimension you want to change. Right-click Attributes and choose Add Attribute.

  4. Edit the properties to define the attribute.

    1. Choose a Type: Location or Regular.
      The available choices are based on the dimension type you are using.

    2. Select a field.
      You can also click Search and type a name into the Search text box to find it faster.

    3. You can also specify a Display Field. This specifies the name shown and where the new attribute is located in the hierarchical structure.  
      For example, you may use a department number but want to display a department name.

    4. You can also specify a Sort Field. This allows sorting of data for the selected attribute based on the selected sort field, when using Kyvos visualization tools such as worksheets. From Kyvos 2023.3 it is applicable for BI tools like Tableau, Power BI, and Excel, except MicroStrategy

  5. If you are using user-defined member properties, select a property and click Settings. See User-defined member properties. These properties allow you to perform analysis based on additional information about the dimension members.

  6. If you are using a HOLAP semantic model, you can specify whether to materialize the attribute. Yes means the field will be a part of the processed semantic model, and No means it will be excluded.

  7. Add an optional description of up to 200 characters. The optional description is used when you hover the cursor over the attribute in a worksheet.

...