Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  If statement in parameter map

    Posted Tue September 29, 2020 12:20 PM

    Is this possible? To make an if statement in a parameter map? If not, any idea how we could go about one?

     

    Vic

     

     

    Vic Nicholls

    ODU Business Intelligence

     


    #CognosAnalyticswithWatson


  • 2.  RE: If statement in parameter map

    Posted Tue September 29, 2020 02:47 PM

    Yes, it is.  Here's a quick example.

    Parameter map
    Macro in a query item


    ------------------------------
    IAN HENDERSON
    ------------------------------

    Original Message


  • 3.  RE: If statement in parameter map

    Posted Mon October 05, 2020 10:39 PM

    If your question was about conditions in macro syntax, see simple-case which is available when using Dynamic Query.

    i.e. section 4.2.4 http://www.redbooks.ibm.com/redbooks/pdfs/sg248121.pdf

    The value associated to a key be a valid expression (as you would enter into a calculaiton/filter)

    ​

    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message