To come straight to the point: If you do not define an all member for a hierarchy Mondrian will implicitly create a slicer with the default member of the dimension … this is even happening if you do not mention the dimension at all in your MDX query!In example take following MDX:SELECT [Measures].[Sales] ON 0,[Sales Channels].[Sales Channel].Children ON 1FROM[Sales]If we take a look at the SQL that Mondrian generates, we suddenly see that it tries...
