Inspecting views

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
MVP
Posts: 1571
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 47 times
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

User avatar
gtonkin
MVP
Posts: 532
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
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: 3509
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 7 64-bit. TM1 Version: 10.1.1

Wim Gielis
MVP
Posts: 1571
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 ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

Post Reply