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

1. 发明授权

US07805433B2 Multidimensional cube functions 有权
标题翻译：多维立方体函数
公开(公告)号：US07805433B2
公开(公告)日：2010-09-28
申请号：US11251598
申请日：2005-10-14
申请人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
发明人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30592 , G06F17/246
摘要： Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.
摘要翻译：多维数据集函数可用于从多维数据库获取数据。多维数据集函数可以包含在电子表格的一个或多个单元格内。这些立方体函数的行为与可能包含在电子表格中的标准函数类似。示例性立方体功能包括获得：立方体成员，立方体值，多维数据集，排名成员，KPI，成员属性和与集合有关的计数。电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

2. 发明申请

US20100312748A1 MULTIDIMENSIONAL CUBE FUNCTIONS 审中-公开
标题翻译：多维CUBE功能
公开(公告)号：US20100312748A1
公开(公告)日：2010-12-09
申请号：US12852235
申请日：2010-08-06
申请人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
发明人： Howard J. Dickerman , Brian W. Boon , Charles D. Ellis , Kaicheng Hu , Robert G. Hawking
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , G06F16/283
摘要： Cube functions may be used to obtain data from a multidimensional database. The cube functions may be contained within one or more cells of a spreadsheet. These cube functions behave similarly to the standard functions that may be included within a spreadsheet. Exemplary cube functions include obtaining: a cube member, a cube value, a cube set, a ranked member, a KPI, a member property and a count relating to a set. The cube functions within the spreadsheet may access the cube data from one or more multidimensional databases. Using the cube formulas in individual cells allows the user to add/delete rows and/or columns from within the spreadsheet.
摘要翻译：多维数据集函数可用于从多维数据库获取数据。多维数据集函数可以包含在电子表格的一个或多个单元格内。这些立方体函数的行为与可能包含在电子表格中的标准函数类似。示例性立方体功能包括获得：立方体成员，立方体值，多维数据集，排名成员，KPI，成员属性和与集合有关的计数。电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。

3. 发明授权

US07792847B2 Converting structured reports to formulas 失效
标题翻译：将结构化报告转换为公式
公开(公告)号：US07792847B2
公开(公告)日：2010-09-07
申请号：US11268048
申请日：2005-11-07
申请人： Howard J. Dickerman , Kaicheng Hu , Robert G. Hawking
发明人： Howard J. Dickerman , Kaicheng Hu , Robert G. Hawking
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/246 , G06F17/30554 , G06F17/30592 , Y10S707/957
摘要： Data corresponding to a structured report or multi-dimensional presentation is converted to formulas within cells of a spreadsheet. The cell formulas operate on a multi-dimension database that was the data source for the structured report. Therefore the layout of the data in the cells is similar to the layout of the data in structured report. The user is able to move the formulas around in the spreadsheet resulting in any custom layout the user desires. Because the data is no longer in a structured report, it is no longer subject to the layout restrictions of the report.
摘要翻译：与结构化报表或多维表现相对应的数据将转换为电子表格单元格内的公式。单元格公式在作为结构化报表的数据源的多维数据库上运行。因此，单元格中的数据布局与结构化报表中数据的布局相似。用户能够在电子表格中移动公式，导致用户期望的任何自定义布局。由于数据不再在结构化报表中，因此不再受报表的布局限制。

4. 发明授权

