On this page....



<May 2012>
SunMonTueWedThuFriSat
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

Aggregate Me!

RSS 2.0 | Atom 1.0 | CDF

Profile

me

Name:
   Miky Schreiber
Occupation:
   BI, Web & .Net Programmer
Location:
   Israel

more...

Sites I write in

Jewish Quote

"The most remarkable thing about my mother is that for thirty years she served the family nothing but leftovers. The original meal has never been found."
-Calvin Trillin

My Skype Status: My status

Send mail to the author(s)
Mail me

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

 Wednesday, August 01, 2007
MDX notes
 
While reading the first chapter of the book "MDX Solutions With MS SQL Server Analysis Services 2005 And Hyperion Essbase", I wrote down some important notes, especially for the MDX beginners. Even if you're experienced user, check this out. You may find something useful.

  • If you were a code programmer in your past, you can relax: MDX don't care about capitalization.
  • Don't even try to skip an axis: It's impossible and it is meaningless. Use the predefined names for the axis, such as: columns, rows, pages, etc.
  • You're new to MDX and the whole OLAP gives you a headache? Try to imagine this as a hypercube. It can help you a lot.
  • When writing large queries, pay attention to the "readability" of your MDX. Use the Monospace fonts whenever possible.
  • Do NOT think of SQL when learning or working with MDX. Although the syntaxes may look alike, these languages are totally different when you get to know them.
  • .Members will give you all regular members. .AllMembers will also include calculated members.
  • An expression like [Time].Members won't work if the Time dimension has multiple hierarchies.
  • The asterisk (*) can replace the CrossJoin function. It may improve readability of the code.
  • When using Order() function, you can specify a sorting criteria which is not shown in the result grid.

 |  | 
Thursday, August 02, 2007 3:04:47 AM (Jerusalem Daylight Time, UTC+03:00)
Comments [4]  |  Trackback Related posts:
Playing with image transparency in QlikView
Great Storage Tiering E-Book
Installing Informatica 8.6 on Windows 7
Analysis Services NullProcessing Property
Putting the Design Into the Implementation
HR BI - Last Post
  # Bookmark and Share
Wednesday, August 22, 2007 11:57:53 PM (Jerusalem Daylight Time, UTC+03:00)
very nice site
Tommy Delan
Wednesday, October 17, 2007 5:00:17 AM (Jerusalem Standard Time, UTC+02:00)
very good site
proxy site
Thursday, November 29, 2007 11:55:53 AM (Jerusalem Standard Time, UTC+02:00)
This is great! One question: Is there any way around the authentication issue? I have a portal which requires a login/password. Am I out of luck? --thanks
wow gold
Thursday, January 10, 2008 9:02:08 PM (Jerusalem Standard Time, UTC+02:00)
thank you very much
automotive repair manual
All comments require the approval of the site owner before being displayed.
Name
E-mail
Home page

Comment (HTML not allowed)