dbTalk Databases Forums  

OpenQuery fails on Calculated Measures

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss OpenQuery fails on Calculated Measures in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Simon Lenn
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.