MDX Primer
MDX Primer
As promised, the MDX Primer is attached.
Please note that everything in it worked in the version(s) quoted and in the model described. YMMV. If something doesn't work now, report it to Applix.
Regards,
Philip Bichard
Please note that everything in it worked in the version(s) quoted and in the model described. YMMV. If something doesn't work now, report it to Applix.
Regards,
Philip Bichard
- Attachments
-
- MDX Primer.zip
- (446.2 KiB) Downloaded 1818 times
Last edited by Martin Ryan on Mon Sep 01, 2008 3:18 pm, edited 1 time in total.
Reason: Removed stickyness as pertinent post now in "Useful Code" thread.
Reason: Removed stickyness as pertinent post now in "Useful Code" thread.
- Renaud MARTIAL
- Posts: 25
- Joined: Thu May 15, 2008 10:18 am
- Location: Paris, France
Re: MDX Primer
Thank you very much, Richard,
very interesting
Regards,
Renaud.
very interesting
Regards,
Renaud.
-
- Posts: 40
- Joined: Thu Jun 19, 2008 8:09 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: MDX Primer
Great job
Thanks
Thanks
- bihints.com
- Posts: 52
- Joined: Tue May 20, 2008 8:56 am
- OLAP Product: TM1
- Version: 9.0.3
- Excel Version: 2003
- Contact:
Re: MDX Primer
This document should be "wikiized" ( yes it's a word, 41 hits on google )
so the contents are visible on search engines and we can edit/amend it as I did on bihints.com
Ultimately the full TM1 documentation should be turned into a wiki.
I talked to some Applix managers about that but they didn't really appreciate the idea claiming docs must be accurate,
although I strongly believe crowdsourcing docs through wiki would deeply enrich these.
so the contents are visible on search engines and we can edit/amend it as I did on bihints.com
Ultimately the full TM1 documentation should be turned into a wiki.
I talked to some Applix managers about that but they didn't really appreciate the idea claiming docs must be accurate,
although I strongly believe crowdsourcing docs through wiki would deeply enrich these.
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: MDX Primer
THIS IS .............. wait for it
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: MDX Primer
AWESOME!!!!!
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Re: MDX Primer
Indeed. Excellent work.
Re: MDX Primer
Great work as usual Philip.
Will try MDX again and hope it does not crash the server this time
Ken
Will try MDX again and hope it does not crash the server this time
Ken
- George Regateiro
- MVP
- Posts: 326
- Joined: Fri May 16, 2008 3:35 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2007 SP3
- Location: Tampa FL USA
Re: MDX Primer
Just came across this post. This is great. Thank You.
Re: MDX Primer
I discovered the primer one year ago, and set that use I it eagerly. Thank you Philip
- Steve Rowe
- Site Admin
- Posts: 2423
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: MDX Primer
First of all
and I sitckyed this, which I'm pretty sure isn't a word no matter what google says!
err I couldn't sitcky the doc as the forum is bugged.... Who's in charge round here??
Cheers,
ROFL, I would say wiki docs are likely to be more accurate....Ultimately the full TM1 documentation should be turned into a wiki.
I talked to some Applix managers about that but they didn't really appreciate the idea claiming docs must be accurate,
and I sitckyed this, which I'm pretty sure isn't a word no matter what google says!
err I couldn't sitcky the doc as the forum is bugged.... Who's in charge round here??
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- Martin Ryan
- Site Admin
- Posts: 1988
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: MDX Primer
I edited the original post by Philip and made it a sticky. That seemed to do the job.
Martin
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
- jim wood
- Site Admin
- Posts: 3953
- 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: MDX Primer
No wonder your post count is so high!!! Great post by the way.Eric wrote:THIS IS .............. wait for it
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: MDX Primer
Who
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: MDX Primer
me?
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
- Eric
- MVP
- Posts: 373
- Joined: Wed May 14, 2008 1:21 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
- Location: Chicago, IL USA
Re: MDX Primer
Chris Web has some good MDX stuff on his blog, he could also be a decent reference.
http://cwebbbi.spaces.live.com/?_c11_Bl ... =cat%3dMDX
http://cwebbbi.spaces.live.com/?_c11_Bl ... =cat%3dMDX
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1
Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: MDX Primer
Shame Spaces is a blocked site from here. Or not, as the case may be
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
-
- Posts: 16
- Joined: Tue Nov 23, 2010 4:12 pm
- OLAP Product: Cognos TM1
- Version: 10.1.0
- Excel Version: 2007
- Location: Portland, OR USA
Re: MDX Primer
A co-worker of mine came across an updated version of your document. Would you be willing to put it on the forum?
Re: MDX Primer
Glad everyone finds it useful after all these years. The latest version lives permanently on my website at www.pxbconsulting.com. It's easier to maintain that way, not that it's changed too much in recent times. I do get emails from readers from time to time so I know people are finding the 'real' version. I'm afraid I don't really use this forum myself. As you may know the version on bihints.com is an early draft - it was too much work to maintain, hence the current simple way of publishing it.
All the best,
Philip Bichard
All the best,
Philip Bichard