Cognos Analytics

 View Only

 Report using parameter map does not display data

Mack L's profile image
Mack L posted Wed January 14, 2026 05:25 AM

Hi,

I working to fix a report that uses a parameter map from the  model. The report is not displaying data any more. The parameter map has user IDs and the value 'Y' for the Key-value pair. The user who has been included in the parameter map should be able to see data in the report when he runs the report. There are two measure columns that dynamically display data depending on whether the user's ID (Account.defaultName) is in the parameter map or not.

The logic used in the measure columns is as follows:

Case #sq($Amounts_Access{$account.defaultName  })#

when 'Y' then [Amount]

Else

null

End

If the user ID of the user is in the parameter map (key = user id, value = 'Y'), then the amount columns are populated  and for any other user the columns should show nulls. What is actually happening is that the report is not throwing data for any user (No data available). Please suggest.

Marc Reed's profile image
Marc Reed IBM Champion posted Thu January 15, 2026 02:39 AM

I would start by checking the SQL created when the user is not in the parameter map.

You could simulate this by just replacing your calculation above with

case when 1=2 then 1 end

as this calculation returns a null.

Notice that you can simplify your calculation. You don't need the 'else null' as a case statement returns a null if there are no true conditions within the case statement (just like my example calculation above). 

When you get the SQL post it back here and we can take a look.

Mack L's profile image
Mack L posted Fri January 16, 2026 07:41 AM

Hi @Marc Reed,

Thank you for the tips. On checking with the two ways i.e., 1) using the test expression (case when 1>2 then 1 end), 2) removing the else part of the original case expression, I am getting the same result - 'no data available' in the report. The model level macro is returning only null in both the cases. Please see the sql result (portion showing the two measure columns) below.

Test expression: 

Original expression:

Please suggest.

Related Content