Document toolboxDocument toolbox

Adding attributes

Owned by Sarabjeet Kaur
Dec 05, 2023
3 min read

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

Kyvos Azure Marketplace   Kyvos GCP Marketplace 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.

Use the attribute display folder to organize different metadata objects such as attributes.

The optional description is used when you hover the cursor over the dimension attribute in a worksheet.

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 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

  • When using the Design tab, you can drag an item to a different dimension. You will see a placeholder indicator, for example, Drop as dimension.

  • When you select an item, you can use the Properties pane to select a different dimension.

  • You can right-click an attribute and choose Move to Hierarchy.

Copyright Kyvos, Inc. All rights reserved.