When creating a KPI, a standard MDX will be generated for its operation, containing the necessary query for the KPI’s operation, according to the options selected during creation. BIMachine allows the option to customize the MDX created, so you can create a customized query, that is, customize or adapt it according to suggested requirements.
Observation: when changing your default MDX, you will no longer be allowed to select a measure as a goal value, as this can cause errors in the KPI.
Enabling editing for customization:
Notification after enabling custom MDX editing:
