Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DAX query to figure out the latest hour that's loaded into Tabular cube for today (date dim & hour dim) Expand / Collapse
Posted Friday, February 28, 2014 2:26 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:35 PM
Points: 48, Visits: 238
Hi guys,

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?
Post #1546578
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse