Versions Compared

Old Version 7

changes.mady.by.user Pallavee Dutta (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user NIDHI BHANDARI

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

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

...

You can use dimension attributes as part of your analysis to tease out more information—for example, if you were researching airline travel habits you could see on which days of the week most people travel for business travel, vacation travel, etc. Or, you can use them to find out which colors were most popular for a particular season, year, or garment.

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

  • Kyvos supports naming cube 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 alphabetic 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.

To add a level sort field, in Level properties, select Sort Field. 

...

Methods to move dimensions, attributes, or levels

...