June 2024
Input Snippets and Report Snippets
We have introduced a third standard snippet option in sheets, expanding the previous two options to include:
Standard Input Snippet (shown by Sheet Name): Used for inputting and uploading data directly into the sheet.
Standard Data Snippet (shown by Sheet Name + "Data"): Used for reviewing the raw data contained in the sheet/model.
Standard History Snippet (shown by Sheet Name + "History"): Used for reviewing the audit history of data changes.
Previously, users could not create an Input snippet for a sheet. With this update, the Create Snippets option now allows adding an Input snippet for any sheet, enhancing flexibility in data management.
Learn more about Snippet Types in the snippets section.
Metric Datatype Date now supports operations
The date datatype for metrics in sheets now supports operations such as:
Adding or subtracting days to get a new date (
Date +/- Number = Date).
Subtracting one date from another to find the number of days between them (
Date - Date = Number).
Comparing two dates to determine if one is greater, less, or equal to the other.
These capabilities are useful for sorting, filtering, and setting conditions based on dates.
Remote Tables and Dataflow Updates
-
New Connection Type: NetSuite
User can now add NetSuite as new Connection under Connections Setup. User can add a Metric as Input or Output to any of the dataflow similar to the other dataflow connection. For this, user can select Metric from the Sheet section in Dataflow Object List when creating dataflow. Metric here will be similar to MEASURE in model.
-
Enhancements to Remote Tables
User can now created table based on Define SQL Query. When adding new remote table in Table set, the source can be defined as Query instead of Table or View. After select Query, user can enter the query in Popup along with Table Name and Table Description, User can also add Parameter to use as Filter condition for loading rules.
Learn more about Remote Tables and Dataflow in the Process Definition section.