US07693860B2 Method and system to associate cell and item metadata 失效
标题翻译：关联单元格和项目元数据的方法和系统
公开(公告)号：US07693860B2
公开(公告)日：2010-04-06
申请号：US11083492
申请日：2005-03-18
申请人： Alexander A. Babanov , Charles D. Ellis , Howard J. Dickerman , Robert G. Hawking
发明人： Alexander A. Babanov , Charles D. Ellis , Howard J. Dickerman , Robert G. Hawking
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/246 , G06F17/241
摘要： The present invention generally relates to new and improved embodiments of methods and systems for capturing and providing arbitrarily rich data to be stored or manipulated within a spreadsheet. In one embodiment of the present invention, a method for creating spreadsheet metadata comprises receiving an item in a spreadsheet, receiving item metadata about the item, and associating the item metadata with the item to create spreadsheet metadata.
摘要翻译：本发明一般涉及用于捕获并提供要在电子表格内存储或操纵的任意丰富的数据的方法和系统的新的和改进的实施例。在本发明的一个实施例中，用于创建电子表格元数据的方法包括：接收电子表格中的项目，接收关于该项目的项目元数据，以及将该项目元数据与该项目相关联以创建电子表格元数据。

5. 发明授权

US07698287B2 Design of spreadsheet functions for working with tables of data 有权
标题翻译：设计用于处理数据表的电子表格功能
公开(公告)号：US07698287B2
公开(公告)日：2010-04-13
申请号：US10957502
申请日：2004-09-30
申请人： Andrew J. Becker , Charles D. Ellis , Joseph M. Chirilov , Juha P. Niemisto , Matthew J. Androski , Robert C. Collie , Robert G. Hawking , Simon Peyton-Jones
发明人： Andrew J. Becker , Charles D. Ellis , Joseph M. Chirilov , Juha P. Niemisto , Matthew J. Androski , Robert C. Collie , Robert G. Hawking , Simon Peyton-Jones
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/246 , Y10S707/99942
摘要： The present invention provides several database formulas that can manipulate large sets of data. Each database formula is customizable and repeatable without user intervention. Thus, users may enter numerous options that can cover the user's desire for data output in certain forms or formats, select a set of input data, and consistently receive a set of output data. In some embodiments, the user may refer to the set of data semantically instead of specifying a range of cells to use in the database formula. Referring to the data semantically allows the database formulas to adjust to changes in the range of cells new data may occupy.
摘要翻译：本发明提供了可以操纵大量数据的几种数据库公式。每个数据库公式是可自定义和可重复的，无需用户干预。因此，用户可以输入许多选项，其可以覆盖用户对某些形式或格式的数据输出的期望，选择一组输入数据，并且一致地接收一组输出数据。在一些实施例中，用户可以在语义上引用该组数据，而不是指定要在数据库公式中使用的单元格的范围。参考数据语义上允许数据库公式适应新数据可能占用的单元格范围内的变化。

6. 发明授权

US07558799B2 Method, system, and apparatus for discovering and connecting to data sources 有权
标题翻译：用于发现和连接到数据源的方法，系统和设备
公开(公告)号：US07558799B2
公开(公告)日：2009-07-07
申请号：US10858190
申请日：2004-06-01
申请人： Daniel C. Battagin , Johnny S. Campbell , Robert G. Hawking , Eran Megiddo , Liviu Asnash , Alexander Martynov , Brian L. Welcker , Ira Levin
发明人： Daniel C. Battagin , Johnny S. Campbell , Robert G. Hawking , Eran Megiddo , Liviu Asnash , Alexander Martynov , Brian L. Welcker , Ira Levin
IPC分类号： G06F17/30
CPC分类号： G06F17/30997 , G06F17/30557 , Y10S707/99933 , Y10S707/99945
摘要： A method, system, and apparatus for discovering and connecting to data sources are provided. A system is provided that includes a server computer operative to maintain a centrally managed repository of data connection definitions. A client computer is also provided including an application program capable of consuming data from a data source. When a request is received by the application to connect to a data source, a list of available sources is retrieved from the server computer. If one of the data sources in the list is selected, a data connection file is retrieved and utilized to connect to the data source. If a report is opened by the application that includes a reference to a data source, the repository is utilized to confirm the connection to the data source.
摘要翻译：提供了用于发现和连接到数据源的方法，系统和装置。提供了一种系统，其包括可操作以维护中央管理的数据连接定义库的服务器计算机。还提供了包括能够从数据源消耗数据的应用程序的客户端计算机。当应用程序接收到连接到数据源的请求时，从服务器计算机检索可用源的列表。如果选择列表中的数据源之一，则检索数据连接文件并将其用于连接到数据源。如果包含对数据源的引用的应用程序打开报告，则使用存储库确认与数据源的连接。

