For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to get distinct record for Dimension field in OTBI just like SQL?
Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ?
Content (please ensure you mask any confidential information): As seen below, there are 2 records for SONYA under Marking field.
case when LENGTH("- Rating Level"."Rating Description")>0 then "- Rating Level"."Rating Description" else 'N/A' end
If I put a filter saying "is not null", the report removes all Null values however, I want other blank records as well. Its just for SONYA, I wish to display not null record.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):