Formatting measures

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 provides a selection of default number formats which include numbers, currency, percentage, scientific, and custom.

Note

Kyvos supports naming semantic model entities in the ENTITY_ format, such as DIMENSION_ , DIM_ , and MEASURE_ , and so on.

To change the format, perform the following steps.

From the Toolbox area, select Semantic Models.
Select a semantic model from the list, and from the Design tab, select a measure from the Measures column.
View the Properties for that measure on the right side of the page.
Select the Visible checkbox to make the field visible in worksheets. Click the i icon to learn more.
To change the Format, click the Actions menu (…) button. Click the i icon to learn more.
Choose the desired format type from the list and enter relevant values.
Click Apply.

For details on using the formatting options, see Format types table.

Hiding Dimension column

Some dimension columns (levels or attributes) in the semantic model are used only as calculated expressions and are not useful for business analysis. You can hide such dimensions from the Kyvos UI on the Semantic Model Designer page. Hence such hidden dimension columns are unavailable for business users for visualization on Kyvos UI or any third-party tool.

When you hide a Dimension column, all the levels are hidden automatically. You can also hide columns at a hierarchy or an attribute level but cannot hide columns at a level stage.

You can view all the hidden columns on the Semantic Model Design page to design and process a semantic model.

All hidden columns can be:

Exported and imported via cab export or import. See, Importing and exporting Kyvos objects and semantic model metadata for more details.
Exported as a part of the field lineage. See Exporting data lineage for more details.

To hide the Dimension column, perform the following steps.

From the Toolbox area, select Semantic Models.
Select a semantic model from the list, and from the Design tab, select a dimension from the Dimension column.
View the Properties for that dimension on the right side of the page.
Clear the Visible checkbox to make the field invisible in worksheets. Similarly, select the Visible checkbox to make the field visible in worksheets. Click the i icon to learn more.