Hi,
My scenario involves binding the XmlaDataSource directly to the XamDataChart.
I am trying to specify that the member values are to be used for the Rows:
xmlaDataSource.Rows = DataSourceBase.GenerateInitialItems("[Geography].[Country].members");
Although this is MDX syntax, it doesn't work in this scenario and results in a single undefined Tuple member returned in IResult.RowAxis. Could you help me identify the right syntax to use?
In general, I am struggling with finding documentation and samples for using XmlaDataSource with the charting controls. Mostly, everything is geared towards using the PivotGrid with XMLA data sources. Any pointers to useful documentation would also be appreciated.
Thanks,
Gary
I just wanted to follow up to see if anyone can help with this?
Hi Gary,
This section of the forum is mainly focused on general discussions related to DataVisualization. For the XamDataChart control specific questions, you can use this section of the forum.
Best regards,Milana Zhileva
Hi
You can identify the right syntax by using MS SQL Server Management Studio. Connect to the analysis server and browse the selected cube. Then expand desired hierarchy to find member you want. Then you can right click desire member and click Copy from context menu. Now you have to get the right member name.
Also you should call LoadShemaAsync() method in order to load data from server. This is done automatically by PivotGrid when data source is set, but if you use XmlaDataSource with DataChart you should call this method by yourself.
Regards
Todor