Drill-through does not work

Edit Subject

Hello Dinesh,
thanks for sharing the problem. I need more information to investigate it further and find a possible solution for you.

1) Have you used the embedded Apache Derby database? If you have installed it with DQ Analyzer and used data source called DB to write drill-through, then you did. Otherwise you used your another database and in that case I need to know, what type of database it was and what driver have you used.

2) Can you please check, whether the profile was really completed successfully? If it is possible, rerun the job and check the console for any warnings. If the creation of drill-through fails, DQ Analyzer will create the profile file anyway and writes only a on line message on the console.
You can also check this in Profile file metadata. Choose the file in File explorer and under Properties view (usually bellow the main editor screen) there is a Metadata tab. At the bottom of the tab is the information regarding the drill-through database connection and if drill-through id and drill-through stamp are unfilled or 0, then something went wrong during the creation.

3) Have you tried any other place for possible drill-through? For example double clicking a value in Frequency analysis tab?

Hi
I have no problems now and it works.
I used the Derby DB now and it works. Earliner my odbc connection to data source apparently had some issues.

Thanks much

Thanks for the clear and concise steps.

Hi,
no problem at all, nice to hear it works for you now.