Fw: Proposal: Add multiple cell ranges support to Data Pilot

[Zhi Yu Yue <yuezhiyu@cn.ibm.com>]

The following is the proposal from Symphony
Spreadsheet team. Thanks.
 
Best Regards,
Helen Yue
_________________________________________________________
Yue Zhi Yu  |  Manager
of User Experience & Applications, Lotus Symphony |

 yuezhiyu@cn.ibm.com

(8610)82452783 (phone) | 90-52783 (tie-line) | IBM China Development Laboratory


----- Forwarded by Zhi
Yu Yue/China/IBM on 07/03/2008 03:37 PM -----

From:	Su Ying Rui/China/IBM
To:	Zhi Yu Yue/China/IBM@IBMCN
Cc:	Xu Ming Wang/China/IBM@IBMCN, Yue MA/China/IBM@IBMCN, Ming Fei Jia/China/IBM@IBMCN
Date:	07/03/2008 03:12 PM
Subject:	Proposal: Add multiple cell ranges support to Data Pilot

---

Data pilot is one useful way to analyze
and evaluate data. In current ODF specification (v1.2 draft 7), the source
of the data pilot table can be a cell range located within the same document.
However, multiple cell ranges as data source are required in many cases.
The following proposal below is aimed to add the multiple cell ranges support
as data source of data pilot. In this case, the data pilot function will
combine the multiple cell ranges as the source into one data pilot table.
The following is the proposal:

8.9 <table:data-pilot-tables>

8.9.1.1 Data Pilot Table Source

The source of the data pilot table is
either stored in a database, that is, a database table itself, a SQL query
or a named query, or it is a list of cell ranges located within the same
document. It can also be provided by an external component in an implementation
dependent way.
The source of the data pilot table is
specified by one of the following elements that are contained in the <table:data-pilot-table>
element:

• <table:database-source-sql>. See .
• <table:database-source-table>. See.
• <table:database-source-query>. See .
• <table:source-cell-range>. See .
• <table:source-cell-ranges> See 8.9.3.
• <table:source-service>. See .

8.9.2 <table:source-cell-range>
...

8.9.3 <table:source-cell-ranges>

If the source of a data pilot
table is a list of cell ranges, the <table:source-cell-ranges> element
contains information about the cell ranges and how the data pilot table
gets the data from the ranges. Before the source data is processed by the
data pilot data, a filter may be applied to it. This filter has to be specified
by a <table:filter> child element.

<define name="table-source-cell-ranges">
       
<element name="table:source-cell-ranges">
       
        <ref name="table-source-cell-ranges-attlist"/>
       
        <optional>
       
               
<ref name="table-filter"/>
       
        </optional>
       
</element>
</define>

8.9.4 <table:source-service>

Best Regards

Rui SuYing£¨ÜÇËÕÓ¢£©
User Experience & Applications,
IBM Lotus Symphony,
IBM China Software Development LAB, Beijing

http://www.ibm.com/software/lotus/symphony/

Tel: 86-10-82452814  
Internet E-mail: ruisuy@cn.ibm.com
Address: 2/F, DeShi Building No.9, East Road, ShangDi, Haidian District,  Beijing 100085, PRC