From our testing the new HierarchySubset functions don't work as advertised in PA 2.0.3 (in fact don't work at all)
For example
HierarchySubsetElementGetIndex(sDim, sHier, sSub, sEle, nIdx);
Always returns the value given by the starting index nIdx regardless of the element name passed in.
e.g.
HierarchySubsetElementGetIndex(sDim, sHier, sSub, sEle, 1);
will always return a value of 1 and NOT the index position of the element sEle in the subset sSub.
And this function's twin also has issues
HierarchySubsetGetElementName(Dim, sHier, sSub, nIdx);
Will return an index out of range error rather than the element name when a valid subset index value is passed.
For anyone with a semi- large or sophisticated model in production where there is any evaluation of subsets and iterating subset members this is pretty much a "no go" for upgrading from 10.2.2 to PA.
Can anyone with access to PA 2.0.4 confirm if this bug is fixed in the latest release?
HierarchySubset functions don't work
-
- MVP
- Posts: 3685
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
HierarchySubset functions don't work
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- Steve Rowe
- Site Admin
- Posts: 2440
- 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: HierarchySubset functions don't work
Did you try the old version of the function but using dimname:hiername for the dimension argument?
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- MVP
- Posts: 3685
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: HierarchySubset functions don't work
Yes. But this isn't accepted and throws a dimension doesn't exist error.Steve Rowe wrote: ↑Wed Feb 07, 2018 12:02 pm Did you try the old version of the function but using dimname:hiername for the dimension argument?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.