Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
02/06/2024 12:53 PM
Hi Saviynt,
I am trying to export some data using the data analyzer but my SQL query is getting capped at 100 results. Is there a way to get around this cap so I can export the full results of the query rather than the 100 top results?
Thanks in advance!
Solved! Go to Solution.
02/06/2024 01:07 PM
Hi @JFrance ,
You can create an SQL query analytics using same query and get the result in form of email.
Br, Amit
02/06/2024 01:08 PM
Is there documentation on how to do this?
02/06/2024 01:14 PM
This should have all that you need - https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter16-SSM-Analytics/Managing-An...
Thanks,
Amit
02/06/2024 01:33 PM
Click Create New Analytics.
Select Using SQL Query. The Create New Analytics Configuration page is displayed.
If the SQL query that you entered in the control configuration, returns more than or equal to ten records, then the analytics preview displays all the ten records. If the query returns less than ten records, the preview displays those many numbers of records.
The Preview button is enabled before you click the Create button. Once the analytics control is created, you cannot view the Preview button.
The Preview button is used to validate the correctness of the query syntax and to display the first 10 rows of the result data. This does not validate columns in the analytics query for the allowed action. An error message is displayed if the query syntax is incorrect. You can view the error details from the log files or by executing the same query directly in the database.
The Create button must be used as the final step in the creation of the analytics control. This validates the mandatory columns in the analytics query for the allowed action. You will be able to select the visible and filterable columns for the control and submit the control creation only if all validations are complete.