When I run this mdx query, works fine (get the children members from a hierarchy level):
select {} on columns,
[Dimension].[hierarchy].[level].children on rows
from [Cube]
But, when I add some tuple on rows, doesn't filter filter the children members (shows all the members) :S
select {} on columns,
[Dimension].[hierarchy].[level].children
* [Dimension2].[hierarchy2].[level2].allmembers on rows
from [Cube]
[Dimension].[hierarchy].[level].children
as the functionchildren
cannot be applied to [Level] - it can only be applied to a [Member] .... is it definitely a level in your first script ? – whytheq