Versions Compared

Old Version 2

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

...

Applies to: (tick) Kyvos Enterprise  (tick) Kyvos Cloud (SaaS on AWS) (tick) Kyvos AWS Marketplace

(tick) Kyvos Azure Marketplace   (tick) Kyvos GCP Marketplace (tick) Kyvos Single Node Installation (Kyvos SNI)

...

Info

Note

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

Kyvos provides a selection of default formats. For example, you can format numbers, currency, dates, times, network IDs, and text. You can also set up a custom format.To format the selected item, perform the following steps: 

  1. Do one of the following:

    1. When a measure in a semantic model is selected, click the Actions menu (...) next to the Format property.

    2. When editing a format action in a dataset, in the Field Format Properties, click the ... in the Input Format column for the selected field.

    3. Select the format type, for example, Number. 

  2. Follow the instructions in the table below, then click Apply. 

Format

Description

Number

The format box shows the results of the current settings.

  1. Enter the number of decimal places.

  2. Specify how negative values are displayed –for example with a minus sign and parentheses (-1234).

  3. Click the checkbox to include thousands separators.

Currency

The format box shows the results of the current settings.

  1. Enter the number of decimal places.

  2. Specify how negative values are displayed –for example with a minus sign and parentheses (-1234).

  3. Select a unit type: None, Rs, $, or euros.

  4. Click the checkbox to include thousands separators.

Date

The format box shows the results of the current settings.

  1. Select a predefined format from the list. The number of letters indicates the number of values that will be shown. For example, yy or yyyy both indicate year, for example, 19 or 2019. M is month, d is day, y is year, q is quarter, H is hours, m is minutes, s is seconds, and a indicates am or pm.

  2. If you choose Custom, enter a custom format.

Time

The format box shows the results of the current settings.

  1. Select a predefined format from the list. The number of letters indicates the number of values that will be shown. H is hours, m is minutes, s is seconds, and a indicates am or pm.

  2. If you choose Custom, enter a custom format.

Duration

The format box shows the results of the current settings.

  1. Select a predefined format from the list. The number of letters indicates the number of values that will be shown. H is hours, m is minutes, and s is seconds.

  2. If you choose Custom, enter a custom format.

Percentage

The format box shows the results of the current settings.

Enter the number of decimal places.

Scientific

The format box shows the results of the current settings.

Enter the number of decimal places.

Text

The format box shows the results of the current settings.

Select a format type from the list: None, lower case, or upper case.
Note:

Applicable

Applicable for datasets only. Datasets are now deprecated.

Network ID

The format box shows the results of the current settings.

Select a format from the list: IP Address (IPv4) or MAC Address.
Note:

Applicable

Applicable for datasets only. Datasets are now deprecated.

Custom

Enter the format of the custom type.

...

Related topics