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

The following is the proposal from Symphony
Spreadsheet team. Thanks.

 

Best Regards,

Helen Yue

_________________________________________________________

Yue Zhi Yu  |  Manager
of User Experience & Applications, Lotus Symphony |  


(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: 

Address: 2/F, DeShi Building No.9, East Road, ShangDi, Haidian District,
 Beijing 100085, PRC