Goal:
Display the value of the latest date and time of the cube's process in SSRS
Problem:
Based on the code below, I can retrieve the data in SQL server mgnt studio but when I'm inside of the Query Designer in SSRS I cannot retrieve the data based on the same sourcecode.
Source code:
SELECT * FROM $system.mdschema_cubes
WHERE CUBE_NAME = 'aaaaaa'