No announcements
Found 563228 threads
-
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 | 3451 Views | Created by R Mand - Monday, January 5, 2015 8:26 PM | Last reply by Leo Gurdian - Thursday, December 22, 2016 9:28 PM -
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 | 11357 Views | Created by Yucong - Sunday, January 31, 2010 10:11 PM | Last reply by Kalman Toth - Tuesday, February 2, 2010 8:48 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 | 6341 Views | Created by Kapil Dev K - Friday, October 5, 2012 9:34 AM | Last reply by Leschenok - Friday, October 12, 2012 6:24 AM -
0 Votes
Scope MDX
Sonam, this is a DAX formula, which cannot on its own be rewritten using MDX's SCOPEAnswered | 1 Replies | 601 Views | Created by Sonam P - Thursday, March 3, 2016 6:31 AM | Last reply by Alexei Stoyanovsky - Tuesday, March 8, 2016 7:54 AM -
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 | 4816 Views | Created by Pacerier - Friday, June 25, 2010 10:31 PM | Last reply by Pacerier - Sunday, June 27, 2010 8:37 PM -
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 | 10796 Views | Created by MSSQLServer 2008 - Monday, July 9, 2012 5:57 PM | Last reply by Eileen Zhao - Monday, July 16, 2012 10:13 AM -
5 Votes
MDX Book
There is a newish book out MDX with Microsoft SQL Server 2008 R2 Analysis Services ...Answered | 6 Replies | 7071 Views | Created by Patrick Grant - Friday, February 12, 2010 6:42 PM | Last reply by kinect_dude - Wednesday, November 23, 2011 7:13 AM -
0 Votes
Replace string in mdx
Once the member captions/keys are loaded in to the dimension attributes they can't be changed or manipulated with MDX.Answered | 4 Replies | 2978 Views | Created by DileepReddyAchhala - Thursday, June 25, 2015 12:39 PM | Last reply by Darren Gosbell - Friday, June 26, 2015 7:11 AM -
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 | 5543 Views | Created by Pravin.c - Tuesday, November 10, 2009 5:09 PM | Last reply by Pravin.c - Tuesday, November 10, 2009 9:03 PM -
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 | 980 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 Help
My first piece of advice would be to pick up a book on MDX, if you want to avoid a lot of frustration.Answered | 1 Replies | 2521 Views | Created by wOOkies - Wednesday, November 2, 2011 3:05 AM | Last reply by Mark Wojciechowicz - Wednesday, November 2, 2011 10:56 AM -
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 | 11595 Views | Created by Onur Gorur - Sunday, December 4, 2005 1:48 PM | Last reply by surfenPL - Thursday, April 7, 2011 10:35 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 | 3086 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
MDX Query generated for Pivot Table
The MDX graphical query designer has two modes: design mode and query mode.Answered | 3 Replies | 1620 Views | Created by rush1956 - Monday, April 29, 2013 3:53 PM | Last reply by Sagar 1987 - Thursday, May 30, 2013 12:22 AM -
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 | 829 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
Formatting the output of mdx query
But again as you can see the output of mdx query in ssis, for percentage output i think we have to mutliply it by 100 and also there must be 2 digits after the decimal point.Answered | 3 Replies | 964 Views | Created by NitinThengal - Friday, January 5, 2018 12:30 PM | Last reply by NitinThengal - Tuesday, January 9, 2018 4:49 AM -
4 Votes
MDX formula for the correlation of two dimensions
After a little try and error, I managed to modify your MDX statements for my requirements and to integrate them directly into the OLAP cube design.Answered | 10 Replies | 876 Views | Created by uwdn - Friday, March 9, 2018 1:58 PM | Last reply by uwdn - Tuesday, March 13, 2018 2:24 PM -
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 | 4810 Views | Created by amir tohidi - Thursday, March 7, 2013 8:27 AM | Last reply by Zaim Raza - Thursday, March 7, 2013 11:08 PM -
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 | 557 Views | Created by fleo - Thursday, February 23, 2017 7:41 PM | Last reply by fleo - Monday, February 27, 2017 10:00 AM -
0 Votes
MDX Select
If you do that, follow the MDX below to show the measure total value: with member measures.total as (measures.Answered | 4 Replies | 3889 Views | Created by SSAS BT - Wednesday, June 23, 2010 8:58 AM | Last reply by Jerry Nee - Friday, June 25, 2010 9:36 AM
No announcements