susmitha117
SSC Eights!
Points: 890
More actions
December 4, 2017 at 7:29 am
#151535
Hi,Thanks for looking at this. I am confused between when to use WITH SET and WITH MEMBER while querying cube in MDX on SQL Server? Please explain in basic way.TIA!
Martin Schoombee
SSCoach
Points: 19124
December 4, 2017 at 7:55 am
#1970535
WITH SET returns a set of data, i.e. a combination of dimension attributes and/or measures.
WITH MEMBER returns one value (usually a calculated measure), meaning one aggregated or distinct value based on the defined calculation/logic.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply