This content has been marked as final. Show 3 replies
Try this - double click the Database folder in your physical layer of rpd and go to Features tab. Uncheck the value for DISTINCT SUPPORTED and save the rpd. All queries using this database will not have the distinct keyword then.
best practice: Rpd-->BMM--> Double click on Logical Source and uncheck the "Select Distinct Values" Option for the respected table.
please mark if its help you......