3.9.4 MetaData: BrtBeginECOlapProps

The BrtBeginECOlapProps (section 2.4.62) record specifies properties specific to OLAP external connections (section 2.2.8), as specified in the following table.

Size

Structure

Value

0006

BrtBeginECOlapProps - BrtBeginECOlapProps

1 bit

    BYTE - fLocalConn

0x0

1 bit

    BYTE - fNoRefreshCube

0x0

1 bit

    BYTE - fSrvFmtBack

0x1

1 bit

    BYTE - fSrvFmtFore

0x1

1 bit

    BYTE - fSrvFmtFlags

0x1

1 bit

    BYTE - fSrvFmtNum

0x1

1 bit

    BYTE - fUseOfficeLcid

0x1

1 bit

    BYTE - reserved1

0x0

0004

    DRw - nDrillthroughRows

0x000003E8

1 bit

    BYTE - bLoadConnLocal

0x0

7 bits

    BYTE - reserved2

0x00

Structure of BrtBeginECOlapProps

fLocalConn: 0x0 specifies that data is retrieved using the connection string specified by the stConn field of the BrtBeginECDbProps (section 2.4.61) record preceding this record.

fNoRefreshCube: 0x0 specifies that the local cube file is rebuilt from the original OLAP data source on refresh.

fSrvFmtBack: 0x1 specifies that the fill colors retrieved from the OLAP source are used for cell formatting.

fSrvFmtFore: 0x1 specifies that the font face color retrieved from the OLAP source is used for cell formatting.

fSrvFmtFlags: 0x1 specifies that the font family name retrieved from the OLAP source is used for cell formatting.

fSrvFmtNum: 0x1 specifies that the format string retrieved from the OLAP source is used for cell formatting.

fUseOfficeLcid: 0x1 specifies that the application sends a language code identifier (LCID) to the OLAP provider to retrieve localized data.

nDrillthroughRows: 0x000003E8 specifies that a maximum of 1000 rows are returned when the user drills through an aggregate value in a PivotTable (section 2.2.5).

bLoadConnLocal: 0x0 specifies that stConnLocal does not exist after the fixed-size portion of this record and therefore, no local cube is associated with this external connection.