An Introduction to MDX views

[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
Part 7 - Using Lookup Cubes to Extend Your Queries
Part 8 - Joining Related Cube Data
Part 9 - Joining Related Cube Data - Part 2 - Allocation example

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

[MarenC]

Hi George,

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

Maren

[gtonkin]

Part 3 added per link on updated original post.

[gtonkin]

Part 4 added recently:

Part 4 - Using Calculated Members to Add Information

[gtonkin]

Part 5 added yesterday...

[Wim Gielis]

Very useful as always from George.

[gtonkin]

Part 6 added...

[gtonkin]

Part 9 just added

In the last part of the Introduction to MDX Views series in Planning Analytics, we look at a practical example of joining data from multiple cubes into one view.

The example looks at bringing in the underlying components of an allocation model to present them in a concise view allowing the users to easily identify issues and reconcile without the need to work across multiple screens, jump between disparate view etc.

This may be the end to the introductory series but certainly not the end of the road for MDX related articles and posts.