tag:blogger.com,1999:blog-8486191632104654344.post2254440106274289653..comments2024-03-26T04:34:53.599-07:00Comments on MDX and DAX topics: Interaction between MDX Subselect and CalculationJeffrey Wanghttp://www.blogger.com/profile/09745744072887789758noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-8486191632104654344.post-9764070027306053472024-02-22T21:17:40.313-08:002024-02-22T21:17:40.313-08:00This is web site is very useful and also very like...This is web site is very useful and also very like this domain our web site https.//sclinbio.com<br />plz visit our blog sclinbiohttps://www.blogger.com/profile/13370742983082055641noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-42514259103819625022023-09-28T05:41:01.993-07:002023-09-28T05:41:01.993-07:00This is web site is very useful and also very like...This is web site is very useful and also very like this domain our web site https.//sclinbio.comsclinbiohttps://www.blogger.com/profile/13370742983082055641noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-31413020138878223162023-09-27T22:45:54.017-07:002023-09-27T22:45:54.017-07:00 This is a good web site and alos very useful co... This is a good web site and alos very useful content i like this web site thanks for sharing this blog our https//.Sclinbio./comsclinbiohttps://www.blogger.com/profile/13370742983082055641noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-25648577915650675902023-09-05T21:15:51.058-07:002023-09-05T21:15:51.058-07:00Extremely intriguing to peruse this article.I migh...Extremely intriguing to peruse this article.I might want to thank you for the endeavors you had made for composing this marvelous article. This article propelled me to understand more. keep it up. our sclinbiosclinbiohttps://www.blogger.com/profile/13370742983082055641noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-76372589236284507162023-08-20T19:15:29.725-07:002023-08-20T19:15:29.725-07:00Upgrade your career clinical data mange ment from ...Upgrade your career clinical data mange ment from industry experts gets complete hands on servicess, on our sclinbio.<br />Sclinbio.comhttps://www.blogger.com/profile/18075701276128506097noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-57249576820726647172023-06-17T04:23:20.740-07:002023-06-17T04:23:20.740-07:00Thank you for sharing the article. The data that y...Thank you for sharing the article. The data that you provided in the blog is informative and effective.<br />this is very good web site also i like this Sclinbio.comhttps://www.blogger.com/profile/18075701276128506097noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-41067431919557222892020-07-17T03:26:43.305-07:002020-07-17T03:26:43.305-07:00Hey Loved the post! Great article and congrats on ...Hey Loved the post! Great article and congrats on Reaching the To 50! I will be back to visit often <br /><br /><a href="http://powerbitrainings.in/powerbi-training-institute-in-hyderabad/" rel="nofollow">Power Bi Training in Hyderabad</a><br /><a href="http://powerbitrainings.in/powerbi-training-institute-in-hyderabad/" rel="nofollow">Power Bi Training</a>http://powerbitrainings.in/powerbi-training-institute-in-hyderabad/https://www.blogger.com/profile/04552927031366808983noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-69051786300348019952013-07-30T20:45:49.355-07:002013-07-30T20:45:49.355-07:00Thanks for the article. Really helpful. I have ano...Thanks for the article. Really helpful. I have another scenario:<br /><br />I need to create a resultset with 2 records from same dimension. However, on the second record I need to apply filter from another dimension.<br /><br />How can I union following resultsets in one single query?<br /><br /><br />SELECT [Dim Account].[Account].&[acc1] ON 0<br />FROM <br />(<br /> SELECT ([Dim PC].&[PC1]) ON 0<br /> FROM [Fin1]<br />)<br />;<br /><br /><br />SELECT [Dim Account].[Main Account].&[acc2] ON 0<br />FROM [Fin1]<br />;<br /><br />Thank you.Shalinder Vermahttps://www.blogger.com/profile/06715667049553396371noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-1785460410330823102013-07-24T00:01:23.178-07:002013-07-24T00:01:23.178-07:00Thanks a lot! Right to the point. Thanks a lot! Right to the point. Eduardhttps://www.blogger.com/profile/08684467815932833141noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-64324203910082531682013-07-22T10:43:06.095-07:002013-07-22T10:43:06.095-07:00What you described is intersection semantics: find...What you described is intersection semantics: finding the intersection between a slice in calculation and a slice from query. MDX formula engine implements overwrite semantics: a slice in the calculation overwrites a slice from query. The intersection semantics doesn't work for basic calculations. For example, a natural way to write year over year growth is ([Internet Sales Amount], [Date].[Calendar Year].CurrentMember) - ([Internet Sales Amount], [Date].[Calendar Year].PrevMember), this formula won't work if you implement intersection semantics since the calculation moves to the previous year and if you intersect the previous year with the current slice from query (the current year), you get empty result.Jeffrey Wanghttps://www.blogger.com/profile/09745744072887789758noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-19318822205198688352013-07-22T08:36:02.480-07:002013-07-22T08:36:02.480-07:00"The rationale behind this rule is that if a ..."The rationale behind this rule is that if a user defines a simple calculated measure like ([Internet Sales Amount], [Fiscal Year].[FY 2009]), they really want to see the sales in 2009 when they add this measure to a report even though the report may have a filter on fiscal years 2010 and 2011."<br /><br />I don't understand this logic. IMO it is counterintuitive to show any data for measure "Sales in 2009" when filtering by 2010. I would expect a null. I expect to see data when filtering by year 2009 or when no filtering by year.<br /><br />Is there any more reasons for this behaviour to exist?Eduardhttps://www.blogger.com/profile/08684467815932833141noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-33439087320817529782012-04-23T22:17:34.442-07:002012-04-23T22:17:34.442-07:00The subselect in the 2nd query produces a slice wh...The subselect in the 2nd query produces a slice which is an arbitrary shape set of two hierarchies, with one of the hierarchies being the [Measures] hierarchy. MDX Engine does not support such slices.Jeffrey Wanghttps://www.blogger.com/profile/09745744072887789758noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-82004047681228107642012-04-23T21:53:20.178-07:002012-04-23T21:53:20.178-07:00oops - I put in 2 queries. one above that works, a...oops - I put in 2 queries. one above that works, and the one below that does not. the measures in a tuple seem to screw things up.snaphttps://www.blogger.com/profile/07431698675330401171noreply@blogger.comtag:blogger.com,1999:blog-8486191632104654344.post-24769175601765923292012-04-23T21:51:37.345-07:002012-04-23T21:51:37.345-07:00thanks for the posting. Can you explain why this q...thanks for the posting. Can you explain why this query produces an error - and what one could do to correct it. The key here is that tuple removal must happen inside the sub-query in order to facilitate a visualtotal of the remaining elements in the outer query.<br /><br />select<br /><br /> {measures.members} on 0,<br />{ [Product Categories].[Category].members } on 1<br /><br />from<br />(<br />select <br />except({measures.members}, {[Measures].[Customer Count]}) on 0 <br /><br />from [Adventure Works]<br />)select<br /><br />{ [Customer].[Customer Geography].[Country].members} *{measures.members} on 0,<br />{ [Product Categories].[Category].members } on 1<br /><br />from<br />(<br />select <br />except(<br />{ [Customer].[Customer Geography].[Country].members} *{measures.members}, <br /> {[Customer].[Customer Geography].[Country].&[United States]} * {[Measures].[Customer Count]}<br /> ) on 0 <br /><br />from [Adventure Works]<br />)snaphttps://www.blogger.com/profile/07431698675330401171noreply@blogger.com