No announcements
Found 563132 threads
-
0 Votes
Excel MDX designer
Hi Sulsa2, What are version of SQL Server and Excel?Answered | 3 Replies | 916 Views | Created by Sulsa2 - Monday, February 20, 2017 7:02 PM | Last reply by Bertrand d'Arbonneau - Tuesday, February 21, 2017 8:00 AM -
0 Votes
MDX Equivalent to Excel Group
Ludis, Maybe Excel creates session members.Answered | 3 Replies | 5620 Views | Created by Ludis - Tuesday, May 5, 2009 4:22 PM | Last reply by Ludis - Monday, June 22, 2009 3:19 PM -
1 Votes
Excel Generating MDX Query With Crossjoins
This is a known issue in Excel, it uses a certain template to build the cross join.Answered | 1 Replies | 1930 Views | Created by Satish Varma - Tuesday, March 31, 2015 2:04 PM | Last reply by Simon_Hou - Thursday, April 2, 2015 12:05 PM -
0 Votes
Excel MDX asks for extra data
Hi Chris, How do you get the excel pivot table MDX query?Answered | 19 Replies | 6089 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
Filtering records in MDX / Excel
Hi Javier, I tried developing MDX named set with your suggestions.Answered | 14 Replies | 9972 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 2007 and MDX
* Revise your MDX to use [GrowthSelect].Answered | 3 Replies | 3908 Views | Created by Evelyne. _ - Monday, March 30, 2009 1:08 PM | Last reply by Evelyne. _ - Tuesday, March 31, 2009 7:01 AM -
0 Votes
Cube/MDX Design
However, it's not supported dynamically specify the range within single MDX script because time and day are under different hierarchy.Answered | 1 Replies | 877 Views | Created by DapperDev_ - Tuesday, January 20, 2015 10:38 AM | Last reply by Simon_Hou - Friday, January 23, 2015 3:37 AM -
0 Votes
MDX Generated by Query Designer in PowerPivot is Different than the MDX Generated by ProClarity
It's still there for Power Query (a smiley-face), but doesn't appear in Power Pivot or Excel (2013).Answered | 4 Replies | 1341 Views | Created by JE7383 - Thursday, August 25, 2016 8:11 PM | Last reply by Ed Price - MSFT - Friday, December 16, 2016 5:30 AM -
0 Votes
Excel MDX and NON EMPTY
We have an Excel 2010 pivot table hitting a SSAS cube.Answered | 2 Replies | 2731 Views | Created by dbwrangler - Friday, March 7, 2014 7:27 PM | Last reply by dbwrangler - Wednesday, March 12, 2014 4:25 PM -
0 Votes
How to Write MDX query in Excel cell
Hi , Hope this great post will help you ...Answered | 1 Replies | 1517 Views | Created by Subhi_S - Monday, May 30, 2016 1:01 PM | Last reply by David Harazi - Monday, May 30, 2016 1:40 PM -
4 Votes
Why use MDX?
MDX is very valuable in the cube design, as well as in report generation.Answered | 13 Replies | 7236 Views | Created by amir tohidi - Wednesday, October 10, 2012 9:22 AM | Last reply by Lee Cullom - Tuesday, September 22, 2015 5:54 PM -
0 Votes
Custom MDX
I have concluded that the MDX created by Excel is inefficient and therefore causing the performance issue.Answered | 13 Replies | 6379 Views | Created by mcheung - Tuesday, December 11, 2007 2:28 PM | Last reply by LuckyDogPro - Friday, January 24, 2014 10:14 AM -
0 Votes
Powerpivot - Design Mode MDX Filter Expression
You can just write the filter in the sub select statement.Take cube Adventure Works as an example, if you select calendar year 2012 and 2013 for filter calendar year, and select ...Answered | 1 Replies | 1912 Views | Created by Ryan Bowlin - Sunday, August 13, 2017 10:05 PM | Last reply by willson yuan - Monday, August 14, 2017 7:11 AM -
0 Votes
MDX works fine in SSMS but not in query designer
Can we classify this as a bug in SSRS as what i found out, some query which runs fine in SQL Server Management studio does not run on SSRS MDX Query editor.Answered | 5 Replies | 7809 Views | Created by Ramakrishnan.lh - Tuesday, December 22, 2009 6:13 AM | Last reply by Suman Sarkar - Monday, September 6, 2010 11:21 AM -
0 Votes
How to use MDX (LastChild) in SSRS report designer?
[Fiscal Month].LastChild.PrevMember' is not a unique name -- it's an MDX expression -- hence that value will never be returned by the SSAS query.Answered | 3 Replies | 5155 Views | Created by DirkLX - Monday, September 21, 2009 2:47 PM | Last reply by Denesh Pohar - Wednesday, March 10, 2010 5:43 PM -
0 Votes
MDX query and browsing cubes in management studio
This free Excel 2007 add-in lets you see the MDX that Excel is generating http://olappivottableextend.codeplex.com/http://geekswithblogs.net/darrengosbell - please ...Answered | 2 Replies | 6896 Views | Created by Adevi - Thursday, February 11, 2010 3:31 PM | Last reply by Darren Gosbell - Friday, February 12, 2010 1:39 AM -
0 Votes
MDX Example
How to connect to cube from excel http://support.microsoft.com/kb/940167/en-gb How to view the MDX query that is ...Answered | 1 Replies | 5128 Views | Created by Gauravshri - Sunday, June 13, 2010 7:30 PM | Last reply by Ashwani Roy - Monday, June 14, 2010 11:46 AM -
5 Votes
Save MDX in SSAS Browser?
Summary: You could get MDX from SQL Proflie or Excel or Reporting Services BIDs indrectly.Answered | 16 Replies | 11548 Views | Created by Yucong - Sunday, January 31, 2010 10:11 PM | Last reply by Kalman Toth - Tuesday, February 2, 2010 8:48 PM -
0 Votes
Excel designer cannot be activated
>All of a sudden I was no longer able to open the excel worksheet in design mode as I get the error "Excel designer cannot be activated".Answered | 6 Replies | 3590 Views | Created by R Mand - Monday, January 5, 2015 8:26 PM | Last reply by Leo Gurdian - Thursday, December 22, 2016 9:28 PM -
0 Votes
Issue in MDX
Excel is an extremely versatile OLAP client, and this versatility makes it hard to pre-code everything at the cube level.Answered | 6 Replies | 665 Views | Created by contacthirenparikh - Tuesday, January 16, 2018 1:53 PM | Last reply by Alexei Stoyanovsky - Thursday, January 18, 2018 11:44 AM - Items 1 to 20 of 563132 Next ›
No announcements