Versions Compared

Old Version 2

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user DocReviewer

Saved on

Key

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

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)

...

Kyvos supports a Dynamic Measure title that can be applied to a worksheet or Dashboard. When the value of a dimension filter is changed, the measure title will automatically update to reflect the selected value of the dimension filter. See the Filtering data in worksheets section for more details. 

...

  • Measure value: Displays the M easure value when the filter value is changed. 

  • Measure title: Displays the Measure title along with the Measure value. You can also reuse the Measure title for other Measure values.

Sample Expression

For example, you have a semantic model with a dimension called 'Calculation Type,' and this dimension has members such as MTD, YOY, YTD, and so on. Multiple calculated measures are created in the semantic model, and their values depend on the Calculation Type filter selected in the view. When you modify the filter value, the title of the measure will change accordingly.

Consider an example where a Calculated Measure displays a dynamic title, i.e., 'Dynamic Caption'.

  • Following is the sample expression for a dynamic Measure value

    Code Block
    iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YOY],
"YOY ",
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YTD],
"YTD ",
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[MTD],
"MTD " ,null)))

  • Following is the sample expression for a dynamic Measure title

    Code Block
    iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YOY],
[Measures].[YOY Sales],
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YTD],
[Measures].[YTD Sales],
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[MTD],
[Measures].[MTD Sales],null))), DYNAMIC_CAPTION = [Measures].[Dynamic Caption] + "On Sales"

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

  • The changes are specific to the Kyvos Visualization layer and will not impact any third-party BI tool.

  • When the filter is not applied to the Calculation Type Hierarchy or is applied to multiple members of the hierarchy, the Measure Name (also referred to as the static caption), as displayed in the above example (such as 'On Sales'), will be shown. However, if the filter is applied to a single member of the Calculation Type Hierarchy, the Measure value you have set by using the DYNAMIC_CAPTION function will be displayed on the KPIs,  charts, labels, titles, axes, tooltips, and legends.

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

...