Improving Performance by Adjusting a Metric

1. Example: You notice that a certain metric is causing slow queries. After analyzing it, you realize it’s overly complex or includes unnecessary transformations. You decide to rewrite it in a more optimized way within the semantic layer to improve performance while keeping the results intact.
2. Steps to solve:
  1. Go to the relevant metric
  2. Click "Modify" → "Edit base query SQL"
  3. Optimize the base query SQL to improve performance and simplicity
  4. Save your changes
  5. Once all changes have been made, click "Submit changes". Jedify will notify you when the new entity is ready for review.
  6. Review the new metric: Make sure that the change was successfully implemented, and that all related attributes and dimensions have been updated correspondingly. Then, approve or decline changes.
  7. Verify the new metric: Ask Jedify questions about the edited metric to make sure it successfully uses the new SQL syntax and logic.
  8. Ready to go live? Click ‘Verify’ to publish.