Inspecting views

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
MVP
Posts: 1806
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Inspecting views

Post by Wim Gielis » Fri Nov 10, 2017 12:25 pm

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 178 times
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

User avatar
gtonkin
MVP
Posts: 627
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Inspecting views

Post by gtonkin » Mon Nov 13, 2017 3:07 pm

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: 3599
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Inspecting views

Post by jim wood » Mon Nov 13, 2017 4:23 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

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

Re: Inspecting views

Post by Wim Gielis » Mon Nov 13, 2017 7:55 pm

Thanks guys
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

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 » Thu Apr 05, 2018 8:17 am

It's great that I came here ...

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

Re: Inspecting views

Post by Wim Gielis » Fri Apr 06, 2018 5:05 pm

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

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

Post Reply