Duplicate Row

[srale]

I have a fact table with Duplicate row (all are valids).
I have a report and I need that Business Object Include all rows (with duplicate).

I went to Options- Query Options - With Duplicate Row and I select "With Duplicate Row", but Business Object no include into the reporte the duplicate row.

¿Can I do?

Thanks

 

[Guest_imported]

Hi,
Include the rowid in your query (in universe or Free-hand sql) and grey it out so that it is not 'that' visible!

 

[GKar]

Hi,
Or you can select the table, go to the menu Format>>Table and then check "avoid duplicate rows aggregation" option in the "general" tab.

Hope it will help
GKar

 

[BobWard]

I recomend the slution by Gkar.