Planning Analytics - Refresh Attribute Hierarchies

Post Reply
RSK
Posts: 47
Joined: Mon Oct 08, 2012 12:02 pm
OLAP Product: TM1 10.1.1
Version: TM1 10.1.1
Excel Version: 2010

Planning Analytics - Refresh Attribute Hierarchies

Post by RSK » Fri Jun 15, 2018 12:41 pm

Hi,

I'm just messing around with creating Attribute based hierarchies in PAw.

From what I understand so far any changes in dimensional structure and/or changes in attribute values will not automatically refresh the attribute hierarchy.

Is there a command that can be run via TI to do this?

Thanks

Wim Gielis
MVP
Posts: 1782
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Planning Analytics - Refresh Attribute Hierarchies

Post by Wim Gielis » Fri Jun 15, 2018 2:00 pm

A combination of the functions HierarchyDestroy and CreateHierarchyByAttribute could be useful.
But I haven't tested what happens if you use the hierarchy in say a view, you destroy it, then recreate.
If the view appears to be broken, then please post back.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

RSK
Posts: 47
Joined: Mon Oct 08, 2012 12:02 pm
OLAP Product: TM1 10.1.1
Version: TM1 10.1.1
Excel Version: 2010

Re: Planning Analytics - Refresh Attribute Hierarchies

Post by RSK » Fri Jun 15, 2018 2:14 pm

I'll take a look further Wim.

You would have thought IBM would have considered making this a bit easier than having to manually create TI's yourself especially when they are driving the user via GUI to create them in the first place.

User avatar
tomok
MVP
Posts: 2474
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Planning Analytics - Refresh Attribute Hierarchies

Post by tomok » Fri Jun 15, 2018 7:24 pm

RSK wrote:
Fri Jun 15, 2018 2:14 pm
You would have thought IBM would have considered making this a bit easier
Having an automated process for this doesn't sell software. Having the attribute-based hierarchies in an easy to demo web tool does. Simple as that. I'm sure they'll eventually get around to it if they can focus on day-to-day PA functionality instead wasting all their time trying to get everyone to move to the "IBM Cloud".
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Post Reply