MDX - weight of a member

Post Reply
Wim Gielis
MVP
Posts: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

MDX - weight of a member

Post by Wim Gielis »

Hi all,

This one has made me curious:
03.png
03.png (44.9 KiB) Viewed 5021 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
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: MDX - weight of a member

Post by lotsaram »

Pretty sure this was introduced in order to support the subset editor in Workspace (and PAfE).
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Wim Gielis
MVP
Posts: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: MDX - weight of a member

Post by Wim Gielis »

Thanks. Indeed I hadn’t seen it earlier.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: MDX - weight of a member

Post 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
Mark RMBC
Community Contributor
Posts: 292
Joined: Tue Sep 06, 2016 7:55 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: MDX - weight of a member

Post 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
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: MDX - weight of a member

Post 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?
Technical Director
www.infocat.co.uk
Post Reply