专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08473837B2 Method for expanding and collapsing data cells in a spreadsheet report 有权
标题翻译：在电子表格报告中展开和折叠数据单元格的方法
公开(公告)号：US08473837B2
公开(公告)日：2013-06-25
申请号：US12843745
申请日：2010-07-26
申请人： Lakshmi N. Thanu , Peter Eberhardy , Dylan Hai Huang , Xiaohong Mark Yang
发明人： Lakshmi N. Thanu , Peter Eberhardy , Dylan Hai Huang , Xiaohong Mark Yang
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F17/212 , G06F17/24 , G06F17/245
摘要： Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross-join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.
摘要翻译：电子表格报表中的数据单元格已折叠并展开，而不会中断其他电子表格数据。用户可能希望深入了解与报告的父成员相对应的数据，以显示有关父成员的更多详细信息。类似地，用户可能想要钻取与父成员相对应的显示信息以隐藏与父成员相关联的详细信息。在展开或折叠报表之前，扫描电子表格以获取信息，以确定电子表格中其他数据的显示是否会被扩展/崩溃中断。信息可以包括与父成员相关联的交叉加入信息，与父成员关联的子成员的数量，由父成员和相关联的子成员创建的报告的维度以及可以链接到父成员的其他报告包括父成员的报告。

2. 发明申请

US20080221958A1 Techniques to manage information for dynamic reports using time periods for a business model 有权
标题翻译：使用业务模型的时间段管理动态报告信息的技术
公开(公告)号：US20080221958A1
公开(公告)日：2008-09-11
申请号：US11714975
申请日：2007-03-07
申请人： Patrick Baumgartner , Alisson Sol , Peter Eberhardy , Luming Wang , Mark Yang , Amer Shahnawaz
发明人： Patrick Baumgartner , Alisson Sol , Peter Eberhardy , Luming Wang , Mark Yang , Amer Shahnawaz
IPC分类号： G06F9/46
CPC分类号： G06Q10/00 , G06Q10/0631
摘要： Techniques to manage information for dynamic reports are described. An apparatus may comprise a business planning application module to update a current period reference to a time member of a time dimension, generate a rolling data entry form with actual data members and forecast data members based on the current period reference, and set a data locking mode for the actual data members and a data access mode for the forecast data members. Other embodiments are described and claimed.
摘要翻译：描述了管理动态报告信息的技术。设备可以包括业务规划应用模块，用于更新当前时间段对时间维度的时间成员的参考，基于当前周期参考生成具有实际数据成员和预测数据成员的滚动数据输入表，并且设置数据锁定实际数据成员的模式和预测数据成员的数据访问模式。描述和要求保护其他实施例。

3. 发明授权

US08239248B2 Techniques to manage information for dynamic reports using time periods for a business model 有权
标题翻译：使用业务模型的时间段管理动态报告信息的技术
公开(公告)号：US08239248B2
公开(公告)日：2012-08-07
申请号：US11714975
申请日：2007-03-07
申请人： Patrick Baumgartner , Alisson Sol , Peter Eberhardy , Luming Wang , Mark Yang , Amer Shahnawaz
发明人： Patrick Baumgartner , Alisson Sol , Peter Eberhardy , Luming Wang , Mark Yang , Amer Shahnawaz
IPC分类号： G06Q40/00
CPC分类号： G06Q10/00 , G06Q10/0631
摘要： Techniques to manage information for dynamic reports are described. An apparatus may comprise a business planning application module to update a current period reference to a time member of a time dimension, generate a rolling data entry form with actual data members and forecast data members based on the current period reference, and set a data locking mode for the actual data members and a data access mode for the forecast data members. Other embodiments are described and claimed.
摘要翻译：描述了管理动态报告信息的技术。设备可以包括业务规划应用模块，用于更新当前时间段对时间维度的时间成员的参考，基于当前周期参考生成具有实际数据成员和预测数据成员的滚动数据输入表，并且设置数据锁定实际数据成员的模式和预测数据成员的数据访问模式。描述和要求保护其他实施例。

4. 发明授权

US08204853B2 Maintaining client data integrity in a distributed environment using asynchronous data submission 有权
标题翻译：使用异步数据提交在分布式环境中维护客户端数据完整性
公开(公告)号：US08204853B2
公开(公告)日：2012-06-19
申请号：US12272684
申请日：2008-11-17
申请人： Jin Wang , Luming Wang , Malik Hussain , Zaiwei Du , Zhenyu Tang , Patrick J. Baumgartner , Mark Xiaohong Yang , Peter Eberhardy
发明人： Jin Wang , Luming Wang , Malik Hussain , Zaiwei Du , Zhenyu Tang , Patrick J. Baumgartner , Mark Xiaohong Yang , Peter Eberhardy
IPC分类号： G06F17/30
CPC分类号： G06F17/30578
摘要： Data processing architecture where submitters can write data and/or metadata changes to a destination through an asynchronous interface. The architecture includes a ticketing system that issues a ticket (a unique identifier) to the submitter in response to receiving a changelist from the submitter. When the changes are successfully completed at the destination, the cached destination data can be re-downloaded to the submitter, and the changes cached in the submitter, discarded. Absent this capability, a user has to manually manage the cached changes and cached data. The architecture can be distributed in that multiple submitters can submit changelists. The destination provides data integrity by managing submissions to assist in ensuring data integrity across multiple submissions. Automatic changelist cleanup is provided on the submitter so that changelists do not impact performance, memory, and storage.
摘要翻译：数据处理架构，其中提交者可以通过异步接口将数据和/或元数据更改写入目的地。该架构包括一个票务系统，以向提交者发出一张票据（唯一标识符），以响应从提交者接收更改列表。当在目的地成功完成更改时，缓存的目标数据可以重新下载到提交者，并且缓存在提交者中的更改被丢弃。缺少此功能，用户必须手动管理缓存的更改和缓存的数据。该架构可以分布在多个提交者可以提交更改列表。目的地通过管理提交来提供数据完整性，以帮助确保多个提交中的数据完整性。提交者提供自动更改清理功能，以便更改列表不会影响性能，内存和存储空间。

5. 发明授权

US08103687B2 Selecting member sets for generating asymmetric queries 有权
标题翻译：选择用于生成非对称查询的成员集
公开(公告)号：US08103687B2
公开(公告)日：2012-01-24
申请号：US12132075
申请日：2008-06-03
申请人： Patrick John Baumgartner , Luming Wang , Jason Malcolm , Xiaohong Yang , Peter Eberhardy
发明人： Patrick John Baumgartner , Luming Wang , Jason Malcolm , Xiaohong Yang , Peter Eberhardy
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30
摘要： Tools and techniques are described for selecting member sets for generating asymmetric queries. User interfaces provided by this description may include representations of different dimensions that include respective members. These dimensions define hierarchical data structures against which queries are run to generate requested reports. The user interfaces may include representations of members associated with different dimensions, with members from different dimensions arranged in selected orders. The user interfaces may also provide selection tools that activate symmetrical or asymmetrical rendering modes for constructing the query. In the symmetrical rendering mode, the query cross-joins all of the members selected from one dimension with all of the members selected from the other dimension. In the asymmetrical rendering mode, the query cross-joins the first-ordered member from one dimension with the first-ordered member from another dimension, cross-joins the second member from one dimension with the second member from another dimension, and so on.
摘要翻译：描述了用于选择用于生成非对称查询的成员集的工具和技术。由该描述提供的用户界面可以包括包括相应成员的不同维度的表示。这些维度定义了运行查询以生成请求的报告的分层数据结构。用户界面可以包括与不同尺寸相关联的构件的表示，其中来自不同维度的成员以选定顺序排列。用户界面还可以提供激活用于构建查询的对称或非对称呈现模式的选择工具。在对称渲染模式中，查询交叉连接从一个维度中选择的所有成员，其中所有成员从另一个维度中选择。在非对称渲染模式下，查询将来自一个维度的一阶成员与来自另一个维度的第一个成员交叉连接，第二个成员从一个维度与另一个维度的第二个成员进行交叉连接，依此类推。

6. 发明申请

US20080201309A1 RENDERING DATABASE QUERIES WITH BLANK SPACE 有权
标题翻译：渲染数据库查询与空白空间
公开(公告)号：US20080201309A1
公开(公告)日：2008-08-21
申请号：US11675841
申请日：2007-02-16
申请人： Patrick Baumgartner , Alisson A. S. Sol , Peter Eberhardy , Luming Wang , Mark Yang , Amer Shahnawaz
发明人： Patrick Baumgartner , Alisson A. S. Sol , Peter Eberhardy , Luming Wang , Mark Yang , Amer Shahnawaz
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/2294 , Y10S707/99933 , Y10S707/99935 , Y10S707/99939
摘要： A computer-implemented method includes selecting a first member of a first dimension of a database to be included at a first location in a report. The first member includes first data to be retrieved from the database. A blank space to be added at a second location relative to the first member is also selected. A database query is generated that includes a first instruction to retrieve first data included in the first member. The first instruction is located at a first position in the query and the first data will appear in the report at the first location. The database query also includes a second instruction to retrieve a null set of data. The second instruction is located at a second position in the query and the null set of data will appear in the report at the second location
摘要翻译：计算机实现的方法包括选择要包括在报告中的第一位置的数据库的第一维的第一成员。第一个成员包括要从数据库检索的第一个数据。还选择要在第二位置相对于第一构件添加的空白空间。生成数据库查询，其包括用于检索第一成员中包括的第一数据的第一指令。第一条指令位于查询中的第一个位置，第一个数据将显示在第一个位置的报表中。数据库查询还包括检索一组空数据的第二条指令。第二条指令位于查询中的第二个位置，空值数据集将出现在第二个位置的报表中

7. 发明申请

US20060085486A1 Method and system for enabling undo across object model modifications 有权
标题翻译：允许在对象模型修改之间进行撤销的方法和系统
公开(公告)号：US20060085486A1
公开(公告)日：2006-04-20
申请号：US10969252
申请日：2004-10-19
申请人： Lakshmi Thanu , Peter Eberhardy , Vijay Baliga
发明人： Lakshmi Thanu , Peter Eberhardy , Vijay Baliga
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , Y10S707/99944 , Y10S707/99945
摘要： A method and system provides reversibility of an operation performed by a user of an application program and associated with a modification to an object model of the application program, such as a spreadsheet program or other office productivity application program. The top item of a first undo stack associated with the application program is determined, saved, and copied to a second stack functioning as a replicated undo stack. According to one aspect of the invention, such steps are performed prior to calling an object model method that clears the first undo stack. The top item of the second replicated undo stack is placed back onto the first undo stack.
摘要翻译：方法和系统提供由应用程序的用户执行的操作的可逆性，并且与对应用程序的对象模型（例如电子表格程序或其他办公生产力应用程序）的修改相关联。确定，保存和复制与应用程序相关联的第一个撤消堆栈的顶部项，并复制到作为复制的撤消堆栈的第二个堆栈。根据本发明的一个方面，在调用清除第一个撤消堆栈的对象模型方法之前执行这些步骤。第二个复制的撤销堆栈的顶部项被放回第一个撤消堆栈。

8. 发明授权

