Versions Compared

Old Version 3

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version 4

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

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

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

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

...

Kyvos supports the SCOPE function and Default_Member MDX functions.  

...

Kyvos supports the Default_Member MDX function, which enables you to evaluate reports by considering the specified member instead of all members of the hierarchy.

Info
titleInfo
  • This function is only used to evaluate expressions when a given hierarchy is not included in a query. 
  • From Kyvos 2023.2.1 onwards,  
    • Member functions can be defined in the Default_Member script. See the Supported MDX Functions section for more details. 

    • The Default Member script is now supported for the DAX interface. 

    • If you drag the default member onto the filter shelf in Excel, the data corresponding to the default member is automatically filtered. See the Connection to Excel section. 

For example, if you have dragged the [Measure].[Sum Sales] measure from the Order Date semantic model onto the visualization; you will see the aggregated value. This value considers all members of each hierarchy from every dimension related to this measure. However, when the default member is set for a hierarchy, instead of considering every member of that hierarchy, it will only consider the value of the Default Member.

To create a script using the Default_Members function, perform the following steps.

...

Alter Cube [AdventureWorksMF]
Update Dimension [Customer].[Geography],
default_Member = [Customer].[Geography].[Country].&[Canada].firstchild;

If you connect to Excel and drag 'Country' onto the filter shelf, 'Alberta' will be automatically selected as the first child of Canada, as defined in the default member script.