How to compare 2 different cubes to show an alert?

Options
Anastasia Vladimirova
Anastasia Vladimirova Employee
Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights Photogenic First Comment
in Platform

Hi Community!

I am working on figuring out a way to compare two different data entry cubes to show alerts. The goal is to have one DE cube to match the sum of by Month DE cube values, and if the sums don't match the alert or notification will appear. Are there any ideas on how would be best to approach this?

Tagged:

Accepted Answer

  • Bart Scott
    Bart Scott Active Partner
    Photogenic Community Captain First Anniversary Advocate
    Answer ✓
    Options

    You can create a screen and do one as Block A, one as Block B, add row comparison entity as needed, add a variance column and an alert color on that variance column. Can be done on a dashboard or a check report on the menu. Or if you have Broadcasting license, you can check in a procedure and email out the alert when certain conditions are met. Lots of different possibilities to automate this.

    Bart Scott
    CFO Solutions LLC

Answers

Categories