oalp cube update with IIf in DMX

Asked Oct 27 '14 at 06:49

Active Oct 27 '14 at 20:18

Viewed 77 times

I need MDX query that will return 1\0 if the cube is up to date. Something like: case when LAST_DATA_UPDATE > now() then 1 else 0 end

I have the script that returns currently the 2 arguments but I cannot put them in an IIF statement?

Any help would be highly appreciated.

SELECT
CUBE_NAME,
 LAST_DATA_UPDATE
 --,now() as now_time
 FROM
$System.MDSCHEMA_CUBES
where cube_source=1

edited Oct 27 '14 at 20:18

whytheq

asked Oct 27 '14 at 06:49

Yoni

Why do you want it to be MDX? A simple SSIS package will do the work for you. – SouravA Oct 27 '14 at 15:43
BTW, will this suffice? `SELECT 'Not Processed' as CubeStatus FROM $System.MDSCHEMA_CUBES where LAST_DATA_UPDATE < now() and cube_source = 1` – SouravA Oct 27 '14 at 15:51
@yoni - your script is `sql` but you have tagged this question `mdx`? – whytheq Oct 27 '14 at 20:19
Hi Sourav,the last script helped me - thank you! – Yoni Oct 28 '14 at 09:16
what if the script returns NULL? can i replace it to 0? – Yoni Oct 30 '14 at 08:28

0 Answers0