Applies to:
Kyvos Enterprise Kyvos Azure MarketplaceKyvos AWS Marketplace Kyvos Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI) Kyvos Free (
...
A dimension is a structure that categorizes facts and measures, allowing users to answer business questions. Commonly used dimensions are people, products, places, and time. Dimensions typically provide filtering, grouping, and labeling.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note Kyvos supports naming cube entities in the the ENTITY_ format format, such as as DIMENSION_, DIM DIM_, and and MEASURE_, and so on. |
The elements of a dimension can be organized as a hierarchy - a set of parent-child relationships, where a parent member summarizes its children.
...
Levels of data range from the most summarized (up) to the most detailed (down).
You can add, name, and rename dimensions, define a hierarchy level, add levels, and set up attributes.
Note that some properties include an information icon you can click to learn more about that item.
To learn about attributes, see Attributes.
To add a dimension, perform the following steps.
From the Toolbox, click Semantic Models.
Select a semantic model from the list.
To add a dimension, do one of the following:
Click the Add Dimension button, which is the plus sign next to the header of the Dimension column.
A new dimension is created in the list. By default, it is named Dimension and includes a hierarchy and level, and attributes.Right-click in the dimension column and choose Add Dimension to add the first dimension group.
Drag a candidate dimension from the list on the left into the dimension column.
You will see an indicator, for example, Drop as dimension or Drop as level to guide you.
Do one of the following:
Right-click the default name, choose Rename, then enter a name.
Edit the properties in the Properties column and change the name.
The other property choices vary depending on the item you are editing.
Choose the type: regular, time, or location. You may also see bridge which is only available when a bridge node is available in the relationship.
The available choices are based on the data type you are using.Regular dimensions are typically people, products, or places.
Time hierarchies use time and date-related data. If you have a Custom Calendar, you can click the checkbox to use a custom calendar hierarchy in your time dimension.
Location hierarchies use location-related data (such as country, state, county, city)
To use any of the facts or dimensions from a many-to-many dataset, you must create a bridge dimension in the semantic model Physical view.
Choose the hierarchy and field based on the type by clicking the dimension and making a selection in the properties.
If this is a time hierarchy, choose Year-Month-Day, Year-Quarter-Month, Year-Quarter-Week-Day, or Year-Quarter-Month-Week-Day. See the time hierarchies section for more details.
If there is not a pre-defined time hierarchy shown, set the field data type to a Date type such as year-quarter-month.If this is a Location hierarchy, and location data is available, choose from the country choices, such as city, state, country, and postal code. Select a field from the last level of the hierarchy and the others are automatically fetched.
Choose a field from the list.
Choose whether to materialize the data. Yes means this field will be part of the built cube and No means that it won't be included in the semantic model.
If appropriate for the data you are using, click Is a Slowly Changing Type 1 Dimension. See Slowly changing dimensions.
Optionally, add a description of up to 200 characters. The optional description is used when you hover the cursor over the dimension in a worksheet.
...
Time hierarchiesAnchor timehierarchies timehierarchies
Kyvos allows you to use time hierarchies in two ways:
Predefined: These are pre-created hierarchies in the system. You can select and add them to the cube from the hierarchies list from Year-Month-Day, Year-Quarter-Month, Year-Quarter-Week-Day, or Year-Quarter-Month-Week-Day.
Custom: In this type, you can define different date values for different columns. For example, year=2021 and month=09. In this case, you can drag individual columns and set up the field data type to each field such as year-quarter-month-day.
You can use the following to indicate time values:
Year: YYYY -2020
Quarter: Q1, Quarter1, 1 , 01
Month: Jan, January 01, 1
Week: w1, 01, 1, Week1
Day: 01, 1
If your data contains values like " 2020-Sept " for a month, it is not a true month value and you will need to convert the data to a supported format.
...
Related topics