[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

olapPr (OLAP Properties)

This element contains all the properties needed for an OLAP data connection. OLE DB for OLAP is the data provider, and OLAP connections contain both the dbPr and olapPr child elements.

[Example:

Data connectivity can use a number of different technologies. The following is an example of a connection to an SAP BW OLAP data source:

<connection id="1" odcFile="C:\My Documents\My Data Sources\$INFOCUBE.odc"
keepAlive="1" name="SAP demo cube" description="SAP DemoCube" type="5"
refreshedVersion="3" background="1">
<dbPr connection="Provider=MDrmSap.2;Data Source=BI2;User
ID=TESTUSER;Location=TESTSERVERNAME;Cache Authentication=False;Encrypt
Password=False;Integrated Security=&quot;&quot;;Mask Password=False;Persist
Encrypted=False;Persist Security Info=True;Impersonation
Level=Anonymous;Mode=Read;Protection Level=None;Extended
Properties=&quot;SFC_CLIENT=800;&quot;;Initial Catalog=$INFOCUBE"
command="$0D_DECU" commandType="1"/>

<olapPr sendLocale="1" rowDrillCount="1000" serverFill="0"
serverNumberFormat="0" serverFont="0" serverFontColor="0"/>
</connection>

end example]

[Example:

Data connectivity can use a number of different technologies. The following is an example of a connection to a Microsoft SQL Server Analysis Services OLAP data source:

<connection id="1"
odcFile="C:\My Documents\My Data Sources\Adventure Works DW.odc" keepAlive="1"
name="Adventure Works DW" type="5" refreshedVersion="3" background="1">
<dbPr connection="Provider=MSOLAP.3;Cache Authentication=False;Integrated
Security=SSPI;Persist Security Info=True;Initial Catalog=Adventure Works
DW;Data Source=DATASERVER1;Impersonation
Level=Impersonate;Mode=ReadWrite;Protection Level=Pkt Privacy;Auto Synch

Period=20000;Default Isolation Mode=0;Default MDX Visual Mode=0;MDX
Compatibility=1;MDX Unique Name Style=0;Non Empty
Threshold=0;SQLQueryMode=Calculated;Safety Options=2;Secured Cell
Value=0;SOURCE_DSN_SUFFIX=&quot;Prompt=CompleteRequired;Window
Handle=0x6A903CC;&quot;;SQL Compatibility=0;Compression Level=0;Real Time
Olap=False;Packet Size=4096" command="Adventure Works" commandType="1"/>
<olapPr sendLocale="1" rowDrillCount="1000"/>
</connection>

end example]

[Note: Data connectivity can use a number of different technologies. One example of potential values stored in this attribute can be found at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/dasdkoledboverview.asp end note]

Parent Elements

connection3.13.1)

 

Attributes

Description

local (Local Cube)

Flag indicating whether we should get data from the local cube on refresh versus the original data source. true if a local cube has been created for OLAP data, and it should be used instead of the server.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

localConnection (Local Cube Connection)

Specifies a connection string to use when a local cube is available. This is used when local is set to true.

 

[Example:

 

<olapPr local="true" localConnection="OLEDB;Provider=MSOLAP;Data Source=C:\Data\DataCube.cub" >

 

… end example]

 

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

localRefresh (Local Refresh)

Flag indicating whether we should refresh the local cube from the original data source. When true, the original OLAP data source is queried each time the user explicitly refreshes the data in the application, and a new local cube is constructed from this query.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

rowDrillCount (Drill Through Count)

Maximum number of drill-through rows to return when the user drills through an aggregate value in a PivotTable.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

sendLocale (Send Locale to OLAP)

When true, the spreadsheetML app should send the user interface locale ID to the OLAP provider to retrieve localized member names and properties, etc. When false, no locale ID is expected.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

serverFill (OLAP Fill Formatting)

When true a PivotTable based on an OLAP source should format the data and aggregate cells in the PivotTable view using the background color from the OLAP source if this information is available. When false, OLAP server background fill colors are ignored, and standard formatting rules within the worksheet are followed.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

serverFont (OLAP Server Font)

When true, a PivotTable based on OLAP source should format the data and aggregate cells in the PivotTable view using the font from the OLAP source (e.g., Arial or Tahoma). When false, OLAP server fonts are ignored, and standard formatting rules within the worksheet are followed.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

serverFontColor (OLAP Font Formatting)

When true a PivotTable based on OLAP source should format the data and aggregate cells in the PivotTable view using the font color from the OLAP source. When false, OLAP server font colors are ignored, and standard formatting rules within the worksheet are followed.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

serverNumberFormat (OLAP Number Format)

When true, a PivotTable based on OLAP source should format the data and aggregate cells in the PivotTable view using the number format from the OLAP source. When false, OLAP server number formats are ignored, and standard formatting rules within the worksheet are followed.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_OlapPr">

   <attribute name="local" use="optional" type="xsd:boolean" default="false"/>

   <attribute name="localConnection" use="optional" type="ST_Xstring"/>

   <attribute name="localRefresh" use="optional" type="xsd:boolean" default="true"/>

   <attribute name="sendLocale" use="optional" type="xsd:boolean" default="false"/>

   <attribute name="rowDrillCount" use="optional" type="xsd:unsignedInt"/>

   <attribute name="serverFill" use="optional" type="xsd:boolean" default="true"/>

   <attribute name="serverNumberFormat" use="optional" type="xsd:boolean" default="true"/>

   <attribute name="serverFont" use="optional" type="xsd:boolean" default="true"/>

   <attribute name="serverFontColor" use="optional" type="xsd:boolean" default="true"/>

</complexType>