OpenQuery fails on Calculated Measures -
06-13-2004
, 07:54 PM
I am several calculated measures in my Cube. I built a OpenQuery
against the cube and it works fine as long I am not accessing any
calculated measures in it the moment I introduce a calculated measure
in the cube into the OpenQuery the OpenQuery fails with Syntax errors.
Appears the OpenQuery cannot access calculated measures. Please
clarify how I can overcome this limitation. I intend to use the
OpenQuery output from a Reporting Services query. This is a serious
limitation as RS wants a MDX flattened output and OpenQuery fails
against calculated measures.
Thanks
Simon |