How to compare 2 different cubes to show an alert?

Anastasia Vladimirova
Anastasia Vladimirova Employee
Level 300: Expanding Board in Your Organization First Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
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, Community Captain
    Fourth Anniversary 5 Answers 10 Comments Year 2 Community Captain
    Answer ✓

    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