Re: [office] Fw: Proposal: Add multiple cell ranges support to Data Pilot

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

Sorry that I lost track of this thread...I
have updated the form here per the instructions. Thanks.

http://wiki.oasis-open.org/office/Add_multiple_cell_ranges_support_to_Data_Pilot?highlight=%28CategoryNewProposal%5Cb%29%7C%28CategoryCategory%5Cb%29%7C%28ProposalTemplate%5Cb%29
 
Best Regards,
Helen Yue
_________________________________________________________
Yue Zhi Yu  |  Manager
of User Experience & Applications, Lotus Symphony |

 yuezhiyu@cn.ibm.com

From:	robert_weir@us.ibm.com
To:	Zhi Yu Yue/China/IBM@IBMCN
Cc:	office@lists.oasis-open.org
Date:	07/03/2008 10:49 PM
Subject:	Re: [office] Fw: Proposal: Add multiple cell ranges support to Data Pilot

---

Hi Helen, 

Would it be possible for you to enter this in the New Proposal Form format
on the Wiki? 

See step 2 described here:  http://wiki.oasis-open.org/office/How_to_propose_a_change_or_addition_to_ODF

-Rob

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

07/03/2008 03:57 AM

To	office@lists.oasis-open.org
cc
Subject	[office] 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 |

 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