No announcements
Found 2648448 threads
-
0 VotesBrowse cube filtering
And I go haave data for teh year 2010.Answered | 14 Replies | 3910 Views | Created by Sarah2005 - Wednesday, November 16, 2011 6:23 PM | Last reply by Sarah2005 - Wednesday, December 28, 2011 12:58 AM
-
3 Votes
MDX - get "new" data
Such as "Intenet Sales" in cube AdventureWorks.Answered | 9 Replies | 875 Views | Created by hhewson - Wednesday, May 10, 2017 6:43 PM | Last reply by hhewson - Friday, May 12, 2017 6:27 PM -
1 Votes
SSAS 2012 - Filter Entire Cube
Basically it means that u are loading 6 years of data to the cube BUT only 1 year is relevant?Answered | 2 Replies | 1189 Views | Created by Rihan8585 - Friday, July 29, 2016 6:10 AM | Last reply by yger - Friday, July 29, 2016 8:07 AM -
0 Votes
Filtering records in MDX / Excel
I have minimal knowledge in MDX, can you please help me in writing the MDX.Answered | 14 Replies | 10095 Views | Created by Nagaraj Ennikapati - Wednesday, June 8, 2011 11:04 AM | Last reply by Nagaraj Ennikapati - Tuesday, June 14, 2011 6:11 AM -
0 Votes
How to get the MDX query underneath Cube Browser?
Question 2 - The Office Web Component provides the graphical 'front end' that allows you to drag and drop cube objects onto the canvas - it has nothing to do with the fact the ...Answered | 2 Replies | 5388 Views | Created by TiPi - Monday, March 15, 2010 3:47 AM | Last reply by Darren Gosbell - Tuesday, March 16, 2010 10:30 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 | 6478 Views | Created by Turmalino - Wednesday, January 12, 2011 10:16 AM | Last reply by Kasi Viswanadham - Wednesday, January 26, 2011 2:33 PM -
0 Votes
MDX query to filter data based on role
For that you can try the following , Create a role and in the "Dimension Data" tab , you can do a MDX for allowed member set.Answered | 4 Replies | 9301 Views | Created by Pradip Bobhate - Tuesday, May 24, 2011 8:52 PM | Last reply by HrvojePiasevoli - Wednesday, May 25, 2011 10:11 AM -
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 | 2494 Views | Created by gemmo1 - Wednesday, January 29, 2014 2:29 AM | Last reply by gemmo1 - Monday, February 3, 2014 11:11 PM -
1 Votes
Wild Card Serach in MDX whiel querying cube
Hi PXPRXR, You can still use the filter combined with left() and right() function to achieve this goal.Answered | 3 Replies | 1052 Views | Created by PXPRXR - Wednesday, October 24, 2018 12:53 PM | Last reply by Pirlo Zhang - Thursday, October 25, 2018 8:50 AM -
0 Votes
Dynamic filtering MDX
This dimension would be included in your cube but no relationships would be defined directly to any of your measure groups.Answered | 1 Replies | 3443 Views | Created by M. Shparber - Sunday, December 2, 2012 7:43 AM | Last reply by Martin Mason - Tuesday, December 4, 2012 3:18 PM -
0 Votes
MDX filter function
Customer Number is the member I am trying to filter on.Answered | 9 Replies | 8579 Views | Created by .me - Tuesday, August 25, 2009 3:38 PM | Last reply by Prasanna K J - Wednesday, August 26, 2009 5:17 AM -
1 Votes
Learning samples for Cubes and MDX
Hi Are there any decent samples/resources (ideally with decent documentation) for learning about Cubes and MDX?Answered | 2 Replies | 2882 Views | Created by amir tohidi - Thursday, October 13, 2011 2:11 PM | Last reply by amir tohidi - Thursday, October 13, 2011 2:44 PM -
0 Votes
cube update date in a MDX IIF statment
Hi I’m experiencing a new problem that once the DB is large the MDX takes a long time since it reads all partitions in the cube (and each partition hold ...Answered | 6 Replies | 1988 Views | Created by Yoni_5 - Friday, October 24, 2014 8:57 AM | Last reply by Yoni_5 - Tuesday, December 22, 2015 9:02 AM -
0 Votes
MDX query and browsing cubes in management studio
Hi Adevi, You may want to check out SQL Profiler against an Analysis Services server to see what is actually running when you query the cube.Answered | 2 Replies | 6963 Views | Created by Adevi - Thursday, February 11, 2010 3:31 PM | Last reply by Darren Gosbell - Friday, February 12, 2010 1:39 AM -
1 Votes
Calculated fields with cube filter
Niyas Niyas, I havent used the measure expressions in cubes before, but will definitively try this out ...Answered | 13 Replies | 7057 Views | Created by DBGlenn - Friday, October 22, 2010 10:12 AM | Last reply by DBGlenn - Thursday, November 4, 2010 10:52 PM -
0 Votes
Selecting data from multiple cubes with Joins using MDX Query
Please do use SQL OpenQuery to run the MDX and then do a join...but i am not a fan of this...Answered | 1 Replies | 11092 Views | Created by Abhiyanta - Wednesday, June 8, 2011 1:47 PM | Last reply by Vinuthan - Wednesday, June 8, 2011 2:01 PM -
0 Votes
MDX Help : All cube either does not exist or has not been processed
Inside the for each loop create a data flow task to load data from the SSAS cube to the excel file.Answered | 7 Replies | 10778 Views | Created by Abhiyanta - Saturday, June 25, 2011 9:15 AM | Last reply by Sorna Kumar Muthuraj - Monday, June 27, 2011 10:15 AM -
1 Votes
How to acquire Bing Maps SessionId for non-billable Bing Rest service using the WinRT API
However, if you call this after the whole Page load then you should get the SessionID string.Answered | 4 Replies | 1946 Views | Created by tamas_ - Sunday, May 22, 2016 8:25 AM | Last reply by tamas_ - Monday, May 23, 2016 6:05 AM -
0 Votes
Need guidance on writing an MDX Filter Expression in the SSAS Cube ...
If this is a key requirement you could even build your data model around this.Answered | 2 Replies | 3590 Views | Created by MeharAli - Friday, May 25, 2012 6:58 PM | Last reply by Darren Gosbell - Tuesday, May 29, 2012 5:54 AM -
0 Votes
Cube/MDX Design
You still need to write another MDX query for GasField.Answered | 1 Replies | 948 Views | Created by DapperDev_ - Tuesday, January 20, 2015 10:38 AM | Last reply by Simon_Hou - Friday, January 23, 2015 3:37 AM
No announcements
