You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get distinct record for Dimension field in OTBI just like SQL?

Received Response

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):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!