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
31
votes
10 answers

How to learn MDX

I am currently learning OLAP & MDX after many years of relational database development. Any tips on getting started in MDX? What are the best books and resources to learn MDX?
Craig
  • 1,327
  • 1
  • 13
  • 15
24
votes
1 answer

Designing dimension hierarchies: Natural or Unnatural

I'm using Analysis Services and when designing dimensions I'm never sure how far to go to build natural hierarchies. What I mean is I've added in all the genuine attribute relationships. So most hierarchies are natural anyway but the most commonly…
Craig
  • 1,327
  • 1
  • 13
  • 15
19
votes
5 answers

Different approaches to accessing SSAS

I’m interested in knowing some different approaches for retrieving data from Analysis Services, to use in either objects in code, or for end-user reporting. I’ve used two different approaches in the past, one was using ADOMD to pull results and put…
Meff
  • 5,889
  • 27
  • 36
18
votes
4 answers

List dimension members with MDX query

Is there a way to list dimension members without fetching default Measure for each member?
Žygimantas
  • 725
  • 3
  • 7
  • 13
15
votes
2 answers

MDX Calculated member filter by dimension attribute

I want to create a calculated member and filter it by dimension. This is WORKING example: ( [Policy].[Policy Status].&[Void], [Policy].[Tran Type].&[Renewal], [Measures].[FK Policy Distinct Count] ) But if I want to filter it like…
ilija veselica
  • 9,414
  • 39
  • 93
  • 147
15
votes
2 answers

The best MDX references on the net

What is the best references/links,cheatsheets for the MDX language? Here are a few starters that I have collected. Please share yours…
Anders Rune Jensen
  • 3,758
  • 2
  • 42
  • 53
15
votes
4 answers

View MDX query generated while browsing a cube in SSMS

In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. This displays the required data. I want to know if there is a way to view the MDX query being generated behind the scenes to display the…
stackoverflowuser
  • 22,212
  • 29
  • 67
  • 92
15
votes
2 answers

How to exclude a certain member from a MDX call that gets all descendants of a member at a higher level

In an OLAP database I work with there is a 'Location' hierarchy consisting of the levels Company -> Region -> Area -> Site -> Room. I am using the following MDX to get all the descendants of a particular member at company…
Tim C
  • 70,053
  • 14
  • 74
  • 93
14
votes
4 answers

Difference between tuple and set in mdx

What is the difference between tuple and set in MDX. How we can distinguish both and when we are using them.
Searcher
  • 1,845
  • 9
  • 32
  • 45
13
votes
1 answer

R clients to OLAP MDX servers

Has anyone tried to access an OLAP server offering a XMLA API (such as Mondrian) from R? I'd love to run MDX queries from R against Mondrian and retrieve result sets.
Xavier Guardiola
  • 2,699
  • 3
  • 19
  • 11
12
votes
1 answer

MDX Calculated Member CrossJoin question

I have an MDX query with the following calculated member: with member [Measures].[BBOX] as Count( Filter( CrossJoin([Dim Response].[Response ID].Children, [Dim Question].[Question Text].Children), [Measures].[Question Bottom Box]…
Ryan
  • 121
  • 1
  • 3
11
votes
2 answers

OLAP - Calculate run-off triangles, sample data and cube included (PostgreSQL/Mondrian)

Reality description: We do have a list of projects. In every project there is a lot of accounts. You can do a lot of actions on every account. I do have the following dimensions and fact table defined (simplified): Dimensions and attributes: …
Tomas Greif
  • 21,685
  • 23
  • 106
  • 155
11
votes
1 answer

MDX Error "Hierarchy already appears in the Axis0 axis"

In the following MDX queries SELECT { [EffectiveDate].[Period].[All].CHILDREN, [EffectiveDate].[Period].[All] } ON COLUMNS, NON EMPTY { [Account].[Hierarchy].[Account Type].&[Assets].CHILDREN, [Account].[Hierarchy].[Account…
user1750761
  • 111
  • 1
  • 2
  • 4
10
votes
1 answer

Is there a (open-source) MDX-based in-memory OLAP server?

I was wondering if there is a in-memory OLAP server which can handle MDX. I found the Wikipedia article. But it says nothing about in-memory functionality... The only one I know of them is Mondrian, which is also one of the two open-source solutions…
DennisH
  • 383
  • 3
  • 11
9
votes
1 answer

Calculated Member for last-child in non-time dimensions?

In a SSAS cube, how do I create measures that are aggregated as LastChild for a non-time dimension? The source data has many versions of the same business record on any given day. The time dimension has a granularity of DATE, not seconds &…
Mark
  • 9,320
  • 6
  • 57
  • 70
1
2 3
…
99 100