技術情報
dimension (OLAP Dimension)
ピボットテーブルのOLAP次元を定義します。
書式
<dimension (属性)... />

対象
xl/pivotCache/pivotCacheDefinition*.xml、xl/pivotTables/pivotTable*.xml など

属性
(Dimension Display Name)
次元の表示名を設定します。

(Measure)
測定次元かどうかを設定します。

1
測定次元です。

0
測定次元ではありません。

(Dimension Name)
次元名を設定します。

(Dimension Unique Name)
次元のユニーク名を設定します。


<dimensions count="22">
<dimension name="Account" uniqueName="[Account]" caption="Account"/>
<dimension name="Customer" uniqueName="[Customer]" caption="Customer"/>
<dimension name="Date" uniqueName="[Date]" caption="Date"/>
<dimension name="Delivery Date" uniqueName="[Delivery Date]" caption="Delivery Date"/>
<dimension name="Department" uniqueName="[Department]" caption="Department"/>
<dimension name="Destination Currency" uniqueName="[Destination Currency]" caption="Destination Currency"/>
<dimension name="Employee" uniqueName="[Employee]" caption="Employee"/>
<dimension name="Geography" uniqueName="[Geography]" caption="Geography"/>
<dimension name="Internet Sales Order Details" uniqueName="[Internet Sales Order Details]" caption="Internet Sales Order Details"/>
<dimension measure="1" name="Measures" uniqueName="[Measures]" caption="Measures"/>
<dimension name="Organization" uniqueName="[Organization]" caption="Organization"/>
<dimension name="Product" uniqueName="[Product]" caption="Product"/>
<dimension name="Promotion" uniqueName="[Promotion]" caption="Promotion"/>
<dimension name="Reseller" uniqueName="[Reseller]" caption="Reseller"/>
<dimension name="Reseller Sales Order Details" uniqueName="[Reseller Sales Order Details]" caption="Reseller Sales Order Details"/>
<dimension name="Sales Channel" uniqueName="[Sales Channel]" caption="Sales Channel"/>
<dimension name="Sales Reason" uniqueName="[Sales Reason]" caption="Sales Reason"/>
<dimension name="Sales Summary Order Details" uniqueName="[Sales Summary Order Details]" caption="Sales Summary Order Details"/>
<dimension name="Sales Territory" uniqueName="[Sales Territory]" caption="Sales Territory"/>
<dimension name="Scenario" uniqueName="[Scenario]" caption="Scenario"/>
<dimension name="Ship Date" uniqueName="[Ship Date]" caption="Ship Date"/>
<dimension name="Source Currency" uniqueName="[Source Currency]" caption="Source Currency"/>
</dimensions>