-
公开(公告)号:US20070088691A1
公开(公告)日:2007-04-19
申请号:US11251598
申请日:2005-10-14
申请人: Howard Dickerman , Brian Boon , Charles Ellis , Kaicheng Hu , Robert Hawking
发明人: Howard Dickerman , Brian Boon , Charles Ellis , Kaicheng Hu , Robert Hawking
IPC分类号: G06F17/30
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,成员属性和与集合有关的计数。 电子表格中的多维数据集功能可以从一个或多个多维数据库访问多维数据集数据。 在单个单元格中使用多维数据集公式允许用户从电子表格中添加/删除行和/或列。
-
公开(公告)号:US20070204019A1
公开(公告)日:2007-08-30
申请号:US11361502
申请日:2006-02-24
申请人: Alexander Martynov , Brian Boon , Howard Dickerman , Patrick King
发明人: Alexander Martynov , Brian Boon , Howard Dickerman , Patrick King
IPC分类号: G06F15/173
摘要: Embodiments of present application treat Connection Information Files contained in an instance of an application, such as a workbook, as independent objects and multiple data objects, such as data summary tables, may link to one Connection Information File. Maintaining Connection Information Files as independent objects within an instance of an application provides the ability to modify a connection to an external data source and have that modification applied to all linked data objects without having to modify each data object individually. Additionally, a user may view a complete list of all Connection Information Files that exist within a workbook and easily add, delete, or modify those Connection Information Files.
摘要翻译: 本申请的实施例将连接信息包含在诸如工作簿的应用的实例中的文件作为独立对象和诸如数据摘要表的多个数据对象可以链接到一个连接信息文件。 维护连接信息文件作为应用程序实例中的独立对象提供了修改与外部数据源的连接的能力,并将该修改应用于所有链接的数据对象,而无需单独修改每个数据对象。 此外,用户可以查看工作簿中存在的所有连接信息文件的完整列表,并轻松添加,删除或修改这些连接信息文件。
-
公开(公告)号:US07653731B2
公开(公告)日:2010-01-26
申请号:US11361502
申请日:2006-02-24
IPC分类号: G06F15/16 , G06F3/048 , G06F15/173 , G06F15/177
摘要: Embodiments of present application treat Connection Information Files contained in an instance of an application, such as a workbook, as independent objects and multiple data objects, such as data summary tables, may link to one Connection Information File. Maintaining Connection Information Files as independent objects within an instance of an application provides the ability to modify a connection to an external data source and have that modification applied to all linked data objects without having to modify each data object individually. Additionally, a user may view a complete list of all Connection Information Files that exist within a workbook and easily add, delete, or modify those Connection Information Files.
摘要翻译: 本申请的实施例将连接信息包含在诸如工作簿的应用的实例中的文件作为独立对象和诸如数据摘要表的多个数据对象可以链接到一个连接信息文件。 维护连接信息文件作为应用程序实例中的独立对象提供了修改与外部数据源的连接的能力,并将该修改应用于所有链接的数据对象,而无需单独修改每个数据对象。 此外,用户可以查看工作簿中存在的所有连接信息文件的完整列表,并轻松添加,删除或修改这些连接信息文件。
-
-