Tag Archives: SSRS

Reading an SSAS cube thru SQL using MDX

Do you need the ability to read a cube, but you want to read it thru SQL?  And, why would you do this?  Well, for example, suppose you wanted to email the results of a certain MDX query…and you didn’t … Continue reading

Posted in SQL Administration, SSAS | Tagged , , , | Leave a comment

SSRS Report History – keep more than 60 days

Many may know that the following query can get information about the history of reports being called. SELECT ss.UserName, ss.Format, ss.TimeStart, cat.Name, ss.Parameters, CONVERT(nvarchar(10), ss.TimeStart, 101) AS rundate FROM reportServer.dbo.ExecutionLog AS ss INNER JOIN Catalog AS cat ON ss.ReportID = … Continue reading

Posted in SSRS | Tagged | 1 Comment