dbTalk Databases Forums  

"Fields" not populating in RS when using MDX against AS

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


Discuss "Fields" not populating in RS when using MDX against AS in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
asnewbie+rs=argh
 
Posts: n/a

Default "Fields" not populating in RS when using MDX against AS - 04-27-2005 , 05:27 PM






As per above, when run an MDX query in Reporting Services against my AS cube,
it is often not populating the "Fields" tab. The query runs correctly and
returns the dataset. Does anyone have any pointers on this. The first time,
I remove a "non empty" clause and it seemed to populate, but this isn't
working this time.

Thanks,


Reply With Quote
  #2  
Old   
Deepak Puri
 
Posts: n/a

Default Re: "Fields" not populating in RS when using MDX against AS - 04-27-2005 , 06:29 PM






Assuming that the MDX query returns results in the Data tab of the
Report Designer, have you pressed the "Refresh Fields" icon (2
clock-wise arrows) on the toolbar?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
  #3  
Old   
mdxwhip
 
Posts: n/a

Default Re: "Fields" not populating in RS when using MDX against AS - 04-28-2005 , 03:46 PM



Deepak,

This worked. Weird. Interestingly it also solved the problem I was
having with a parameter. I had updated my lookup for my parameter, run
the MDX query, then went to change the columns in the parameter
definition, but it had not refreshed. Issue the manual refreshed
updated the fieldnames that were available in the parameter UI.

Thanks,

Keehan


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.