Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
The following example uses Strategy Tutorial Project.
1. Open Strategy Web.
2. Create a new dossier and create a dataset:
a. Add data, click “New Data” and choose “Databases”.
b. Click “Select Tables” and choose data source “Tutorial Data” and table “CITY_MNTH_SLS”
c. Click “Finish” to save the dataset and choose “Connect Live” mode.
3. Create a new derived metric based on metric “Tot Cost”.
a. Right click on “Tot Cost” and choose “Create Metric…”.
b. Rename the metric as “Coalesce” and use the formula
Sum(Coalesce([Tot Cost], 0.0)){~+}
c. Validate the formula and save the metric.
4. Add attribute “Cust City Id” and metric “Coalesce” into the visualization, and click “Query Details…” in the visualization menu to check the query. In the query, the parameter in the Coalesce function is 0 instead of 0.0.
This is a known defect before Strategy 2020 caused by an inconsistent logic in Live Connect mode which automatically ignores the trailing zeros in parameters.
To resolve this defect, please upgrade to Strategy 2020 or above, and set Data Engine Version setting to 12.
The project level setting Data Engine Version can only be enabled through Workstation. For more details on enabling the setting, see Change Data Engine Version .
In Strategy 2020, Live Connect mode has correct logic for the Coalesce function, and will not remove the trailing zeros during SQL generation.
Strategy Internal Reference number for this technical note is KB483636 and DE101094.
