Hi,
I am working in share point website.
I am having 2 questions.

1. There i am having a pivot atble web part. specified datasource and
the MDX query.
When I say save and close. My system stays for a long time and after
that says "Not responding".

but i am able to run the same query in spreadsheet web part and i am
getting the answer for it.

how can i run the MDX query in pivot table webpart?

2. I run a MDX query in spreadsheet and data is there.
I used an another webpart(Chart control) to display the chart view of
the data present in the spreadsheet. I know how to set the series and
all for the cahrt control.

The problem comes in the data of the spreadsheet.

My data looks like

A B C D
------------------------

2005 aaa 1 2
2005 bbb 2 4
2006 aaa 5 6
2004 bbb 7 7

here u can see my data is repeating.
Assume this as my data.
i) I need the column A to come as X-axis.(Since the data is repeating
here. It comes as repeated value in the chart as 2005,2005,2006,2004. It
doent able to recognize this as 2004,2005,2006)

ii) Column B as my series data.(aaa as one series and bbb as another
series.. here also repeating data).

iii) The other is data range. When i specify the data range i can only
say Sheet1!$A$3:$A$7.
but my data range may vary depends on the current data in my server.

iv) I need to select the series from the spreadsheet.For eg, if i
filtered only "aaa " series. I have to draw chart for the current values
in the spreadsheet. How can i specify this in the chart control in the
data range.


plz help me in this.. it is required urgently.



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