I am currently using the below query to know my last cube refresh time,
My cube refesh time is not fixed , I am trying to create a report which shows a status of cube availability i.e status should show red when cube is not available and when cube returns some value then it's green . How do I do that.
SELECT Cube_Name, Last_Data_Update
View Complete Post