...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Applies to: 
Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (
...
Kyvos supports the SCOPE function and Default_Member MDX functions.
- SCOPE MDX function: The SCOPE MDX function writes the scripts on the semantic model design without rebuilding a semantic model.
For more information about the SCOPE function and its syntax, refer to Microsoft Documentation. - DEFAULT_MEMBER MDX function: This function is used to define a default member on a hierarchy. The default member evaluates reports based on thegiven member of the level instead of all members of each level in the respective hierarchy.
...
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 | ||
|---|---|---|
| ||
|
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.
- Create or edit an existing semantic model.
- On the Design tab, click the Actions menu (…), and then select Scripts. The Default_Member dialog box is displayed.
- In the right pane, click the Functions option and type Default_Memeber in the Search textbox. The Default_Memeber function is displayed.
- To use the Default_Memeber template, double-click the Default_Memeber. The template is displayed in the left pane.
- Start typing an expression in the editor section of the dialog box.
As you enter text, suggested subcube expressions, semantic model, dimensions, members, and so on are displayed. You can also see a description of the selected function.
To view a list of functions along with the detailed description, navigate to the Functions tab and select a function from the list.
You can also define Default member in the script using supported member functions. See the supported member function in the Supported MDX Functions.
- You can also perform the following:
- Add, update, get, or delete the script using the REST APIs on the cube design. See Kyvos REST APIs Guide for more details.
- Modify or remove the script.
- In the editor section, modify the script as needed.
- To delete the script, you need to first select the script and press the Delete or Backspace key.
- Enable or disable the script.
By default, the Default_Member script is enabled. On disabling the script, the Default_Memeber calculations do not apply while querying.- To disable the script, click the Properties option, and then select the Disable checkbox. The script is disabled for that cube. Click the i icon to learn more.
- To disable the script, click the Properties option, and then select the Disable checkbox. The script is disabled for that cube. Click the i icon to learn more.
- Click Validate to validate your criteria.
If you have made changes and don’t want to keep them, click Cancel. - Click Save.
...
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.
.png?version=1&modificationDate=1692767755000&cacheVersion=1&api=v2&effects=border-simple,blur-border&width=600)