...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Applies to:Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace 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.
...
- 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.
- Click the Add Dimension button, which is the plus sign next to the header of the Dimension column.
- 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.
- 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.
- 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
...