Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Version published after converting to the new editor

Applies to:Image ModifiedKyvos Enterprise  Image ModifiedKyvos Cloud (Managed Services on AWS)  Image ModifiedKyvos Azure Marketplace

Image ModifiedKyvos AWS Marketplace  Image ModifiedKyvos Single Node Installation (Kyvos SNI)  Image ModifiedKyvos Free (Limited offering for AWS)

...

When you define a semantic model, you add dimensions and measures. In Source Fields, the circled numbers next to candidate measures and dimensions indicate how many times each one is used in the design.

...

  1. From the Toolbox, click Semantic Models.
  2. Click the Actions menu (  ) at the top of the Semantic Models column.
  3. Click Add Semantic Model.
  4. Enter a name for the semantic model.
  5. Select a Relationship from the list and click Add.
    You can enter a term in the search box to quickly find a name.
  6. Do one of the following:
    1. 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.
    2. 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.
    3. 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.
  7. Right-click at the Dimension or Measure Group levels to rename them and add lower levels.
  8. Right-click at the lower levels to rename the item you selected or add items at that level.
  9. Click the Actions menu(...) menu near the top of the page and choose Validate. See Validating semantic model.
  10. Click Save.


...

Tip
titleTip

You can use wild card characters% (and) while naming attributes, levels, hierarchies, dimensions, measure groups, measures, and calculated measures.

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. 

...