Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

selecting multiple members from cube for detail filter

  • 1.  selecting multiple members from cube for detail filter

    Posted 12/07/21 09:33 AM
    Hi,
    I have a challenge with one of the DQM reports
    from the cube, I need to select multiple members for detail filters 
    In the report, I' am using static choices like A, B, C, D

    if the user selects 'A' 
    then report should display some parents and child members from the hierarchy

    if the user selects 'B'
    then report should display only some children from the hierarchy

    if 'C'
    then all parents from the hierarchy

    if 'D'
    then some parents and child members from different hierarchies

    can someone help me how to code this in detail filter using case statements?

    Thanks in advance

    ------------------------------
    p sripadh
    ------------------------------

    #CognosAnalyticswithWatson