• sspaeti (8/22/2016)


    For example if I tried with the "Siglum Internal" then one problem was, that I could only count if the "Siglum internal" was shown on the result table. But what if I want to count them on the lowest level BUT also want to aggregate on a higher level like only year without any siglum? Then it didn't work any longer..

    Correct...if the "Siglum Internal" field is not part of the result set, then the currentmember() function would return the "All" member. If you think about this it makes logical sense, because your query isn't "stepping down" to any member level within that dimension attribute.

    If you still want to do that, use the Descendants() function to "step down" to a specific level within the dimension hierarchy. See reference here: https://msdn.microsoft.com/en-us/library/ms146075.aspx