How to convert mdx query to sql query automatically?

SSAS and SSRS
1

I want convert mdx query used to generate the cube report into sql query which can be used retrieve same report from database.please help.

2

post the query

3

SUM(PeriodsToDate([Time_Period].[Time_Period].[Year],[Time_Period].[Time_Period].CurrentMember),[Measures].[Rev_Act_USD])

4

Post title: How to convert mdx query to sql query automatically?

To the best of my knowledge, there is no way to do the conversion automatically.