This content has been marked as final. Show 2 replies
Try to use LOWER function (u can do it via BMM or analysis).
example: use lower fxn on your col.
LOWER("Time"."Per Name Month")
I would say, this is a data quality issue in your mart. However, if you would like to still resolve it from BI Side, I suggest you to try using 'CASE_SENSITIVE_COMPARISION' parameter in your NQSConfig.ini. Set it to 'ON' and have a filter in your report for the capital 'Enterprise'
Hope this helps.