Release Notes

What's new? New "Replicated Measure" object type, meant to be a long-term replacement for the "Replicate as Object" panel in measures and the "Measure Object" object types that they manage. With Replicated Measure objects, the link between objec...

What improvements have been made to existing features? Redefined the meaning of "Prevent Duplicate Import" in the context of range imports. If this option is selected in the context of a range import, any filename that has already been imported ...

What's new? Allow AWS Snowflake deployments to set "multifile export mode" in the global variables screen. This mode will allow the export of 5GB+ files from Snowflake while also stitching together the exported chunks into a single file. This st...

What's new? Support bulk-upload of terms via spreadsheet copy-paste. REPLACE CHARACTERS pattern, which performs a regex-unaware replacement of all instances of a search string with a designated replace string from within a text field. What...

What's new? Users can collapse board titles in view mode, and can collapse both board tabs and board titles in edit mode. Collapsed tabs or titles will hide all the tiles beneath them, up until the next tab or title. When collapsed in edit mode,...

What's new? Support optional "preprocessing script" in import objects. Users can select a preprocessing script from a dropdown that includes some built-in scripts, such as for a Claims Reduction File (CRF), along with any of the bespoke models t...

What's new? Users with SQL visibility privileges will be able to see a SQL diff representation of object edits from the Revision History panel. Users can open a new tab showing the diffs by clicking an icon-button alongside the edit. The icon-bu...

What's new? Allow cloning of tiles on boards in Analytics Portal. Allow for the customization of filename and delimiter for object exports, via the global variables screen. The filename template will take the form {{tableName:uppercase}}_{{ex...

What's new? Support "Upstream Validation Objects" to be identified on the Validation panel in Object Workshop. If any objects in this list are included in the same ELT as the relevant object, it will not start until all such upstream validation ...

What improvements have been made to existing features? Allow users to hide columns of the measure explorer data table. This configuration will be honored when pinned to a board. Allow users to select a measure expression when adding a comparis...

What's new? Expire all sessions associated with an account when its password is reset, as a security best practice. What improvements have been made to existing features? Support incremental load on integrator objects.

What's new? Added Developer Notes textarea to measures and objects. What improvements have been made to existing features? And/then clauses of CASE WHEN patterns will be reordered as blocks, so that all the "ands" move together with thei...

What's new? ROUND NUMBER pattern, which rounds a number to a specified number of decimal places. What improvements have been made to existing features? Allow the sorting of pivot table leaf nodes. Added a mechanism to re-order splits. ...

What's new? Added report staleness threshold configuration. This optional field represents the maximum report age in days before a staleness alert is shown in Analytics Portal. For example, if you expect the report to be refreshed nightly, setti...

What's new? Users in AWS deployments can create SageMaker autopilot models in the advanced analytics zone of Ursa Studio. To create an autopilot model, users pick an existing object for training and validation. They also select the relevant inde...

What's new? Added a "full-screen data table" option for bar chart and dot charts in measure explorer. If the data table is in full-screen mode and there are more than one split, the data table will act like a pivot table, with collapsible subtot...

What's new? Support filtering by case percentile in analytics portal. This filter operates in a similar manner to the case value filter, but takes a value between 0 and 100, which represents the percentile of the case value within the scope of t...

What's new? Add category filter to value sets and lookup tables screens. What improvements have been made to existing features? Guard against illegal quick filters in reports. Support upload of lookup table from spreadsheet as currentl...

What improvements have been made to existing features? Support IS IN VALUE SET and LOOKUP TABLE VALUE patterns for ad hoc derived fields. Allow board filtering on non-analytic fields. Allow users to re-run individual measure instances on mul...

What's new? Allow users to copy boards to different reports, via a "Copy to Clipboard" iconbutton alongside the "Clone" iconbutton. When a board is in the clipboard, a button will appear in the leftbar allowing users to paste the board. Users ca...

What's new? Added choropleth chart type to measure explorer. This chart type requires the latest ZIP Code Reference object from the Ursa Core Data Model. What improvements have been made to existing features? Show SQL alongside the error...

What improvements have been made to existing features? Show summary row in measure explorer data table. Allow users to expand the report status bars in the "ELT Progress" panel the same way they can to the object status bars. What's been f...

What's new? Support cross-database registered tables in Snowflake. What improvements have been made to existing features? Added validation option for "has decreased since the last ELT". Added ELT validation and error details in a toolt...

What's new? Support for bespoke patterns, which allow users to define novel derived fields and restrictions. Added an optional numeric-image CAPTCHA to the reset-password flow on an opt-in basis via the USE_CAPTCHA_TO_RESET_PASSWORD environmen...

What's new? Support for Databricks. Added an optional numeric-image CAPTCHA to the reset-password flow on an opt-in basis via the USE_CAPTCHA_TO_RESET_PASSWORD environment variable.

What's new? Added Published Fields panel to integrator objects. What improvements have been made to existing features? Allow Intermediate Derived Fields of Semantic Mapping Objects to be published directly, without the need to map them i...

What improvements have been made to existing features? Added a guard to prevent a board to be saved with the same name as an existing board. Overhaul of screens for value sets, lookup tables, provider affiliations, and patient affiliations. Th...

