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
1
vote
1 answer

Sas mdx drillthrough statement

I use Sas WRS sat on a information map over a cube. My business users want to see the raw data behind each figure on a report. I have set up a drill through table but I need to limit the result data set to the measure being queried. I've come…
1
vote
1 answer

MDX: Calculated Dimensions?

I don't know if this is possible or not, or if my limited knowledge of MDX is pushing me in the wrong direction... The cube I'm dealing with has two different dimensions for dates, [Statement Dates] and [Premium Dates]. Further in the hierarchy of…
spilliton
  • 3,811
  • 5
  • 35
  • 35
1
vote
1 answer

MDX Multi-Valued Parameters from Database Query

This is my first StackOverflow question so I appreciate any help that you can give. Current Situation We have a series of SSRS reports that are deployed to SharePoint running in SharePoint integrated mode. I'm trying to create data driven…
BradD
  • 35
  • 5
1
vote
1 answer

MDX - filter measure by dimension

I'm new to MDX and I'm currently trying to filter [Measures].[Sales Invoice Line Amount] by { [NAV CINNOST].[DIM_Code_Cinnost].&[AAA], [NAV CINNOST].[DIM_Code_Cinnost].&[BBB], [NAV…
Rutz
  • 119
  • 4
  • 15
1
vote
1 answer

SSAS Cube Semi Aditive measure LastChild Across Time but MAX across Few Others and Sum Accross Portfolio

I have a SQL SERVER 2008R2 Standard Edition. The Cube has one measure called "AUM". Basically this measure is only additive across One Dimension Portfolio. Across Time I need to pick LastChild, Across Security I need to pick Max and Across Portfolio…
Anup Shah
  • 1,256
  • 10
  • 15
1
vote
1 answer

Convert MDX calculated measure, to scope in SSAS calculations

I have got a measure, getting the last value of a currency exchange rate. The fact having the exchange rates, is configured in the dimension usage with the time dimension, and is daily based. So, using MDX, I am successfully getting my converted…
Mez
  • 4,666
  • 4
  • 29
  • 57
1
vote
1 answer

create new dimensions/hierarchies on the fly

I'm totally new to MDX language and curios if it capable of doing some sort of work. There are calculated members that allows you to populate measure dimension with new data. But I have never met a reference to method that creates new dimensions…
ayvango
  • 5,867
  • 3
  • 34
  • 73
1
vote
1 answer

Exclude a measure from a level in a hierarchy (MDX/Mondrian)

I have a list of stores that provide to me their sales and transaction data. I want to do some reporting on these stores using Mondrian. Let's say I want to populate the column axis with the number of Sales by Month and then the number of…
1
vote
1 answer

SSAS MDX - Select from one dimension depending on two other dimensions

I have three dimensions, a [Transaction], [Trade Date] and [Report Date]. The [Transaction] is related to both, and I would like to define a function for a KPI in which I look for the following: For each date where there exists a trade in as a…
Daniel B
  • 8,770
  • 5
  • 43
  • 76
1
vote
2 answers

MDX: How To Aggregate Hierarchy Level Members With Same Name

Greetings, I am new to MDX, and am having trouble understanding how to perform an aggregation on a hierarchy level with members that have the same names. This query is particular to Microsoft Analysis Services 2000 cubes. I have a given hierarchy…
Dave Frautnick
  • 206
  • 3
  • 6
1
vote
2 answers

Slightly related dimensions in multidimensional design

I am using the following (simplified) star scheme as the data source for an SSAS OLAP cube: In my cube, I have measure [Days], which simply contains "1" for each date - this is just a neat way to get the number of days over some period, useful for…
Dan
  • 10,480
  • 23
  • 49
1
vote
1 answer

MDX SELECT conditionally

I am new to MDX querying and working with multidimensional data, though a project requires me to learn. We have a cube with a KPI which performs a Lag() that sums up the number of transactions that have met a requirement, based on a date. A query…
Daniel B
  • 8,770
  • 5
  • 43
  • 76
1
vote
1 answer

Stop VBA-Script from "freezing" while sending MDX-Query

I am using ADOMD 6.1 in an Excel 2010 Environment to send custom MDX Queries to an Analysis Services 2008 R2 Cube and to display the results in the excel workbook. This works fine so far, however the Excel instance is freezing while it waits for the…
Thomas Tschernich
  • 1,264
  • 15
  • 29
1
vote
0 answers

Mondrian cache is used when it shouldn't

I have a problem with what it seems to be Mondrian's cache. I have this query: SELECT { [Measures].[Searches] } ON COLUMNS, { [Date.Date].[2014].[4].[4] , [Date.Date].[2014].[4].[3] } ON ROWS FROM [Searches] that returns: …
jphorta
  • 2,144
  • 3
  • 18
  • 27
1
vote
1 answer

MDX NON EMPTY multidimension axis

I'm writting MDX code in VBA and I have to put the data in Excel. SELECT { [Measures].[VL PROD], [Measures].[Impostos], [Measures].[RecLiqProd], [Measures.[ValorMgProd], [Measures].[QTD ITENS] ,[Measures].[VL FRETE] } ON 0, NON EMPTY ( {…
Fabio Rebelo
  • 109
  • 2
  • 5
  • 13
1 2 3
99
100