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”
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”