How to compare 2 different cubes to show an alert?

Anastasia Vladimirova · 2023-10-25T19:44:46+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Data Modeling

Cube

Planning

Accepted answers

Bart Scott

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

All comments

Bart Scott

Bart Scott
CFO Solutions LLC

Anastasia Vladimirova

Thank you Bart! I appreciate your response!

Regards,

Anastasia