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
6
votes
1 answer

Using Filter on measures in MDX query on SSRS

i've creted a report using a cube as datasource and MDX query on my dataset. i have a few measures in my dataset but i want to show wonly the rows with at least one of the measures > 0, using something like an OR filter (measure1 >0 or measure 2 >0…
user1508682
  • 1,329
  • 5
  • 23
  • 34
6
votes
4 answers

Combining Relational and OLAP data in an MDX Query

I have an SSAS 2008 cube that is being used to house end of day financial data from the stock market. The cube is only processed once a day after the market closes, so it never has any information about the current intraday trading data. I also…
mclark1129
  • 7,532
  • 5
  • 48
  • 84
5
votes
5 answers

How are most people using MDX queries? Should I be using MDX results to drive a web UI?

I'm trying to do some analysis for an upcoming project. It has something to do with trending, charting and analysis; so think MAX, MIN, AVG, SUM etc over a period of time. Say we have an OLAP cube that's setup to figure out these calculations…
topwik
  • 3,487
  • 8
  • 41
  • 65
5
votes
3 answers

How to retrieve data from mdx query in c#?

I am trying to get data from an MDX query using the Adomdclient library. I relied on this example http://www.yaldex.com/sql_server/progsqlsvr-CHP-20-SECT-6.html. MDX query: SELECT {[Measures].[Cantidad Vta],[Measures].[Monto…
auraham
  • 147
  • 1
  • 2
  • 10
5
votes
0 answers

Find Number of times a particular character appears in a string using MDX query

In the Microsoft SSAS, I have a dimension column that contains multiple values separated by the special character | in a single row as below. Example value of a row: Image|Video|Audio| Requirement: So, I need to count the number of values present in…
Sathish G
  • 91
  • 3
5
votes
1 answer

Multiple dimensions conditions in SSAS MDX query not working

I Am having the following data in my SSAS cube. My need is to get the value of the measure based on two conditions with two different dimensions using the MDX. In this example data, I need to get the Reseller Sales Amount value where the value…
TAMILARASAN R
  • 225
  • 1
  • 6
5
votes
1 answer

IIF() function not working properly while using multiple times in single MDX query

I need to get the aggregated values based on two conditions using single MDX query Am having below data I have created two calculated functions using IIF() function in a below query WITH MEMBER [Measures].[Expression1] AS…
TAMILARASAN R
  • 225
  • 1
  • 6
5
votes
2 answers

Tabular Cube - Excel Filtering Doesn't Function At Node Level

I have the issue described in this post. I have two cubes with the same data backing them, one a Multi-Dimensional cube, the second a Tabular cube. If I connect to the cubes with excel and drag the top level of a hierarchy(in this example "Company"…
David Rogers
  • 2,601
  • 4
  • 39
  • 84
5
votes
1 answer

MDX: count number of members selected in filter

I have one dimension that I want to put into filter, and created calculated member that should dynamically show number of selected members from the dimension. The dimension does not have an All member. So this is my attempt with member…
vldmrrdjcc
  • 2,082
  • 5
  • 22
  • 41
5
votes
2 answers

Best Way to Access MS Analysis Services Cube from Java

I want to issue MDX against a MSAS cube from a Java client. What connectivity approaches have proven to be reliable for this?
David Collie
  • 665
  • 2
  • 7
  • 21
5
votes
3 answers

Any way to control number of decimal places while browsing SSAS cube?

When I browse the cube and pivot Sales by Month ,(for example), I get something like 12345.678901. Is there a way to make it so that when a user browses they get values rounded up to nearest two decimal places, ie: 12345.68,…
tedt
  • 51
  • 1
  • 1
  • 2
5
votes
1 answer

Mondrian: calculating filter totals

I have this MDX query: with member [Measures].[count] as '[Measures].[NUMBER]' ** member [Measures].[total] as 'sum({[RECORD_TYPE.VALUES].[All VALUEs].children})' ** member [Measures].[% records] as '([Measures].[count] /…
Rafael Segovia
  • 247
  • 3
  • 11
5
votes
0 answers

Difference between two measures filtered with MDX SSAS

I'm having an issue concerning a calculated member that calculates the difference between two calculated members. that's how my measures looks like in SSAS Browser : Phase Measure 1 Measure 2 P1 50 30 P2 123 …
El houcine bougarfaoui
  • 35,805
  • 9
  • 37
  • 37
5
votes
2 answers

SSAS dealing with non linked data

I'm trying to compare forecast data with sales data in a cube. Sometimes we have a forecast with no actual sale, sometimes we have a sale with no forecast. How do just show 0% if one or the other does not exist? This is my current code... Green…
jhowe
  • 10,198
  • 19
  • 48
  • 66
5
votes
3 answers

MDX YTD calculated measure

I'm still new to MDX and I'm trying to get some basic functions to work in my SSAS cube. Can you guys point out what I'm doing wrong here? I've added a calculated measure to my cube with the following code: CREATE MEMBER…
Jens
  • 3,249
  • 2
  • 25
  • 42
1 2 3
…
99 100