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.

• Adding Attributes

• Processing metadata for attributes

Adding Attributes

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.
      
      

      Open

      

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 hybrid multidimensional 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.

Open

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.

Processing metadata for attributes

Kyvos now supports managing metadata processing for attributes through the Kyvos Web Portal.

To process metadata for attributes, perform the following steps.

1. From the Toolbox, click Semantic Models.

2. Select a semantic model from the list. 

3. Locate the dimension you want to change. Expand the dimension and choose attribute. The Attributes Properties section is displayed.

   Open

   

4. Select the required value from the Process list:

   1. Metadata and Data: Kyvos will generate dimension values metadata during the semantic model processing, enhancing query performance. This may result in additional costs and processing time.

   2. Data Only: Kyvos does not generate dimension values metadata during the processing of semantic models, which can lead to slower queries and certain limitations. It is advisable only for columns where aggregate queries are neither applicable nor expected.

5. Click Save.