MDX functions based on time

A bit of MDX to start the week, it feels good?

As you have already seen in the title, the purpose of this article is to share with you some time-based MDX functions that are very useful.

Time is an essential component for business analysis. Analysts interpret the state of the business now, often compared to what it was in the past, in order to understand what it might be in the future.

To support this, Analysis Services provides a number of time-based MDX functions, here are some of them:

Read More MDX functions based on time

Run an SSRS subscription with SSIS

A quick post to see how to launch an SSRS subscription from SSIS.

It can serve as in my case for example to email a report on the execution status of an SSIS package. Of course after inserting the logs of this package in a table, create a report of return of these logs and a subscription that sends the report by mail.

So how?

Read More Run an SSRS subscription with SSIS