Search code examples
ssasmdx

In MDX, are there query-scoped dimensions, hierarchies, and/or cubes?

I'm using MDX and Microsoft SQL Server 2008 Analysis Services. I know that in an MDX query, you can define query-scoped calculated members. (See Microsoft.com.) Is it also possible to create query-scoped dimensions, hierarchies, and/or cubes?

Solution

  • No, you only can have query scoped members and sets (and -nearly never used - query scoped calculations). In Essbase, but not in Analysis Services, you can also have query scoped tuples. But you cannot have any other query scoped objects in MDX.