Use of "With Member " in MDX queries ?

  • I am a newbie and trying to learn MDX queries.

    Till what i have learn till now, is that every data manipulation can be done using Select,From,Where and using some of the function (as an when necessary).

    I came across some example where "With Member" was written as the top of the query , follwed by the Select,From and Where.

    I though it adds no value addition to the output of the query.

    I would like to know Why we used "With Members" in MDX queries.

    Thanks.

  • 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 )

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply