"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.
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 ***
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.