Stack Overflow
Stack Overflow

Questions tagged [mdx]

Multidimensional Expressions (MDX) is a query language for OLAP databases. It was developed by Microsoft but has later gained widespread support from other OLAP vendors.

What is MDX?

"Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas." Source: Wikipedia

It was originally developed as a language for Microsoft's OLAP engine (then called OLAP Services, now renamed Analysis Services) but has since been adopted by a wide range of vendors for use with their OLAP tools.

Resources

Books

3942 questions
9
votes
4 answers

Query OLAP Mondrian (MDX, XMLA) with a Python interface?

Actually I'm using R + Python with RPY2 to manipulate data and ggplot to create beautiful graphics.. I have some data in a PostgreSQL database, and I'm using psycopg2 to query data. I'm starting a thesis, and in the future I need an OLAP cube to…
reyman64
  • 523
  • 4
  • 34
  • 73
9
votes
2 answers

MDX equivalent to LIKE

In SQL I like to search a column for matches of a particular string using something like this: SELECT t.attributeNAME FROM myTable t WHERE t.attributeNAME LIKE '%searchString%' I might like to use that in a temp table and then use the result in…
whytheq
  • 34,466
  • 65
  • 172
  • 267
8
votes
1 answer

Slow Excel pivot table MDX?

I am having an extremely hard time with Excel being very slow whenever interacting with a pivot table. Adding/removing a field, changing a filter or slicer, all take several minutes of Excel being frozen before responding. It appears that the MDX…
AaronLS
  • 37,329
  • 20
  • 143
  • 202
8
votes
4 answers

Any Python OLAP/MDX ORM engines?

I'm new to the MDX/OLAP and I'm wondering if there is any ORM similar like Django ORM for Python that would support OLAP. I'm a Python/Django developer and if there would be something that would have some level of integration with Django I would be…
Bartosz Ptaszynski
  • 726
  • 7
  • 8
8
votes
1 answer

MDX Query returns value in report but not in Visual Basic code

This is for an application which dynamically sets data for and renders reports. I have an MDX query for a report which relies on a parameter. The query is: SELECT NULL ON COLUMNS, strtomember(@DateYear) ON ROWS FROM [MYDATACUBE] When running this…
Caleb Johnson
  • 376
  • 3
  • 21
8
votes
1 answer

setting a measure value to NULL if a particular dimension is used in excel

I have an SSAS-2014 cube. I want to set a particular measure to NULL if a particular dimension is being used in either axis or the filter pane of a pivot table in excel. Now, the most intuitive solution, is to scope this measure to not work with the…
BICube
  • 4,451
  • 1
  • 23
  • 44
8
votes
3 answers

MDX query containing 2 dimensions from the same Hierarchy

The relevant structures from my cube are that I have a Hierarchy with "Class" and "SubClass". I also have a Measure called "Value" which is what im trying to obtain. A simple query may look like: SELECT NON EMPTY ([Measures].[Value]) ON COLUMNS, …
Jamiec
  • 133,658
  • 13
  • 134
  • 193
8
votes
1 answer

Alternatives to OLAP SSAS Cube Pivot Tables in Excel

I am accessing OLAP SSAS Cubes on a 2005 SQL Server using Excel 2007 pivot tables and finding that refreshing some of the tables is taking >10 minutes. My coworkers seem to think it is a sad reality, but I am wondering if there are alternatives I…
asjohnson
  • 1,057
  • 4
  • 17
  • 25
7
votes
4 answers

Groupings of queries

I would like to understand what might be the highest-level groupings of how query languages can be broken up into, and why one grouping might be fundamentally different than another. For example, the groupings that I have come up with now (for…
David542
  • 104,438
  • 178
  • 489
  • 842
7
votes
2 answers

Implementing IN /LIKE in MDX

I have a dimension called [Band] and it can have several different values: [Band].&[A]&[Under $400] [Band].&[B]&[$400 - $1,000] [Band].&[C]&[$1,000 - $2,500] [Band].&[D]&[$2,500 - $3,500] ... I'm trying to write a query where I can cut by a sublist…
MetaStack
  • 3,266
  • 4
  • 30
  • 67
7
votes
1 answer

non-Windows OLAP desktop client?

Working with SSAS 2008 in an environment with mostly Mac desktops. Use DbVisualizer and Aqua Data Studio for writing relational queries, but need a native desktop app to write MDX queries and view results from OLAP sources. VMWare / Parallels is not…
kermatt
  • 1,585
  • 2
  • 16
  • 36
7
votes
1 answer

Configuring an MDX query on SSIS

Hi I am having troubles configuring the SSIS task to run an MDX query. The parse works fine but it doesn't allow me to display the different columns of the query to map it Here is the query i used: SELECT [Measures].[# Consumers] ON 0, …
Cherif Ghattas
  • 71
  • 1
  • 3
7
votes
2 answers

The query contains the XXXXXName parameter, which is not declared. SSRS2008/MDX query

Parser: The query contains the XXXXXName parameter, which is not declared. (msmgdsrv) I have no idea why I keep getting this error. It occurs when I change the MDX in the query designer and trying OKing out of the query designer. The strange thing…
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
7
votes
1 answer

How can I merge two members into one in a query?

On rows, I basically want to select all the members of a hierarchy but would like to combine two of them into one. For example, the members would include A, B, and C, so selecting [Group].[Group].members would give me All, A, B, and C but I would…
Travis
  • 663
  • 1
  • 10
  • 16
7
votes
3 answers

MDX date range query with a missing boundry date

I need an MDX query for Mondrian filtered by date, where one or both of the boundry dates may not exist. I'm using the query below that works as long as both 2013-01-01 and 2013-01-08 dimensions exist. If one of the two dates does not exist then…
Dynamite
  • 93
  • 4
1
2
3
…
99 100