WTD

WTD

This documentation is for Kyvos 2026.6.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.6.x. To view documentation for other Kyvos versions, click here.

Description:

This function is used to return a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Week level in the Time dimension.

Syntax:

Wtd( [ Member_Expression ] )

Return type:

SET

Parameters:

Parameter

Description

Parameter

Description

Member_Expression

It is a valid MDX expression that returns a member.

Example:

with member [Measures].[SWTD] as Sum(WTD([Orders Date].[H_Orders Date].[Week].&[2014]&[1]&[1]&[3]), [Measures].[Sum Sales]) SELECT [Measures].[SWTD] ON 0 from [Order Date]

 

Copyright Kyvos, Inc. 2026. All rights reserved.