March 2025
Last updated
Last updated
We have made enhancement to the current OData Connection type. To set up a connection, go to Connections. Click Add and enter Connection ID and Description. Select Source Type as OData, enter URL similar to normal OData URL . Select authentication type as API Key from dropdown. Add key, enter key value to connect.
This option, lets you copy data from specific metric/field members to another metric/formula.. You can only copy to a metric with the same data type. If multiple members are selected and the output member is different from the source, the data will be aggregated and copied. By default, only Scenario, Time-type fields, and Metrics are shown. Use Update List to add more fields.
This option lets you clear data based on the selected data region. You can clear multiple metrics in the same sheet at once using the option.
Lets you move data from specific metric/field members to another metric/formula. Here again, you can only move data to a metric with the same data type. If multiple members are selected and the output member is different from the source, the data will be aggregated and moved. You can add fields using the Update List option.
Dependents : Lists all metrics where the current metric is used, this including metrics used as an input metric, inside the Add parameters of another input metric, inside the Add - Alias parameters of another input metric and as a Journal Header Metric (only Status/List type), used as a Filter in another input metric from Journal.
Precedents : Lists all metrics that are used in the formula of the current metric. Only Formula, Parent, Summary, or Linked metrics can have Precedents.
Users can view details like sheet, metric name, data type, formula, and related field. They can also open any dependent metric in a new browser tab.
Note : When a user tries to delete a metric, property, or currency conversion rule, or change a property type, the system will automatically check all dependencies. If any are found, the action will not be allowed.
Learn more about here.
This update enables Standard Data Actions at the Sheet level, including: Copy Data, Clear Data, Move Data. To perform any of these actions on a sheet, click the ellipsis icon on the Level 2 header. From the popup, chose the action, update member selection and Run action to complete.
Learn more about here.
On opening any metric side panel, a new button called Trace will appear in the top-right corner of Metric Details. Clicking this button opens a popup with two reports:
Users can view information such as the dependent/precedent sheet, metric name, data type, formula, and fields. There’s also an option to Open metric details in a new tab for easier access to those metrics.
Learn more about here.
A new Field Details button is available on the Field screen in level 2 header . Clicking this allows users to see a table of properties under the selected field with details about each as : Property name, Property Description, Property Type, Link to, Property Members and Where Used
Similar to metrics, when users view any existing property in a field, they can click the Trace button to see a list of dependent metrics where the property is used. This includes, inside the Set function of a formula metric, as a cell reference in a metric formula, inside the Add function of a formula metric.
Learn more about here.
In sheet Currency Conversion Rule, go to rule Schema on level 2 header. User will be able to see list of Sheet and Action that is using the Currency Conversion rule under the Where Used section as SheetName.Action. Clicking on will open the sheet in new tab.
