Top "Mdx" questions

Filtering MDX query with current year & month using Now()

How can I filter data in MDX with current Year & Month? What I did so far is: WHERE strtomember{ […

ssas mdx olap-cube ssas-2008

Query OLAP Mondrian (MDX, XMLA) with a Python interface?

Actually I'm using R + Python with RPY2 to manipulate data and ggplot to create beautiful graphics.. I have some data …

python mdx olap psycopg2 xmla

MDX equivalent to LIKE

In SQL I like to search a column for matches of a particular string using something like this: SELECT t.…

ssas mdx

Using NOT IN in an MDX query

I am trying to filter out some points from a dimension in my MDX select query. I have used the …

mdx mondrian

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 …

mdx

How to sum a calculated measure?

I have a fairly complex calculated measure that works perfectly for each row of data from a cube. However, I …

ssas mdx data-warehouse olap ssas-2008

Can't get filter to work with multiple conditions

I'm trying to make a MDX query for use with SSRS later on. To start with the basic query that …

filter ssas ssms mdx

MDX Column Alias for use in SQL

I'm trying to query our SSAS cubes and return the values into a SQL view for use as parameters in …

sql tsql ssas mdx olap-cube

Filtering a Dimension Relative to a CurrentMember in MDX

I'm having a bit of trouble accomplishing something that I think should be relatively straightforward in MDX. I would like …

ssas mdx olap ssas-2008

Mdx , All and All Members differences

In MDX what is the difference between [Period].[Period Name].[Period Name].ALLMEMBERS and [Period].[Period Name].ALL are these …

ssas mdx