No announcements
Found 563110 threads
-
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 | 721 Views | Created by contacthirenparikh - Tuesday, January 16, 2018 1:53 PM | Last reply by Alexei Stoyanovsky - Thursday, January 18, 2018 11:44 AM -
1 Votes
Equivalent of DMX and MDX in Oracle
MDX is based on the XML for Analysis (XMLA) specification, with specific extensions for SQL Server Analysis Services.Answered | 2 Replies | 11064 Views | Created by MSSQLServer 2008 - Monday, July 9, 2012 5:57 PM | Last reply by Eileen Zhao - Monday, July 16, 2012 10:13 AM -
1 Votes
Excel 2016 power pivot error when connecting SSAS MDX query designer - Cannot load the query designer.
(if it works) It's stopping us from moving to Excel 2016 since our servers are not all SQL 2016.Answered | 3 Replies | 2446 Views | Created by Ken SS - Wednesday, July 27, 2016 9:50 PM | Last reply by Ed Price - MSFT - Sunday, October 30, 2016 10:57 AM -
0 Votes
to amend query designer generated mdx query
Generally I advise against allowing SSRS to generate MDX as it is BAD.Answered | 5 Replies | 3185 Views | Created by MKG2011 - Wednesday, October 19, 2011 2:48 PM | Last reply by Waco_Huber - Wednesday, October 19, 2011 7:55 PM -
0 Votes
MDX Query using Bids
Hi, Apart from tracing (see http://msdn.microsoft.com/en-us/library/ms174946.aspx), I am not aware of any way to see the MDX used by OWC which is teh browser component used ...Answered | 2 Replies | 5725 Views | Created by Pravin.c - Tuesday, November 10, 2009 5:09 PM | Last reply by Pravin.c - Tuesday, November 10, 2009 9:03 PM -
1 Votes
problem with excel designer
The workbook itself has no particular design surface, but you can drag components such as datasets to the workbook designer to add them to your project.Answered | 2 Replies | 4919 Views | Created by Pacerier - Friday, June 25, 2010 10:31 PM | Last reply by Pacerier - Sunday, June 27, 2010 8:37 PM -
0 Votes
dynamic MDX
I need solution with Query designer because I don't want to "Unexpression" the query and "Reexpression" it evrey time I use it.Answered | 4 Replies | 1040 Views | Created by ronit_bar - Wednesday, September 2, 2015 11:16 AM | Last reply by Charlie Liao - Thursday, September 3, 2015 8:12 AM -
0 Votes
Build mdx queries programatically
For example, when a user creates a pivot table in excel (connected to a cube), everytime they drag/drop dimension attributes and hierarchies on rows/columns and ...Answered | 1 Replies | 1150 Views | Created by bishnupatro21 - Monday, July 1, 2013 11:35 AM | Last reply by BillAnton - Monday, July 1, 2013 11:54 AM -
0 Votes
MDX Query generated for Pivot Table
The MDX graphical query designer has two modes: design mode and query mode.Answered | 3 Replies | 1802 Views | Created by rush1956 - Monday, April 29, 2013 3:53 PM | Last reply by Sagar 1987 - Thursday, May 30, 2013 12:22 AM -
3 Votes
How to take MDX Script to BIDS?
The named set is definitely in the Cube because I can execute MDX scripts against it and Excel can see/use it too.Answered | 11 Replies | 3263 Views | Created by amir tohidi - Thursday, February 9, 2012 4:20 PM | Last reply by amir tohidi - Friday, February 10, 2012 4:17 PM -
0 Votes
Excel Designer cannot be activated
I tried to create a Office application (excel workbook) and VS says "the project cannot be created".Answered | 5 Replies | 11758 Views | Created by Onur Gorur - Sunday, December 4, 2005 1:48 PM | Last reply by surfenPL - Thursday, April 7, 2011 10:35 AM -
2 Votes
Is it still worth investing time in learning MDX?
even in cube designing you are specifing MDX expression on serveral places like:Many to many expression, Direct Slice property, KPI etc.Answered | 7 Replies | 4959 Views | Created by amir tohidi - Thursday, March 7, 2013 8:27 AM | Last reply by Zaim Raza - Thursday, March 7, 2013 11:08 PM -
0 Votes
Please Help in Solving the Cube design with MDX suggestions on the following issue
My previous example demonstrated how this should be done using MDX, but I recommend you do that at the ETL phase.Answered | 4 Replies | 5821 Views | Created by Pravin.c - Monday, May 16, 2011 1:31 AM | Last reply by HrvojePiasevoli - Thursday, May 19, 2011 3:25 AM -
1 Votes
Identifying attribute members uniquely in mdx formula (Excel)
However, it is possible to design a DWH in a way that will retain surrogate keys when rebuilt from scratch by persisting SK encoding somewhere else, perhaps in your ...Answered | 5 Replies | 653 Views | Created by fleo - Thursday, February 23, 2017 7:41 PM | Last reply by fleo - Monday, February 27, 2017 10:00 AM -
0 Votes
How to get the MDX query underneath Cube Browser?
I am guessing that for web based rendering MS now simply directs people towards things like Sharepoint and Excel Services.Answered | 2 Replies | 5387 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
How to create MDX query Dynamically in web application
Hi, We need to design an interface to create dynamic MDX query to interact with SSAS Cube.Answered | 7 Replies | 6612 Views | Created by Kapil Dev K - Friday, October 5, 2012 9:34 AM | Last reply by Leschenok - Friday, October 12, 2012 6:24 AM -
6 Votes
MDX Parameter
Can you please provide the MDX Query showing these parameters?Answered | 15 Replies | 29560 Views | Created by Semayawii - Friday, June 16, 2006 4:53 PM | Last reply by fjapires1985 - Wednesday, August 11, 2010 10:08 AM -
0 Votes
How to to connect to an ssas 2008 cube and load MDX query result using adomd in Excel 2007 vba
Hi, As this forum is not so Applicaion Specific, I suggest you aslo could ask this question in Excel discussion group, which a you'll find more excel specialist ...Answered | 2 Replies | 7250 Views | Created by SQLShare - Wednesday, February 24, 2010 5:09 PM | Last reply by vbasean - Friday, April 8, 2011 9:54 PM -
0 Votes
MDX-Group by
Kindly find the below MDX code.Change the attribute as per your cube design.Answered | 4 Replies | 6781 Views | Created by Dhwani S - Saturday, March 10, 2012 4:33 AM | Last reply by Dhwani S - Monday, March 12, 2012 1:38 PM -
0 Votes
MDX result set
Hi, I did not see Option in SSMS to view result to file like SQL Query, But I guess you can use excel file and connect to your cube and then change the connection ...Answered | 1 Replies | 2843 Views | Created by sqldeveloper2008 - Monday, February 20, 2012 8:48 AM | Last reply by Elmozamil Elamir - Monday, February 20, 2012 1:01 PM
No announcements