0

I tried with an MDX query to know the user name who processed the cube.

SELECT LAST_DATA_UPDATE FROM $system.mdschema_cubes

But this will not work. Is there a way to know the user name who processed an SSAS tabular cube

Nick.Mc
  • 18,304
  • 6
  • 61
  • 91
bipro
  • 23
  • 7
  • In what way does it "not work"? returns an error? returns incorrect values? In what tools are you running this query? – Nick.Mc Mar 23 '17 at 04:09

1 Answers1

0

I don't believe that the user who processed the cube is saved or recorded in any DMV.

Instead you will need to log trace events using one of the options outlined here. This trace should run on the SSAS server on an ongoing basis. Later when you want to know who processed it you could scan back through the logs to determine who initiated the processing command.

Community
  • 1
  • 1
GregGalloway
  • 11,355
  • 3
  • 16
  • 47