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
7
votes
3 answers

Is there any way to use LINQ for MDX queries?

Anyone know if there are plans for LINQ to MDX . Does any way currently exist to use LINQ with MDX / CUBES
Stuart
  • 11,775
  • 6
  • 33
  • 31
6
votes
3 answers

MDX support for Hive (Hadoop)

Is there any support for Multidimensional Expressions (MDX) for Hadoop's Hive ?
Swaroop Vajrapu
  • 106
  • 1
  • 7
6
votes
1 answer

MDX Get Min Max Date From Slicer Element

I am using PowerBI Desktop/Service as a Front-End and Analysis Services Multidimensional as Back-End. I want to create a complex calculated member but I have a problem in some part of the member. For example, I need to have the MIN/MAX DATE of the…
Stavros Koureas
  • 1,126
  • 12
  • 34
6
votes
2 answers

MDX: Filtering a member set by a measure's table values

I have some numbers in a fact table, and have generated a measure which use the SUM aggregator to summarize the numbers. But the problem is that I only want to sum the numbers that are higher than, say 10. I tried using a generic expression in the…
oyvinro
6
votes
0 answers

MDX and SSAS - Subtotal on Filtering in Power BI

I have a sales cube deployed in SSAS that need to be displayed using Power BI. Assume that I have arrange a layout – simulated with Excel - like the following, a dimension (Product - with 5 members) and two Measures (Measures 1 and Measures 2).…
Dino
  • 781
  • 3
  • 14
  • 32
6
votes
2 answers

MDX Doesn't show last version of data

i need a little help to figure out a problem i have in MDX. I want to show the last version per period of a measure even if the value is NULL. But my code show me the last non empty version. Example : Here is my code : (the visible measure in the…
Reda Maachi
  • 853
  • 6
  • 15
6
votes
2 answers

SSAS MDX query as Azure Data Factory source in Linked Service

This question might not be well researched but I need to find out proper way to implement this solution before starting design. Question is, Can we consume SSAS MDX query as datasource in Azure Data Factory Linked Service source?
arpan desai
  • 889
  • 2
  • 13
  • 23
6
votes
1 answer

Reading SQL Analysis Services Metadata

I have a number of objects in my SSAS cube, many of which were created to be invisible. For example: CREATE MEMBER CURRENTCUBE.[Measures].[Latency Backcolor] AS CASE WHEN [Average Latency] > [Web Alert] THEN 6384849 WHEN [Average Latency] > [Web…
BillP3rd
  • 1,009
  • 1
  • 9
  • 21
6
votes
4 answers

Which pentaho mondrian library to include in a Java application to have mapping MDX to SQL

I want to implement an application that provides support for MDX queries. For this purpose I would like to use one of libraries from pentaho mondrian (an open source OLTP server with the MDX interface) that transforms MDX queries into SQL of…
Skarab
  • 6,981
  • 13
  • 48
  • 86
6
votes
3 answers

Where can I download a ascmd.exe?

I need to execute MDX query from command line (MS AS 2005). I have heard, that there is a program named ascmd, which can do this. Unfortunately, when I went to codeplex page I found that page supposed to deliver an ascmd doesn't work. Please help if…
michal
6
votes
2 answers

MDX: Filtering and slicing on different members of the same dimension

I am using icCube's Sales cube to learn MDX. I would like to write an MDX query to show the revenue from sales in 2009 for those countries where the revenue from sales in 2010 was over $80,000. I tried the following, but it returned an empty table…
AlwaysLearning
  • 7,257
  • 4
  • 33
  • 68
6
votes
1 answer

JSON Result From SSAS Cube

I am new to working with Business Intelligence/Analysis Services and MDX queries. I am developing a web app that pulls/embeds reports from a report server (SSRS reports build upon this cube data), however the result is slow and the resulting look is…
scniro
  • 16,844
  • 8
  • 62
  • 106
6
votes
1 answer

MDX SSAS - Max Date in Measure

Just need to get MAX date in ALL my Measures in the Cube. For instance, DateID is a Dimention, [Measure].[First Measure],...,...,[Second Measure]. How to get list of MAX(DateID) from all Measures in my Cube.
user2744070
  • 61
  • 1
  • 2
6
votes
4 answers

MDX performance vs. T-SQL

I have a database containing tables with more than 600 million records and a set of stored procedures that make complex search operations on the database. The performance of the stored procedures is so slow even with suitable indexes on the…
Mostafa Elmoghazi
  • 2,124
  • 1
  • 21
  • 27
6
votes
2 answers

Regular expression for extracting element from MDX Query

I would like to extract information, or the query axis element from a given MDX query. Suppose I have this query : SELECT NON EMPTY { Hierarchize({[Product].[Product Family].Members}) } ON COLUMNS, NON EMPTY Hierarchize ( Union ( …
Daniel Ginting
  • 91
  • 9
1 2
3
…
99 100