I am working on a project and I am facing a weird problem. I have created an MDX using Analyzer. This MDX executes very fast. I am trying to automate its execution with %DeepSee.ResultSet and the query never returns:
Set tSC = oMDX.%PrepareMDX(tMDX)
Set tSC = oMDX.%Execute()
What could be causing %Execute() to take so long to run while Analyzer is responding fast?