An Introduction to MDX views

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
gtonkin
MVP
Posts: 1254
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:

An Introduction to MDX views

Post by gtonkin »

I am posting the links to my article on the IBM TechXChange community here rather than trying to replicate the article.

Part 1 - Learning MDX Views in Planning Analytics
Part 2 - Using Calculated Members in MDX
Part 3 - Aggregate Calculated Members in MDX
Part 4 - Using Calculated Members to Add Information
Part 5 - Working with Attributes in MDX Views
Part 6 - Working with Time Series functions

Would be good to get some feedback and possible future topics.

I have these in mind at this stage:
  • Aggregate functions (in Part 3)
  • Ranking results
  • Read-only values in cubes
  • Joining or stitching views
  • Notes or commentary alongside values
  • Sorting and sequencing a view for export
  • Query Scoped Members
Last edited by gtonkin on Wed Aug 28, 2024 6:15 pm, edited 4 times in total.
BR, George.

Learn something new: MDX Views
MarenC
Regular Participant
Posts: 432
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: An Introduction to MDX views

Post by MarenC »

Hi George,

I don't know how much they pay you but it isn't enough! Great work.

Maren
User avatar
gtonkin
MVP
Posts: 1254
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: An Introduction to MDX views

Post by gtonkin »

Part 3 added per link on updated original post.
BR, George.

Learn something new: MDX Views
User avatar
gtonkin
MVP
Posts: 1254
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: An Introduction to MDX views

Post by gtonkin »

BR, George.

Learn something new: MDX Views
User avatar
gtonkin
MVP
Posts: 1254
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: An Introduction to MDX views

Post by gtonkin »

Part 5 added yesterday...
BR, George.

Learn something new: MDX Views
Wim Gielis
MVP
Posts: 3222
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: An Introduction to MDX views

Post by Wim Gielis »

Very useful as always from George.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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: 1254
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: An Introduction to MDX views

Post by gtonkin »

Part 6 added...
BR, George.

Learn something new: MDX Views
Post Reply