Analysis/Reporting XML Structures
This section describes the minimal Extensible Markup Language (XML) structure needed for creating a dynamic report.
For online analytical processing (OLAP) reports, the cube name must be supplied. For SQL reports, a query must be provided.
After the report is displayed, the layout can be dynamically modified and the results saved from Commerce Server Business Desk.
The XML structure should not be directly edited after the report is initially created. Make any modifications to the report using the pivot control available through Business Desk.
XML Structure
<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>ConnectionString</x:ConnectionString>
[<x:CommandText>QueryString</x:CommandText>]
[<x:DataMember>CubeName</x:DataMember>]
</x:PivotTable>
</xml>
The CommandText element is used only for SQL reports and contains the SQL query.
The DataMember element is used only for OLAP reports and contains the cube name.
The ConnectionString is one of the following types:
For SQL reports: "Provider=SQLOLEDB;Data Source=;Initial Catalog=;Integrated Security=SSPI"
For MDX reports: "Provider=MSOLAP;Data Source=;Initial Catalog=;Client Cache Size=25;Auto Synch Period=10000"
The values of the Data Source and Initial Catalog attributes are not specified in the connection string. These values are obtained from the Administration database at report run time.