Hierarchy Functions

Post Reply
MarenC
Posts: 90
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Hierarchy Functions

Post by MarenC » Wed Jun 24, 2020 10:09 am

Hi,

If hierarchy creation is enabled should I always use Hierarchy functions instead of dimension functions?

So HierarchyElementInsert instead of DimensionElementInsert, HierarchyElementComponentAdd instead of DimensionElementComponentAdd etc?

Maren

ascheevel
Community Contributor
Posts: 159
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Minneapolis, USA

Re: Hierarchy Functions

Post by ascheevel » Wed Jun 24, 2020 1:06 pm

For modifying the base hierarchy of the dim, you can continue to use the original functions. For modifying the alternate hierarchies, you'll absolutely need to use the hierarchy functions.

MarenC
Posts: 90
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Hierarchy Functions

Post by MarenC » Thu Jun 25, 2020 1:56 pm

thanks ascheevel.

So if hierarchy creation is enabled then it is probably better to use the hierarchy functions even for the default/base hierarchy, I guess my question was if hierarchy creation is enabled does this make the dimension functions moribund?

Maren

Wim Gielis
MVP
Posts: 2460
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Hierarchy Functions

Post by Wim Gielis » Thu Jun 25, 2020 3:42 pm

MarenC wrote:
Thu Jun 25, 2020 1:56 pm
if hierarchy creation is enabled does this make the dimension functions moribund?
True. Even if hierarchy creation is disabled they can still be used.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

Post Reply