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.