Dataset
Create, manage and execute data queries in your reporting database. This data can be used in Analytics Studio to build indicators.
The Dataset is only available if you have view, edit, and delete permission for certain resources:
- Access Technology > Administration > Authorization > Paper Management;
- click inTo edit on the paper that will have permission;
- Under Permissions, clickResource and determine the following actions for each resource:
- To view:
- res://senior.com.br/platform/dataset/dataset
- res://senior.com.br/platform/report_database/metadata
- res://<tenant-domain>/custom/report_database_metadata/<schema-desejado>
- To edit : res://senior.com.br/platform/dataset/dataset
- Delete : res://senior.com.br/platform/dataset/dataset
- To view:
Important
The Dataset has a limit of 1000 records per query, and an execution time limit of 30 seconds.
What can you do:
Create Dataset - Visual editor
- Access Technology > Administration > Dataset > New dataset;
- Enter the data to identify the Dataset and clickVisual editor for settings;
- Add the tables. When more than one table is selected, the optionExpressions... is available for inclusion of the fields responsible for theJoin in the Dataset;
- Choose the data inProjection and, optionally, determine the grouping, ordering and filtering of table fields;
- click inTo save.
When adding a Dataset, the resource res://<tenant-domain>/custom/dataset/<dataset-id>, which is linked only to your user. To share it, you must add permission for this resource, for each desired role, including administrator.
Create Dataset - API
- Access the menu Technology > Administration > Dataset > New dataset;
- Enter the Name and Description to identify the dataset;
- Then select API mode;
- Enter the HTTP method, API URL and Authentication in the Dataset Settings;
- The API Return must be selected according to the data returned from the call, if it is in JSON format it is necessary to inform the API return property, if the return is in CSV it is necessary to inform the data delimiter;
- In the Body of the Request, enter the input parameters required to execute the API;
- In Request Headers it is possible to enter Authorization, Content-Type and Tenant automatically or include new ones manually;
- In Projection it is possible to configure automatically, based on the dataset return, or manually the information;
- Click Save.
At any time you can clickTo view To see a preview of the dataset, you can also click onCancel to discard the changes.
Important
When adding a Dataset, the resource res://<tenant-domain>/custom/dataset/<dataset-id>, which is linked only to your user. To share it, you must add permission for this resource, for each desired role, including administrator.
Create Dataset - SQL Editor
Go to Technology > Administration > Dataset > New dataset, enter the data to identify the Dataset. click inSQL Editor, build the SQL as needed and clickTo save.
When adding a Dataset, the resource res://<tenant-domain>/custom/dataset/<dataset-id>, which is linked only to your user. To share it, you must add permission for this resource, for each desired role, including administrator.
Edit or delete a Dataset
Editing and deleting a Dataset must be done in Technology > Administration > Dataset > Manage.
click inTo edit in the created Dataset, make the necessary changes and clickTo save, or, to delete, click Delete.
