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

Using Parameter Maps in Report Studio

  • 1.  Using Parameter Maps in Report Studio

    Posted 05/08/24 11:02 AM
    Edited by Adam McIlravey 05/08/24 11:49 AM

    CA 12.0.2

    I have a Parameter Map created in Framework Manager showing a set of relative dates to today's date.
    This appears to be working fine in Framework Manager with the PARM and VALUE showing as expected in all cases.

    However, when I want to use the Parameter Map within Report Studio, I cannot select the entries I want.
    I can see the full Parameter Map Name as below looking like I can explode it out to select the particular Parm.


    However, when I attempt to explode nothing happens other than the '>' disappearing as below:


    However, I can manually enter the Parm into a calculation (for this example) and have it return the expected result as below:

    I experienced a similar issue on an older version of Cognos, but IBM instructed that this issue had been resolved.
    Is it recurring again in the new CA 12.0.2 release/version?

    I found in my history:
    From IBM:
    The following APAR has been logged successfully and it is in Open state now (i.e Development has approved this apar as a defect and it will be fixed in a future release).

    PH10805 CREATING A PARAMETER MAP IN FM USING A QUERY ITEM CAN NOT BE EXPANDED IN REPORT AUTHORING

    Using Parameter Maps enables much faster run times due to not having to do calculations all the time.
    It is inconceivable that the business users should know all the potential Parms and manual key them in rather than selecting from a defined list.

    Any thoughts on how to resolve this would be greatly appreciated.
    Thanks, 



    ------------------------------
    Adam McIlravey
    ------------------------------