WITH MEMBER allows you to create calculated members that you can use in the SELECT statement. This is useful where the calculation doesn't exist in the cube you are querying. Try searching google for "MDX With Member" - you will find a lot of info (some useful as well )