US08515906B2 Maintaining client data integrity in a distributed environment using asynchronous data submission 有权
标题翻译：使用异步数据提交在分布式环境中维护客户端数据完整性
公开(公告)号：US08515906B2
公开(公告)日：2013-08-20
申请号：US13494650
申请日：2012-06-12
申请人： Jin Wang , Luming Wang , Malik Hussain , Zaiwei Du , Zhenyu Tang , Patrick J. Baumgartner , Mark Xiaohong Yang , Peter Eberhardy
发明人： Jin Wang , Luming Wang , Malik Hussain , Zaiwei Du , Zhenyu Tang , Patrick J. Baumgartner , Mark Xiaohong Yang , Peter Eberhardy
IPC分类号： G06F17/30
CPC分类号： G06F17/30578
摘要： Data processing architecture where submitters can write data and/or metadata changes to a destination through an asynchronous interface. The architecture includes a ticketing system that issues a ticket (a unique identifier) to the submitter in response to receiving a changelist from the submitter. When the changes are successfully completed at the destination, the cached destination data can be re-downloaded to the submitter, and the changes cached in the submitter, discarded. Absent this capability, a user has to manually manage the cached changes and cached data. The architecture can be distributed in that multiple submitters can submit changelists. The destination provides data integrity by managing submissions to assist in ensuring data integrity across multiple submissions. Automatic changelist cleanup is provided on the submitter so that changelists do not impact performance, memory, and storage.
摘要翻译：数据处理架构，其中提交者可以通过异步接口将数据和/或元数据更改写入目的地。该架构包括一个票务系统，以向提交者发出一张票据（唯一标识符），以响应从提交者接收更改列表。当在目的地成功完成更改时，缓存的目标数据可以重新下载到提交者，并且缓存在提交者中的更改被丢弃。缺少此功能，用户必须手动管理缓存的更改和缓存的数据。该架构可以分布在多个提交者可以提交更改列表。目的地通过管理提交来提供数据完整性，以帮助确保多个提交中的数据完整性。提交者提供自动更改清理功能，以便更改列表不会影响性能，内存和存储空间。

9. 发明申请

US20100293449A1 METHOD FOR EXPANDING AND COLLAPSING DATA CELLS IN A SPREADSHEET REPORT 有权
标题翻译：在扩展报告中扩展和收集数据细胞的方法
公开(公告)号：US20100293449A1
公开(公告)日：2010-11-18
申请号：US12843745
申请日：2010-07-26
申请人： Lakshmi N. Thanu , Peter Eberhardy , Dylan Hai Huang , Xiaohong Mark Yang
发明人： Lakshmi N. Thanu , Peter Eberhardy , Dylan Hai Huang , Xiaohong Mark Yang
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06F17/212 , G06F17/24 , G06F17/245
摘要： Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross-join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.
摘要翻译：电子表格报表中的数据单元格已折叠并展开，而不会中断其他电子表格数据。用户可能希望深入了解与报告的父成员相对应的数据，以显示有关父成员的更多详细信息。类似地，用户可能想要钻取与父成员相对应的显示信息以隐藏与父成员相关联的详细信息。在展开或折叠报表之前，扫描电子表格以获取信息，以确定电子表格中其他数据的显示是否会被扩展/崩溃中断。信息可以包括与父成员相关联的交叉加入信息，与父成员关联的子成员的数量，由父成员和相关联的子成员创建的报告的维度以及可以链接到父成员的其他报告包括父成员的报告。

10. 发明授权

US07809748B2 Extended cell information in multidimensional data models 有权
标题翻译：多维数据模型中的扩展单元格信息
公开(公告)号：US07809748B2
公开(公告)日：2010-10-05
申请号：US11710328
申请日：2007-02-23
申请人： George Randall Dong , Jeffrey A. Wang , Patricia O'Connor Sebelsky , Zhenyu Tang , Sridharan V. Ramanathan , Peter Eberhardy , Hai Huang , Xiaohong Yang
发明人： George Randall Dong , Jeffrey A. Wang , Patricia O'Connor Sebelsky , Zhenyu Tang , Sridharan V. Ramanathan , Peter Eberhardy , Hai Huang , Xiaohong Yang
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30312 , G06F17/30333 , G06F17/30477 , Y10S707/99933
摘要： Sharable extended cell information is used by multidimensional data models to enable cell annotations and line item details. Annotations are notes stored with a cell in a multidimensional dataset. Line item details permit levels of numeric detail below the lowest dimensional granularity. When receiving a multidimensional dataset in response to a query, a client application receives indicator information at the cell level, indicating to the client application that extended cell information is retrievable.
摘要翻译：多维数据模型使用可扩展单元格信息来启用单元格注释和订单项详细信息。注释是与单元格存储在多维数据集中的注释。订单项详细信息允许低于最小尺寸粒度的数字细节级别。当响应于查询接收到多维数据集时，客户端应用程序在单元级别接收指示符信息，向客户机应用程序指示扩展单元信息是可检索的。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式