What's new? Added flag options to report manager category filter. What improvements have been made to existing features? Boolean environment variables will be interpreted to be false if their value is "false". Previously, any value set f...

What improvements have been made to existing features? Added "Day of the Week Integer" and "Day of the Week Sortable Text" to PART OF DATE pattern. Allow the ability to re-order public boards on the Analytics Portal leftbar via the board confi...

What's New? Added full support of recovery from revision history for boards in Analytics Portal. The revision history table for boards now works the same way as it does for all other assets. What improvements have been made to existing featu...

What's new? Created URSA-USAGE module, to help customers track on their own Ursa Studio usage metrics. KEEP INTERVAL IF OVERLAPPING and IS OVERLAPPING INTERVAL patterns. Added a category filter to the User Manager dashboard. Added utility ...

What's new? Implemented validation for import objects and registered table objects, including a new default validation rule for import objects to throw a warning if the column structure of an import object has changed. Show module submission comm...

What's new? Added an "Investigate ELT" icon button in the ELT preview panel to look for possible hygiene concerns among the objects in the ELT. Added the environment variable SSO_LOGOUT_REDIRECT_URL to enable SSO-wide logout upon Ursa Studio sess...

What's new? Added Source field to registered table objects, to match import objects. Added DEFAULT_VARCHAR_LENGTH environment variable, primary for Redshift and MSSQL-family databases, to allow an implementation-override of the default varchar le...

What's new? Added a help drawer, which is activated via the help icon in the Ursa Studio topbar. From the help drawer, users can search the knowledge base for information, or follow context-sensitive links to recommended knowledge base pages. Use...

What's new? SWITCH pattern, which generates a value based on the evaluation of an ordered sequence of possible values against the same field, each with its own result. Added an optional REDSHIFT_IMPORT_MAXERROR_PARAMETER environment variable, whi...

What's new? CONVERT TEXT DURATION TO FLOAT pattern. This pattern casts a text field representing a time duration into a possibly-fractional number of seconds/minutes/etc. What improvements have we made to existing features? Ad-hoc derived fiel...

What's new? APPLY REPORT-DESIGNATED RESTRICTION pattern. This pattern can only be used in measures. Any report containing measures that use this restriction will have the option to supply per-report string values for each "prompt key" identified b...

What's new? Download Technical Documentation option from data model screen now supports a CSV version along with the txt version. Added Deep Search lens to Data Model screen. Added Value Set Use and Lookup Table Use lenses for the data model scr...

What's new? EXTRACT VALUE FROM JSON pattern. Added three more Data End Date Management options in the Global Variables screen, to facilitate automated management of the global data end date. Use current date, which will use the day of the report...

What's new? Ursa Reference object type, which loads Ursa-curated reference data sets into the environment. These objects will typically be managed by Ursa Health, because they must link with Ursa Health Standard Reference files, which are kept in ...

What's new? Support "Download Technical Documentation" for objects as for measures. Add "Download Technical Documentation" to the data model hamburger menu, allowing users to download summary technical documentation for all the objects currently ...

What's new? The URSA_MEASURE_SCHEMA environment variable has been folded into the URSA_SCHEMA environment variable and is no longer necessary for deployments. Ursa Studio administrators will be able set a user's hidden namespaces, which repres...

What's new? "Module History" tab in the integration manager, showing the status of the last 50 module imports or submissions. "File Preview" button for import objects within Azure and AWS environments. Clicking this button will let users see t...

What's new? For deployments with PHI downloading enabled, admins can authorize users on a user-by-user basis to download PHI by means of a "Allow PHI Download" checkbox in the user screen. Any changes to this checkbox will be noted in the privil...

What's new? Object Backup panel. Users can choose to have an object maintain a backup of its most-recently ELTed state. Backups can only be maintained on tables, not on views. Only one backup at a time is allowed, but users can elect to "pause" ...

What's new? Drilldown will be available directly from reports, measures, and objects into the data model screen, with focus on the asset in question, via the zone navbar. Module import will keep track of changes to both the module definition o...

What's new? Deployments within AWS now default to using AWS SES for transactional email. To enable this feature it is necessary to add the environment variable AWS_REGION whose value would take the format us-east-1, for example. SES needs to be ...

What's new? Derived Field versions of EQUALITY FILTER and INEQUALITY FILTER patterns. What improvements have we made to existing features? The split editor in Analytics Portal will include a default-checked "Analytic Fields Only" checkbo...

What's new? The Case Review "Choose Fields" screen has been expanded into a "Data Dictionary" screen, in which users can see term definitions, aggregate statistics, and similar measure metadata in one place. All the same hiding/pinning controls ...

What's new? The validation panel in Object Workshop has been expanded to handle general-purpose and fully-customizable validation rules. The rules are run in ELT post-processing, and can be run on any field in the object. Validation rule...

What's new? The Reference Data Review screen is now fully customizable. Objects can be inducted into Reference Data Review via the "Reference Data Configuration" panel in Object Workshop. Reference data will continue to autocomplete the value se...