Top "Mdx" questions

Multidimensional Expressions (MDX) is a query language for OLAP databases.

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 …

filter mdx slice iccube
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 …

filter mdx pentaho
Rounding of calculated measure in MDX

How can i round a calculated mdx measure up to the nearest integer without having Excel on the server? The …

rounding mdx ssas
MDX: IIf condition on the value of a dimension is always false

I am trying to produce a different output in a column dependent on whether the value of a dimension [Scenario].[…

sql-server ssas mdx ssas-2008 iif
How do I define a Calculated Measure in MDX based on a Dimension Attribute?

I would like to create a calculated measure that sums up only a specific subset of records in my fact …

sql-server ssas olap mdx
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://…

c# mdx adomd.net
Using DateDiff in SSAS MDX

I would like to write a KPI in SSAS which gives me back the average of all the employee's age. …

ssas mdx kpi
Calculated Member based on dimension attribute value

I want to make some Calculated Measures in my cube that conditionally use a value from the measure table, based …

mdx dimension ssas-2008
Convert "YYYYMMDD" format string to date in MDX?

I have some issue with applying date related functions on the "YYYYMMDD" format string in MDX. For example, if I …

sql-server-2012 mdx date-format date-conversion
Best option to retrieve Anaylysis Services (SSAS) cube data dynamically in ASP.NET MVC

I need to dynamically add/remove dimensions and facts in web application and get results from SSAS. The cube in …

asp.net-mvc ssas mdx