}Views_* and }Subsets_* control dimensions

Post Reply
User avatar
qml
MVP
Posts: 1080
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.8 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

}Views_* and }Subsets_* control dimensions

Post by qml » Wed Jan 30, 2019 12:17 pm

This is a bit of a public service announcement and a bit of a question. I have noticed that as of PA 2.0.5 there are new control dimensions available which list all existing public views and subsets:
- Dimensions named '}Views_cube' list public views associated with each cube.
- Dimensions named '}Subsets_dimension' list public subsets associated with each dimension.

This makes it quite a bit easier to maintain/update/manipulate/count/clean up existing objects as it's no longer necessary to search for *.vue and *.sub files in the file system. I have already created a few useful tools based on these objects and they work a treat.

The question is - does anyone know which exact version this was introduced in? I'd like to know the minimum version my new TIs require to work. I think I've missed the grand announcement about this being added. :D
Kamil Arendt

lotsaram
MVP
Posts: 3330
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: }Views_* and }Subsets_* control dimensions

Post by lotsaram » Wed Jan 30, 2019 3:48 pm

The }Views_ }Hierarchies_ & }Subsetts_ control dimensions have been there right from PA 2.0

However be aware that in 2.0.6 IBM changed how }Subsets_ dimensions are implemented. It is a change for the better, but if you had already developed tools based on the old structure then still a pain to update.

Likewise I really, really hope that IBM don't decide to remove the dimension:hierarchy elements from }Dimensions. As that would completely destroy many of the new tools I have for administering PA models.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
Alan Kirk
Site Admin
Posts: 6004
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: }Views_* and }Subsets_* control dimensions

Post by Alan Kirk » Wed Jan 30, 2019 3:56 pm

Like Lotsa said, it's been there from 2.0. Remember the good old days when there were "What's New" .pdfs and you could just search for a feature?

Aaaah, nostalgia, man... it ain't what it used to be.

Nonetheless there are still such lists available though these days you have to poke and prod through them since Google runs away screaming when it tries to navigate IBM's web site. You'll find the change mentioned in the 2.0 What's New for the server.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
qml
MVP
Posts: 1080
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.8 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: }Views_* and }Subsets_* control dimensions

Post by qml » Wed Jan 30, 2019 4:37 pm

Fantastic, thanks both for the useful details. Both my googling and observational skills are in dire need of an upgrade!
Kamil Arendt

Wim Gielis
MVP
Posts: 2289
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: }Views_* and }Subsets_* control dimensions

Post by Wim Gielis » Thu Jan 31, 2019 9:44 pm

lotsaram wrote:
Wed Jan 30, 2019 3:48 pm
Likewise I really, really hope that IBM don't decide to remove the dimension:hierarchy elements from }Dimensions. As that would completely destroy many of the new tools I have for administering PA models.
True. On the other hand, we should review existing code too when there is a loop over elements in the dimension }Dimensions, since hierarchies can be part of that list too. We should make sure that everything translates well in the case of names like dim:hier instead of dim. With an entire library of TI processes this isn't an easy job.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

lotsaram
MVP
Posts: 3330
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: }Views_* and }Subsets_* control dimensions

Post by lotsaram » Thu Jan 31, 2019 9:55 pm

Wim Gielis wrote:
Thu Jan 31, 2019 9:44 pm
True. On the other hand, we should review existing code too when there is a loop over elements in the dimension }Dimensions, since hierarchies can be part of that list too. We should make sure that everything translates well in the case of names like dim:hier instead of dim. With an entire library of TI processes this isn't an easy job.
Yep. Been there done that. It has been a BIG job to make everything "hierarchy aware."
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Post Reply