Top "Mdx" questions

MDX Calculated member filter by dimension attribute

I want to create a calculated member and filter it by dimension. This is WORKING example: ( [Policy].[Policy Status].&[…

filter mdx member dimension

SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax …

sql-server ssas mdx where-clause olap

How to exclude a certain member from a MDX call that gets all descendants of a member at a higher level

In an OLAP database I work with there is a 'Location' hierarchy consisting of the levels Company -> Region …

mdx

List dimension members with MDX query

Is there a way to list dimension members without fetching default Measure for each member?

mdx ssas

Difference between tuple and set in mdx

What is the difference between tuple and set in MDX. How we can distinguish both and when we are using …

sql ssas mdx

How to learn MDX

I am currently learning OLAP & MDX after many years of relational database development. Any tips on getting started in …

ssas olap mdx

View MDX query generated while browsing a cube in SSMS

In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. …

sql sql-server ssas mdx cubes

Filtering a Measure (or Removing Outliers)

Say I have a measure, foo, in a cube, and I have a reporting requirement that users want to see …

mdx cube cubes

MDX query containing 2 dimensions from the same Hierarchy

The relevant structures from my cube are that I have a Hierarchy with "Class" and "SubClass". I also have a …

mdx adomd.net

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 …

sql-server ssas mdx cube