locked
Named Set Filtered on few hierachy items RRS feed

  • Question

  • Hi,
    could some help me on the MDX syntax for below problem
    i need a named set created with only few data items from that hierachy ..
    example include in the named set only those  topics by the name 'Finance' and its subtopics(children)
    something like
    {
    [TopicDim].[Topic Hierarchy].[Topic].&[Finance].children,
    [TopicDim].[Topic Hierarchy].[Topic].&[Marketing].children
     }

    my hierarhy is called topic a balanced one with 'topic' and 'sub topic'..subtopic as lowest level

    thanks in advance

    Tuesday, January 12, 2010 9:18 PM

Answers


  • If you want to include the Finance and Marketing topics and their subtopics it would look something like this:

    DESCENDANTS({[TopicDim].[Topic Hierarchy].[Topic].&[Finance],
    [TopicDim].[Topic Hierarchy].[Topic].&[Marketing]},
    [TopicDim].[Topic Hierarchy].[Subtopics],
    SELF_AND_BEFORE)



    Dan English's BI Blog
    • Marked as answer by mrtnpl Saturday, January 16, 2010 5:05 PM
    Thursday, January 14, 2010 11:53 AM