Search code examples
c#.netssrs-2008semantics

Is there any API that allows us to convert Semantic query to SQL query?

Is there any API that allows us to convert Semantic query to SQL query? I need to extract the semantic query from RDL file and convert into SQL query.

Solution

  • Don't know really know if there is any way to achiev this, and never met anny implementation of stuff like that. But like link says, there should be a log of Reporting Service, that shows actual SQL query.

    Fetch SQL query from RDL

    Hope this helps.