In this release Cosmos includes the following improvements:
- Added the ability to add hard-coded values for lookup joins in the data model
- Improved how Cosmos auto-fits columns when a report is run
Added the ability to add hard-coded values for lookup joins in the data model
There may be times where you need to add a hard-coded relationship to the lookup table. This will typically happen when there may be multiple records that are returned based on field-to-field relationships, and you need to add a hard-coded value to further narrow the lookup record set down.
In this release we added the ability to specify a hard-coded value as part of the join criteria in a lookup function, enabling users to easily apply these values when needed.
More details can be found in the article here: Using Hard-Coded Values in Relationships
Improved how Cosmos auto-fits columns when a report is run
We have improved how Cosmos auto-fits columns when reports are run. Previously, there were some cases where a column may not have been wide enough to show the values in the column, primarily if only Excel functions (such as SUM() ) were present in the column. This has been improved so that now the columns will size to automatically accommodate all values in the worksheet.