How to remove duplicate rows in OBIEE analysis

ForSly

I have an analysis that is producing multiple rows as shown on the attached screenshot and I wanted to know if there is a way to eliminate the  duplicate rows. In this example the expected results is one row per job name per date.

.

[Deleted User]

You're not providing any information that could help us help you. What's the raw data? Why are there 2 rows? What non-displayed attribute causes there to be two rows? What's the grain of the query?

This is analytics. Not Excel.

ForSly

this is oracle OTBI  cloud product  -I don't have visibility of the rpd or the database that is kept by oracle , I only have access to subject areas. Given that I don't have the database access , how can I tell the grain of the data or even the attribute that is causing an issue.

[Deleted User]

ForSly wrote:this is oracle OTBI cloud product -I don't have visibility of the rpd or the database that is kept by oracle , I only have access to subject areas. Given that I don't have the database access , how can I tell the grain of the data or even the attribute that is causing an issue. 

As the post referenced an "OBIEE analysis" and didn't explain you situation as you just did above, you may understand that it was impossible to divine this information from our side. Providing a useful and detailed problem description with context from the beginning would help us help you and prevent wasting time.

Never forget that we're neither sitting in front of your screen nor can automagically pull up information on it.