Show Duplicate Records option as a global setting
28 April, 2015
Hi Support,
Is there a way to enable "Show Duplicate Records" option in the report builder globally instead of enabling this option in each report. We need to retrieve records without DISTINCT keyword in all our reports.
Thanks
Supun
Is there a way to enable "Show Duplicate Records" option in the report builder globally instead of enabling this option in each report. We need to retrieve records without DISTINCT keyword in all our reports.
Thanks
Supun
Hi Supun,
Unfortunately this isn't currently possible within the Yellowfin UI. However, an enhancement request has been opened for this previously:
#105243 - Global setting for - Show duplicate records
I will go ahead and make an entry in the enhancement request to show continued customer interest in this enhancement. Hopefully it will be considered in the near future.
In the mean time, you could modify the YellowFin configuration database to enable 'Show Duplicate Records' on all of your reports. As always we recommend that you back up your Yellowfin configuration database before making configuration changes!
If you would like to enable Show Duplicate Records for all of your reports, please run the following SQL query against your SQL database:
[code]INSERT INTO reportformat (reportid, entitycode, entityid, formattypecode, formatcode, formatvalue,
description, fieldid, chartid, seriesid, axiscode)
SELECT DISTINCT reportid, 'REPORT', 0, 'REMOVEDISTINCT', 'true', 0,
'', 0, 0, 0, '' FROM reportformat WHERE NOT EXISTS (SELECT *
FROM reportformat
WHERE formattypecode = 'REMOVEDISTINCT');[/code]
Hopefully this information helps! If not please feel free to reach out again.
Have a great day.
Kind Regards,
Dustin
Best regards,
The Yellowfin Support Team
Contact Us:
Email: support@yellowfin.bi
Wiki: wiki.yellowfin.com.au/display/USER71/Home
Community Forum: www.yellowfinbi.com/YFForum.i4
Unfortunately this isn't currently possible within the Yellowfin UI. However, an enhancement request has been opened for this previously:
#105243 - Global setting for - Show duplicate records
I will go ahead and make an entry in the enhancement request to show continued customer interest in this enhancement. Hopefully it will be considered in the near future.
In the mean time, you could modify the YellowFin configuration database to enable 'Show Duplicate Records' on all of your reports. As always we recommend that you back up your Yellowfin configuration database before making configuration changes!
If you would like to enable Show Duplicate Records for all of your reports, please run the following SQL query against your SQL database:
[code]INSERT INTO reportformat (reportid, entitycode, entityid, formattypecode, formatcode, formatvalue,
description, fieldid, chartid, seriesid, axiscode)
SELECT DISTINCT reportid, 'REPORT', 0, 'REMOVEDISTINCT', 'true', 0,
'', 0, 0, 0, '' FROM reportformat WHERE NOT EXISTS (SELECT *
FROM reportformat
WHERE formattypecode = 'REMOVEDISTINCT');[/code]
Hopefully this information helps! If not please feel free to reach out again.
Have a great day.
Kind Regards,
Dustin
Best regards,
The Yellowfin Support Team
Contact Us:
Email: support@yellowfin.bi
Wiki: wiki.yellowfin.com.au/display/USER71/Home
Community Forum: www.yellowfinbi.com/YFForum.i4