Search found 6 matches

by PXB
Sat Sep 01, 2012 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Primer
Replies: 18
Views: 19197

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' v...
by PXB
Sun Jun 26, 2011 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executive Viewer on TM1 Cubes over WAN
Replies: 9
Views: 11765

Re: Executive Viewer on TM1 Cubes over WAN

Hi chaps, I was alerted to this thread by a friend, sorry if I'm a bit late. Bihints.com is nothing to do with me. It is run by Numa Fabre, an old TM1 colleague of mine. As I had an early Primer I just let him publish it for no particular reason. That one is not updated. The latest (it's occasionall...
by PXB
Wed Mar 03, 2010 12:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset creation by MDX
Replies: 7
Views: 9607

Re: Subset creation by MDX

Actually the place to get the current updated version of the MDX Primer is http://www.pxbconsulting.com/downloads.html.
by PXB
Tue Jul 29, 2008 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Attributes
Replies: 4
Views: 7052

Re: Cube Attributes

I used them, and dimension and element attributes as well, as an optional alias for an Excel-based product I developed called Driller. It read the current cell 'address' and constructed a default SQL drillthrough query using any cube, dimension and element attributes called 'Driller' that existed. I...
by PXB
Wed Jul 02, 2008 7:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Primer
Replies: 18
Views: 19197

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
by PXB
Thu Jun 26, 2008 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX problem
Replies: 15
Views: 19929

Re: TM1 MDX problem

I'm the author of the MDX Primer. I'm really snowed under at the moment but will post the latest version in Word format over the weekend. Others in the past have contacted me directly and received prompt answers. YMMV. And no, it's not tested and re-tested on each and every patch, SP, etc but if the...