Running MDX Query to SSAS

[dbahiker]

I have a report using Framework metadata with SSAS cube attached. But I would like to have a new second Query with custom handwritten MDX that would get the last timestamp the cube was ran.
I have this MDX and it works in SSMS but I can't get it to work in Cognos MDX object. I have set the Data Source as what I have in Framework and I set the catalog as cube name.

-- To get the last date of Cube processing
SELECT CUBE_NAME, LAST_DATA_UPDATE FROM $System.MDSCHEMA_CUBES
where CUBE_NAME = 'cubename'

[dbahiker]

Screenshot from cognos

[Lynn]

Can you use a layout calculation with the report function to get this information? I don't know if it only works with PowerCubes but thought I'd mention it in case.

CubeDataUpdatedOn ( dimension )

Returns the date time that data in the cube was last updated. "Dimension" specifies from which cube to retrieve the metadata.

[dbahiker]

Yep that works on a SSAS Cube too. Thanks!