No announcements
Found 588081 threads
-
0 VotesFiltering records in MDX / Excel
Hi Javier, I tried developing MDX named set with your suggestions.Answered | 14 Replies | 10214 Views | Created by Nagaraj Ennikapati - Wednesday, June 8, 2011 11:04 AM | Last reply by Nagaraj Ennikapati - Tuesday, June 14, 2011 6:11 AM
-
1 Votes
Excel Generating MDX Query With Crossjoins
It uses DrillDown.... functions for complex user filter selection when doing drill down.Answered | 1 Replies | 2111 Views | Created by Satish Varma - Tuesday, March 31, 2015 2:04 PM | Last reply by Simon_Hou - Thursday, April 2, 2015 12:05 PM -
1 Votes
MDX Filter
Hi , I need your help Imaging this mdx query which is actually working but doesn't return what i expect...Answered | 2 Replies | 2665 Views | Created by tony3790 - Monday, February 11, 2013 1:19 AM | Last reply by Ed Price - MSFT - Monday, February 18, 2013 6:19 AM -
0 Votes
MDX count based on filter
[High Volume Products Count] Reference:Optimizing Count(Filter(...)) expressions in MDX Regards, Charlie Liao If you ...Answered | 2 Replies | 2253 Views | Created by Tim Windsor - Wednesday, February 12, 2014 12:21 PM | Last reply by Charlie Liao - Thursday, February 13, 2014 2:34 AM -
0 Votes
MDX filter function
Customer Number is the member I am trying to filter on.Answered | 9 Replies | 8653 Views | Created by .me - Tuesday, August 25, 2009 3:38 PM | Last reply by Prasanna K J - Wednesday, August 26, 2009 5:17 AM -
0 Votes
Excel MDX asks for extra data
The good thing is that now you will be able to change the properties, including MDX queries, from within Excel and plug the results with other ...Answered | 19 Replies | 6218 Views | Created by Chris.Corbin - Tuesday, June 21, 2011 7:26 PM | Last reply by GregGalloway - Saturday, June 25, 2011 5:48 AM -
0 Votes
Help with some MDX (Filter)
I am trying to create a SET by filtering a set of members (Markets) based on a BU (Business Unit) and having no luck.Answered | 2 Replies | 3949 Views | Created by Frank Kearney - Monday, August 3, 2009 10:19 PM | Last reply by Frank Kearney - Wednesday, August 5, 2009 4:36 PM -
1 Votes
Filtering on MDX Totals (with no "ON ROWS")
Thanks, Hrvoje Piasevoli MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav ...Answered | 6 Replies | 3120 Views | Created by tank104 - Friday, January 11, 2013 4:43 PM | Last reply by tank104 - Wednesday, January 16, 2013 2:29 PM -
0 Votes
Date Range Filter in MDX
You can just apply your logic to the sample MDX provided by me.Answered | 5 Replies | 6661 Views | Created by Aka_Maddy - Monday, July 17, 2017 6:50 PM | Last reply by willson yuan - Thursday, July 20, 2017 7:04 AM -
0 Votes
Question about Filter in MDX
You can try 2 ways: a) Use NONEMPTY (FILTER([Date].Answered | 1 Replies | 3976 Views | Created by Hennie7863 - Wednesday, June 22, 2011 2:54 PM | Last reply by Naveen Das - Wednesday, June 22, 2011 3:22 PM -
0 Votes
Dynamic filtering MDX
http://www.amazon.com/Microsoft-Analysis-Services-Cookbook-ebook/dp/B005HIK89S/ref=sr_1_2?Answered | 1 Replies | 3510 Views | Created by M. Shparber - Sunday, December 2, 2012 7:43 AM | Last reply by Martin Mason - Tuesday, December 4, 2012 3:18 PM -
1 Votes
when Where and Filter can be used in MDX
This post may be helpful, http://stackoverflow.com/questions/11356542/mdx-filter-member-in-where-clause-vs-filter-member-in-from-clause Regards, ...Answered | 1 Replies | 1267 Views | Created by Ramesh x - Friday, June 7, 2013 11:20 AM | Last reply by Chongtham Rajen Singh - Friday, June 7, 2013 12:35 PM -
1 Votes
Using The MDX Filter Function in a Parameter
Here are the 2 bits of code using the filter and the exists, the filter brings back the correct results in this example, in the end I want to pass the @mcc ...Answered | 7 Replies | 7567 Views | Created by Michael Maundrill - Thursday, May 20, 2010 10:56 PM | Last reply by Michael Maundrill - Tuesday, May 25, 2010 2:53 AM -
0 Votes
MDX Equivalent to Excel Group
Ludis, Maybe Excel creates session members.Answered | 3 Replies | 5756 Views | Created by Ludis - Tuesday, May 5, 2009 4:22 PM | Last reply by Ludis - Monday, June 22, 2009 3:19 PM -
0 Votes
specifying SSRS Filters in MDX format
Beyond simple equality matching, MDX parameterization can get a little tricky.Answered | 4 Replies | 5614 Views | Created by squarewave24 - Friday, July 8, 2011 9:53 PM | Last reply by squarewave24 - Wednesday, July 13, 2011 2:15 PM -
1 Votes
Filter Axis tuple to string in MDX
can you please post if any alternate way to read filter value also.Answered | 3 Replies | 6540 Views | Created by Turmalino - Wednesday, January 12, 2011 10:16 AM | Last reply by Kasi Viswanadham - Wednesday, January 26, 2011 2:33 PM -
2 Votes
what is Difference between filter() and where condition in MDX?
It wont apply any filter to the rest of the data you are looking at, whilst the where clause will actually filter the data being returned to you down to that member.Answered | 1 Replies | 9800 Views | Created by RamakoteswaraRao - Friday, June 15, 2012 7:21 AM | Last reply by Michael Riemer - Friday, June 15, 2012 8:16 AM -
1 Votes
mdx query - ignore filter
It did seem as though the All member was still filtering, so the ROOT function did the trick.Answered | 3 Replies | 9227 Views | Created by hhewson - Tuesday, April 13, 2010 6:38 PM | Last reply by hhewson - Wednesday, April 14, 2010 1:35 PM -
0 Votes
MDX - Aggregate/Sum/Manual Filter
Hi, It's not clear where to find the "cash Inflow" aggregation in your mdx query.Answered | 2 Replies | 2634 Views | Created by gemmo1 - Wednesday, January 29, 2014 2:29 AM | Last reply by gemmo1 - Monday, February 3, 2014 11:11 PM -
0 Votes
Mdx Filter Strange behaviour
I found the following solution: Filter([Aanwezig Van Datum].Answered | 2 Replies | 3941 Views | Created by GuidoKleijer - Wednesday, January 6, 2010 12:10 PM | Last reply by GuidoKleijer - Wednesday, January 6, 2010 1:56 PM - Items 1 to 20 of 588081 Next ›
No announcements
