Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note Kyvos supports naming semantic model entities in the ENTITY_ format, such as DIMENSION_, DIM_,and MEASURE_, and so on. From Kyvos 2024.9 onwards, you can suspend any unused semantic model. You can also resume the usage of a suspended semantic model when needed. |
Designing a semantic model
| Anchor | ||||
|---|---|---|---|---|
|
To design a semantic model, perform the following steps.
From the Toolbox, click Semantic Models.
Click the Actions menu ( ⋮ ) at the top of the Semantic Models column.
Click Add Semantic Model.
Enter a name for the semantic model.
Select a Relationship from the list and click Add.
You can enter a term in the search box to quickly find a name.
Do one of the following:
Right-click in the Dimension or Measure areas to add dimensions or measures.
By default, the name of the data source table from which the first measure is created in the measure group is taken as the measure group name. However, if you have created a measure group with a custom name, then dragging a measure in it would not impact the name of the measure group.Drag candidate measures or dimensions to the semantic model design worksheet to the areas for measures and dimensions. Use Ctrl+click to select multiple fields.
Click the plus buttons in the Dimension or Measure columns to add additional dimensions or measures. Then select candidate measures or dimensions from the candidate lists on the left.
Right-click at the Dimension or Measure Group levels to rename them and add lower levels.
Right-click at the lower levels to rename the item you selected or add items at that level.
Click the Actions menu(...) menu near the top of the page and choose Validate. See Validating semantic model.
Click Save.
| Tip |
|---|
Tips You can click the Expand All icon next to the Tips icon to expand all dimensions and measures, or if they are expanded, you can click the Collapse All icon in the same location to collapse them.   |
Selecting dimensions and measures
...
| Tip |
|---|
Tips You can use wild card characters % (and) while naming attributes, levels, hierarchies, dimensions, measure groups, measures, and calculated measures. |
Suspending a semantic model
| Anchor | ||||
|---|---|---|---|---|
|
You can suspend any unused semantic model. When you suspend the semantic model, you cannot query or browse it.
To suspend a semantic model, perform the following steps.
From the Toolbox, click Semantic Models.
Select a semantic model from the list.
Right click the semantic model and select the Suspend Usage option from the list. The semantic model is suspended.
Resuming a suspended semantic model
| Anchor | ||||
|---|---|---|---|---|
|
You can also resume the usage of a suspended semantic model when needed. When you resume the usage of the suspend the semantic model, you can query or browse it.
To resume a suspend semantic model, perform the following steps.
From the Toolbox, click Semantic Models.
Select a semantic model from the list.
Right click the semantic model and select the Resume Usage option from the list.
On the confirmation dialog box, click Resume. The suspended semantic model is now available for querying and browsing.
Filtering
Use the Filter panel, which by default is located below the Properties pane, to filter dimensions and measures. If the Filter panel is collapsed, click the Actions menu ( ⋮ ) next to Filter and select Expand.
As you select filter settings, the dimensions and measures lists adjust based on your criteria. Use filters to get insight into your data. For example, you can set Invalid to Yes to swiftly view all invalid items. Click Clear to clear the settings in that filter.
...