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 want to set up SSRS to do this. (SSRS would be a fine method, but you do have to set it up and create the report etc.) Suppose you were simply more comfortable using a SQL Server Agent job to do this task for you. Continue reading “Reading an SSAS cube thru SQL using MDX”
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.
Continue reading “SSRS Report History – keep more than 60 days”