Currently, the PivotDataSource can work with only cube/perspective. If you would like to take control over the serialized MDX query, you can access it in the parameterMap callback. There you can modify the generated request and retrieve the correct data. Please refer to this how-to demo
for more details.
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI