Create the XML Framework
The following shows the XML framework required for the report. Note that values for the Data Source and Initial Catalog attributes are not specified in the connection string. These values are obtained from the Administration database at the time the report is run.
The name of the cube is specified between the DataMember tags.
For more information about the XML structure, see Analysis/Reporting XML Structures.
Step 1
XMLString =
'<xml xmlns:x=''urn:schemas-microsoft-com:office:excel''>
<x:PivotTable>
<x:OWCVersion>9.0.0.3821</x:OWCVersion>
<x:DisplayFieldList/>
<x:FieldListTop>300</x:FieldListTop>
<x:FieldListLeft>800</x:FieldListLeft>
<x:FieldListBottom>700</x:FieldListBottom>
<x:FieldListRight>1000</x:FieldListRight>
<x:CacheDetails/>
<x:ConnectionString>Provider=MSOLAP;Data Source=;Initial Catalog=;
Client Cache Size=25;Auto Synch Period=10000</x:ConnectionString>
<x:DataMember>CubeName</x:DataMember>
</x:PivotTable>
</xml>'