7. 发明授权

US08161372B2 Extensible value types in cells 有权
标题翻译：单元格中的可扩展值类型
公开(公告)号：US08161372B2
公开(公告)日：2012-04-17
申请号：US11297991
申请日：2005-12-09
申请人： Charles D. Ellis , Matthew J. Androski , Robert G. Hawking , Simon Peyton Jones
发明人： Charles D. Ellis , Matthew J. Androski , Robert G. Hawking , Simon Peyton Jones
IPC分类号： G06F17/00
CPC分类号： G06F17/246
摘要： Individual cells within a spreadsheet may contain an extensible value as defined by an extensible value type. The extensible value type is a user defined value type that is incorporated into the spreadsheet as a supported data type. Generally, the extensible data types provide support for types that are not internally defined by a spreadsheet. When the extensible value type is defined, an associated set of functions are developed to operate on the type. These functions are added to the set of base functions supported by the spreadsheet. The functions, therefore, behave in a substantially similar manner to the set of base spreadsheet functions. The extensible values that are contained within the cells may be acted upon in the same way that supported base types are acted upon.
摘要翻译：电子表格中的单个单元格可能包含由可扩展值类型定义的可扩展值。可扩展值类型是作为支持的数据类型合并到电子表格中的用户定义的值类型。通常，可扩展数据类型为电子表格内部未定义的类型提供支持。当定义可扩展值类型时，开发一组相关的函数来对类型进行操作。这些功能被添加到电子表格支持的一组基本功能中。因此，这些功能与基本电子表格功能的集合基本相似。包含在单元格内的可扩展值可以以与所支持的基本类型作用相同的方式起作用。

8. 发明授权

US07756824B2 Spreadsheet collaboration between rich and browser clients 有权
标题翻译：富客户端和浏览器客户端之间的电子表格协作
公开(公告)号：US07756824B2
公开(公告)日：2010-07-13
申请号：US11925019
申请日：2007-10-26
申请人： Johnny S. Campbell , Joseph M. Chirilov , Michael H. Smith , Rishabh Tandon , Robert G. Hawking , Robert L. Archer
发明人： Johnny S. Campbell , Joseph M. Chirilov , Michael H. Smith , Rishabh Tandon , Robert G. Hawking , Robert L. Archer
IPC分类号： G06F17/00
CPC分类号： G06F17/246 , G06Q10/10 , Y10S707/99954
摘要： Techniques for collaborating on a spreadsheet file by client computers in real time are disclosed herein. In particular, a revision manager module is preferably provided with a host machine which receives updates from the client computers, processes such updates, and then applies them to the spreadsheet file. Additionally, a technique is described for handling updates sent to the revision manager by clients simultaneously or near simultaneously. In this case, the revision manager determines whether the updates to the spreadsheet file are transformable or able to be merged. If so, the updates are combined into the spreadsheet file and applied thereto. If the updates are not transformable, the revision manager confirms that all clients have received all previous updates before applying the non-transformable update to the spreadsheet file.
摘要翻译：本文公开了通过客户端计算机实时协作电子表格文件的技术。特别地，修订管理器模块优选地设置有主机，其接收来自客户端计算机的更新，处理这样的更新，然后将其应用于电子表格文件。另外，描述了用于同时或接近同时处理由客户端发送到修订管理器的更新的技术。在这种情况下，修订管理器确定电子表格文件的更新是可变换的还是可以合并的。如果是这样，将更新组合到电子表格文件中并对其进行应用。如果更新不可转换，则修订管理器确认在将不可转换更新应用于电子表格文件之前，所有客户端都已收到所有先前的更新。

9. 发明申请

