7/7/12

How to execute MDX query in PivotGrid Designer

PivotGrid Designer allow execute MDX query and browse result in PivotGrid.

To execute your MDX query select MDX tab and push Clear button.



Type MDX query and push Execute button or press F5.


The PivotGrid tab will open and you will see query result in PivotGrid.

If errors occur the Response Errors tab will open and errors will be listed there. You can locate error position in MDX by clicking Location link or double click error row.


In case of error you can return to last successful result. Select PivotGrid tab and press Return To Last Successful Result button. Your query text and PivotGrid appearance will return to state when command execution was successful.

1 comment: