Page 1 of 1

MDX - weight of a member

Posted: Mon Oct 28, 2019 11:13 am
by Wim Gielis
Hi all,

This one has made me curious:
03.png
03.png (44.9 KiB) Viewed 5824 times
Syntax
The weighting property controls how a child member rolls up to its immediate parent, whether that child is also a parent of another consolidation or just a leaf member. Top level consolidations do not have weight.
Please refer to this page

Can someone shed some light and provide an example ?

Best regards,

Wim

Re: MDX - weight of a member

Posted: Mon Oct 28, 2019 1:49 pm
by lotsaram
Pretty sure this was introduced in order to support the subset editor in Workspace (and PAfE).

Re: MDX - weight of a member

Posted: Mon Oct 28, 2019 7:51 pm
by Wim Gielis
Thanks. Indeed I hadn’t seen it earlier.

Re: MDX - weight of a member

Posted: Tue May 12, 2020 11:26 pm
by PlanningDev
Not to drag up an old post but did anyone figure out the syntax of how to use this? I was looking for a way to filter for all elements that have a weight not equal to 1. I realize weighting is based up on the elements relationship to a parent but there isn't any documentation on the syntax and it would be nice to use this if possible

Re: MDX - weight of a member

Posted: Tue May 26, 2020 1:43 pm
by Mark RMBC
Hi,

The answer I got on this was:

"the weight expression seems more of an internal mechanism, not really built for something like filtering. We (IBM) would recommend filtering using another method"

Regards,
Mark

Re: MDX - weight of a member

Posted: Tue May 26, 2020 1:59 pm
by Steve Rowe
Couldn't you use the Elweight function to pull the value out into an attribute and then run your MDX filter versus the attribute value?