Overview

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.