We have a tabular cube set up, which has a date dimension and an hour dimension, along with a few others, and a simple count fact measure.
So for every day, the hour dimension would just be 00 to 23.
The cube is updated hourly, so as the hour completes, we will see new hour shows up for the day in the cube.
As a data quality check, I would like to write a dax query that basically returns the max(hour id) from hour dimension from the cube where date dimension = today's date.
From there, I am hoping to write a script which compares the max hour from the cube to the hour in real life, and sends an alert email out if the cube has been delayed for more than xxx hours, for example.
I haven't done much in DAX yet, so I am newbie. Can someone please help me in what to do with this?