Inspecting views

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
MVP
Posts: 3099
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:

Inspecting views

Post by Wim Gielis »

Hello all,

Almost weekend, so here's a nice one.

Attached is a generic process to investigate public and private views (*.vue files) and their usage of public and private subsets (*.sub files).

A new control cube is generated, see inside the process for instructions.

Let me know all questions or remarks about these almost 1,000 lines of coding.

Enjoy !
Attachments
TECH_views_and_subsets.pro
(52.4 KiB) Downloaded 937 times
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
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Inspecting views

Post by gtonkin »

Thanks Wim-still trying to find time to digest the previous processes shared-will add to my backlog!
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Inspecting views

Post by jim wood »

Thanks Wim. Will be very handy for anybody inheriting a system that has (how should I say) evolved over time.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Wim Gielis
MVP
Posts: 3099
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: Inspecting views

Post by Wim Gielis »

Thanks guys
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
Sophie Kay
Posts: 4
Joined: Wed Apr 04, 2018 10:21 am
OLAP Product: HOLAP
Version: 8.1
Excel Version: 2017

Re: Inspecting views

Post by Sophie Kay »

It's great that I came here ...
Wim Gielis
MVP
Posts: 3099
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: Inspecting views

Post by Wim Gielis »

Sophie Kay wrote: Thu Apr 05, 2018 8:17 am It's great that I came here ...
Glad you like it !

I have a number of changes to the code, somewhere in the near future I can post an update.
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
Post Reply