Post reply

Dimension security by using MEMBER_NAME

  • August 16, 2013 at 4:11 pm

    #1642348

    This did the trick:

    filter

    ([Dimension].[AttributeHierarchy].allmembers

    ,instr([Dimension].[AttributeHierarchy].CurrentMember.MEMBER_VALUE, '592') > 0)

  • August 17, 2013 at 7:23 am

    #1642409

    As per suggestion from Darren Gosbell I changed the way of solving this, to get better performance:

    I created a new, hidden attribute where the key is only the second part of the composite key in the other attribute. Then I reference one single member of the new attribute hierarchy as the allowed set:

    [Dimension].[AttributeHierarchy_hidden].&[592]

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply