公开(公告)号：US20060107196A1

公开(公告)日：2006-05-18

申请号：US10987013

申请日：2004-11-12

申请人： Lakshmi Thanu ,  Peter Eberhardy ,  Dylan Huang ,  Xiaohong Yang

发明人： Lakshmi Thanu ,  Peter Eberhardy ,  Dylan Huang ,  Xiaohong Yang

IPC分类号： G06F17/00 ,  G06F15/00 ,  G06F17/21

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.

公开(公告)号：US20060085386A1

公开(公告)日：2006-04-20

申请号：US10969381

申请日：2004-10-19

申请人： Lakshmi Thanu ,  Peter Eberhardy ,  Xiaohong Yang

发明人： Lakshmi Thanu ,  Peter Eberhardy ,  Xiaohong Yang

IPC分类号： G06F17/30 ,  G06F17/00 ,  G06F17/24

CPC分类号： G06F17/246 ,  G06F16/24556 ,  G06F16/24557

摘要： Current cell values are provided to a client using two-passes. When a first request to provide values is received during a first pass, default values are provided to the client. Upon receiving each value request, the formula parameters are collected that are associated with the cell. The formula parameters are parsed to determine data that is to be retrieved from a database. Once the locations for all of the data to be retrieved has been determined, the data is retrieved from a database in as few as hits as possible. After obtaining the current values from the database, the client is informed to request the values a second time. When the second request to provide values is received, the client is provided with the calculated values during the second pass.

摘要翻译： 当前单元格值使用双程提供给客户端。 当在第一次通过期间收到提供值的第一个请求时，将向客户端提供默认值。 收到每个值请求后，收集与该单元格关联的公式参数。 解析公式参数以确定要从数据库检索的数据。 一旦确定要检索的所有数据的位置，就尽可能少地从数据库中检索数据。 在从数据库获取当前值之后，通知客户端再次请求值。 当接收到提供值的第二请求时，在第二次通过期间向客户端提供计算的值。

公开(公告)号：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.

摘要翻译： 方法和系统提供由应用程序的用户执行的操作的可逆性，并且与对应用程序的对象模型（例如电子表格程序或其他办公生产力应用程序）的修改相关联。 确定，保存和复制与应用程序相关联的第一个撤消堆栈的顶部项，并复制到作为复制的撤消堆栈的第二个堆栈。 根据本发明的一个方面，在调用清除第一个撤消堆栈的对象模型方法之前执行这些步骤。 第二个复制的撤销堆栈的顶部项被放回第一个撤消堆栈。

公开(公告)号：US20060271869A1

公开(公告)日：2006-11-30

申请号：US11142064

申请日：2005-05-31

申请人： Lakshmi Thanu ,  Peter Eberhardy ,  Mark Yang

发明人： Lakshmi Thanu ,  Peter Eberhardy ,  Mark Yang

IPC分类号： G06F9/00

CPC分类号： G06F9/451

摘要： Methods of providing (1) additional functionality and/or (2) accessibility to user functions in a software application program are disclosed. Computer readable medium having stored thereon computer-executable instructions for performing methods of providing (1) additional functionality and/or (2) accessibility to user functions in a software application program are disclosed. Further, computing systems containing at least one application module, wherein the at least one application module comprises application code for performing methods of (1) additional functionality and/or (2) accessibility to user functions in a software application program are disclosed.

摘要翻译： 公开了在软件应用程序中提供（1）附加功能和/或（2）可访问用户功能的方法。 公开了其上存储有计算机可执行指令的计算机可读介质，用于执行在软件应用程序中提供（1）附加功能和/或（2）可访问用户功能的方法。 此外，公开了包含至少一个应用模块的计算系统，其中所述至少一个应用模块包括用于执行（1）附加功能和/或（2）软件应用程序中的用户功能的可访问性的方法的应用代码。

公开(公告)号：US20060085444A1

公开(公告)日：2006-04-20

申请号：US10969367

申请日：2004-10-19

申请人： Nina Sarawgi ,  Lakshmi Thanu ,  Xiaohong Yang

发明人： Nina Sarawgi ,  Lakshmi Thanu ,  Xiaohong Yang

IPC分类号： G06F17/30

CPC分类号： G06F16/283 ,  G06F16/2454

摘要： Queries to obtain data from an OLAP cube are consolidated. Queries are consolidated to reduce the number of database hits to retrieve data from an OLAP cube. Instead of querying the OLAP cube for each cell in a free-form report, a consolidated query is used to obtain the desired information. The consolidated query may contain requests for data from different dimensions within the OLAP cube. The cells in the spreadsheet are parsed to determine the dimensions of the OLAP cube that are used within the spreadsheet cell. A list of dimensions accessed by the spreadsheet cells is compiled and the query is constructed by adding default dimensions to each cell as necessary to complete the query.

摘要翻译： 从OLAP多维数据集获取数据的查询被合并。 合并查询以减少从OLAP多维数据集检索数据的数据库命中数。 而不是在自由格式报告中为每个单元格查询OLAP多维数据集，而是使用统一查询来获取所需的信息。 统一查询可能包含对OLAP多维数据集中不同维度的数据的请求。 解析电子表格中的单元格以确定在电子表格单元格中使用的OLAP多维数据集的维度。 编译电子表格单元访问的维度列表，并根据需要向每个单元格添加默认维度来构建查询，以完成查询。

公开(公告)号：US20060271841A1

公开(公告)日：2006-11-30

申请号：US11142062

申请日：2005-05-31

申请人： Lakshmi Thanu ,  Peter Eberhardy ,  Hai Huang

发明人： Lakshmi Thanu ,  Peter Eberhardy ,  Hai Huang

IPC分类号： G06F17/00

CPC分类号： G06F17/246

摘要： Free form reports may be generated within a data array system such as a spreadsheet computer application. A user may select dimension members of a data source, such as an online analytical processing (OLAP) data cube. The user may position the dimension members as headers on the data array where multiple dimensions may be represented in one or both axes. Member formulas are generated that are representative of the headers and include identifiers that point to the dimension member location of the data source. Value formulas are generated within the report grid defined by the location of the headers where the value formulas are representative of the actual data values of the report and include identifiers that point to the data value locations of the dimension member locations within the data source.

摘要翻译： 可以在诸如电子表格计算机应用的数据阵列系统内生成自由表单报告。 用户可以选择数据源的维度成员，例如在线分析处理（OLAP）数据立方体。 用户可以将维度成员定位在数据数组上的头部，其中可以在一个或两个轴中表示多个维度。 生成代表标题的成员公式，并包括指向数据源的维成员位置的标识符。 价值公式是由标题位置定义的报表网格内生成的，其中值公式代表报表的实际数据值，并包括指向数据源中维度成员位置的数据值位置的标识符。

公开(公告)号：US20060085446A1

公开(公告)日：2006-04-20

申请号：US10970791

申请日：2004-10-20

申请人： Lakshmi Thanu ,  Peter Eberhardy ,  Vijay Baliga

发明人： Lakshmi Thanu ,  Peter Eberhardy ,  Vijay Baliga

IPC分类号： G06F7/00

CPC分类号： G06F9/4493

摘要： Indirect persistent storage of data in a file that is associated with an application program and is capable of having an embedded OLEObject includes creating the OLEObject by way of a Component Object Model add-in that supplements the application program, and using the OLEObject to store the data in the file. The OLEObject is marked so that it is hidden from a user of the application program. After loading a file that was previously saved and closed, the OLEObject is initialized, and the stored data is retrieved. The add-in may be a reporting add-in that queries a database, such as an OLAP database.

摘要翻译： 在与应用程序相关联并且能够具有嵌入式OLEObject的文件中的数据的间接持续存储包括通过补充应用程序的组件对象模型加载项来创建OLEObject，并使用OLEObject来存储 文件中的数据。 OLEObject被标记为使其被应用程序的用户隐藏。 加载先前保存并关闭的文件后，将初始化OLEObject，并检索存储的数据。 加载项可以是查询数据库（例如OLAP数据库）的报表加载项。

公开(公告)号：US20060085445A1

公开(公告)日：2006-04-20

申请号：US10969371

申请日：2004-10-19

申请人： Lakshmi Thanu

发明人： Lakshmi Thanu

IPC分类号： G06F17/30

CPC分类号： G06F17/30592

摘要： Queries to obtain data from an OLAP cube for a structured report are consolidated. Queries to retrieve data from an OLAP cube for a structured report are consolidated into a single query. Using the consolidated query reduces the number of database hits; avoids reconstruction of the report from the results of the individual queries; and eases the exporting of the report to other applications. Instead of querying the OLAP cube multiple times, a single query is used to obtain the desired information from the cube. Each access definition within the structured report is examined to determine all of the data to be retrieved from the OLAP cube.

摘要翻译： 整合了从结构化报表的OLAP多维数据集获取数据的查询。 从结构化报表的OLAP多维数据集中检索数据的查询被合并到单个查询中。 使用综合查询减少数据库命中数; 避免从个别查询结果重新生成报告; 并简化将报告导出到其他应用程序。 多次查询OLAP多维数据集，而不是使用单个查询来从多维数据集中获取所需的信息。 检查结构化报表中的每个访问定义以确定要从OLAP多维数据集检索的所有数据。