US20090182763A1 MULTI-CLIENT COLLABORATION TO ACCESS AND UPDATE STRUCTURED DATA ELEMENTS 有权
标题翻译：多客户协作访问和更新结构化数据元素
公开(公告)号：US20090182763A1
公开(公告)日：2009-07-16
申请号：US12014727
申请日：2008-01-15
申请人： Robert G. Hawking
发明人： Robert G. Hawking
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , G06F3/0482 , G06F17/211 , G06F17/30165 , H04L65/403
摘要： Tools and techniques for providing multi-client collaboration to access and update structured data elements are disclosed. Client systems may present user interfaces that provide libraries of published data elements that are available for collaboration. The clients may request selected data elements, while referencing unique identifiers associated with the selected data elements. Those clients that publish data elements for collaboration by others may present user interfaces that provide representations of candidate structured data elements, and receive selections of those data elements chosen for publication. The publishing clients may then send the selected data elements for publication. The client systems may interact with servers or collaboration services, which may receive structured data elements that the clients have published for access by others. The servers may define respective unique identifiers for the published data elements, and may send the structured data elements and corresponding unique identifiers to various client systems.
摘要翻译：公开了用于提供多客户端协作以访问和更新结构化数据元素的工具和技术。客户端系统可以呈现提供可用于协作的已发布数据元素库的用户界面。客户端可以请求所选择的数据元素，同时引用与所选数据元素相关联的唯一标识符。那些发布他人协作的数据元素的客户端可能呈现提供候选结构化数据元素表示的用户界面，并接收选择用于发布的那些数据元素的选择。然后，发布客户端可以发送所选择的数据元素以供发布。客户端系统可以与服务器或协作服务进行交互，这些服务器或协作服务可以接收客户端为其他人访问的结构化数据元素。服务器可以为所发布的数据元素定义相应的唯一标识符，并且可以将结构化数据元素和对应的唯一标识符发送到各种客户端系统。

10. 发明申请

US20090112937A1 SPREADSHEET COLLABORATION BETWEEN RICH AND BROWSER CLIENTS 有权
标题翻译：丰富的浏览器客户之间的扩展协作
公开(公告)号：US20090112937A1
公开(公告)日：2009-04-30
申请号：US11925019
申请日：2007-10-26
申请人： Johnny S. Campbell , Joseph M. Chirilov , Michael H. Smith , Robert G. Hawking , Rishabh Tandon , Robert L. Archer
发明人： Johnny S. Campbell , Joseph M. Chirilov , Michael H. Smith , Robert G. Hawking , Rishabh Tandon , Robert L. Archer
IPC分类号： G06F17/30
CPC分类号： G06F17/246 , G06Q10/10 , Y10S707/99954
摘要： Techniques for collaborating on a spreadsheet file by client computers in real time are disclosed herein. In particular, a revision manager module is preferably provided with a host machine which receives updates from the client computers, processes such updates, and then applies them to the spreadsheet file. Additionally, a technique is described for handling updates sent to the revision manager by clients simultaneously or near simultaneously. In this case, the revision manager determines whether the updates to the spreadsheet file are transformable or able to be merged. If so, the updates are combined into the spreadsheet file and applied thereto. If the updates are not transformable, the revision manager confirms that all clients have received all previous updates before applying the non-transformable update to the spreadsheet file.
摘要翻译：本文公开了通过客户端计算机实时协作电子表格文件的技术。特别地，修订管理器模块优选地设置有主机，其接收来自客户端计算机的更新，处理这样的更新，然后将其应用于电子表格文件。另外，描述了用于同时或接近同时处理由客户端发送到修订管理器的更新的技术。在这种情况下，修订管理器确定电子表格文件的更新是可变换的还是可以合并的。如果是这样，将更新组合到电子表格文件中并对其进行应用。如果更新不可转换，则修订管理器确认在将不可转换更新应用于电子表格文件之前，所有客户端都已收到所有先前的更新。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式