Construct MDX query from pivotTable structures?

Nov 7, 2013 at 7:48 AM

I was wondering if it is possible to use the pivotTable structures in OpenXML to construct the MDX query that can be used refresh the data from a cube?

i.e. the pivotTable structure has rowFields and colFields that (I think) refer to the "ON ROWS" and "ON COLUMNS" part of MDX, also the pageFields structure could refer to the "WHERE" part of the MDX?

Does this make sense / has this been done already somewhere?

Best regards,

Jeroen Janssen