Blog
Solver sorts amounts by row by dragging the Amount measure into the row grouping and setting the sort icon to ascending or descending.
Do you have multiple entities in Solver and create separate report templates because each entity has a different logo? If so, consider using the Excel IMAGE function to include an image in a cell from a https URL – eliminating the need for duplicate Solver templates. The formula renders correctly
I always found it challenging to build charts in Solver because they are built in Design mode and the charts are empty: I’d temporarily replace the Solver formulas with placeholder values, build the chart then put the Solver formulas back. This is a tedious process and takes care – especially
Reports and input templates often show different results depending on the date/time they are run because the underlying data changes as time passes. To minimize confusion, reports should always include a date/time stamp. When reports are run in Solver Cloud, the date/time is shown in Greenwich Mean Time (GMT). This
Solver Cloud Integrations support standard Excel If statement structure for simple logic. For example: IF([LOCATIONID]=”,’NONE’,[LOCATIONID]) is supported. However, for more complicated If statements, log into Solver Support and use syntax described in this support article. As mentioned in the article, Solver integrations do not support major or complex data transformations
Solver sorts amounts by row by dragging the Amount measure into the row grouping and setting the sort icon to ascending or descending.
Solver supports dimension hierarchies (i.e., dimension attributes and trees) on a single dimension. I have clients with hierarchies based on combinations of dimensions. When these hierarchies are important enough, I add the combinations as separate, additional dimension(s). This is simple when you have access to the sql server of the
Solver Cloud doesn’t include a discrete allocations module, but it is fully capable of performing a wide range of allocations. Solver Cloud can calculate and store allocations to a budget or forecast scenario OR calculate allocations for an actual scenario and prepare the output in an Excel journal entry format that can
Solver Cloud Integrations support standard Excel If statement structure for simple logic. For example: IF([LOCATIONID]=”,’NONE’,[LOCATIONID]) is supported. However, for more complicated If statements, log into Solver Support and use syntax described in this support article. As mentioned in the article, Solver integrations do not support major or complex data transformations
Do you have multiple entities in Solver and create separate report templates because each entity has a different logo? If so, consider using the Excel IMAGE function to include an image in a cell from a https URL – eliminating the need for duplicate Solver templates. The formula renders correctly
I always found it challenging to build charts in Solver because they are built in Design mode and the charts are empty: I’d temporarily replace the Solver formulas with placeholder values, build the chart then put the Solver formulas back. This is a tedious process and takes care – especially
Reports and input templates often show different results depending on the date/time they are run because the underlying data changes as time passes. To minimize confusion, reports should always include a date/time stamp. When reports are run in Solver Cloud, the date/time is shown in Greenwich Mean Time (GMT). This
Solver Cloud Integrations support standard Excel If statement structure for simple logic. For example: IF([LOCATIONID]=”,’NONE’,[LOCATIONID]) is supported. However, for more complicated If statements, log into Solver Support and use syntax described in this support article. As mentioned in the article, Solver integrations do not support major or complex data transformations
Solver supports dimension hierarchies (i.e., dimension attributes and trees) on a single dimension. I have clients with hierarchies based on combinations of dimensions. When these hierarchies are important enough, I add the combinations as separate, additional dimension(s). This is simple when you have access to the sql server of the
