CN102782675A - 数据分析表达式 - Google Patents

数据分析表达式 Download PDF

Info

Publication number
CN102782675A
CN102782675A CN2010800455064A CN201080045506A CN102782675A CN 102782675 A CN102782675 A CN 102782675A CN 2010800455064 A CN2010800455064 A CN 2010800455064A CN 201080045506 A CN201080045506 A CN 201080045506A CN 102782675 A CN102782675 A CN 102782675A
Authority
CN
China
Prior art keywords
data
tables
dax
column
data analysis
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN2010800455064A
Other languages
English (en)
Chinese (zh)
Inventor
H·J·迪克曼
M·杜米特鲁
A·米尔查达尼
Y（J）·王
A·耐茨
P·J·桑德斯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Technology Licensing LLC
Original Assignee
Microsoft Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Microsoft Corp filed Critical Microsoft Corp
Priority to CN201510616470.5A priority Critical patent/CN105260347B/zh
Publication of CN102782675A publication Critical patent/CN102782675A/zh
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Artificial Intelligence (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Document Processing Apparatus (AREA)
  • Analysing Materials By The Use Of Radiation (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CN2010800455064A 2009-10-09 2010-10-06 数据分析表达式 Pending CN102782675A (zh)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510616470.5A CN105260347B (zh) 2009-10-09 2010-10-06 数据分析表达式

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US12/576,254 US9275031B2 (en) 2009-10-09 2009-10-09 Data analysis expressions
US12/576,254 2009-10-09
PCT/US2010/051696 WO2011044286A2 (en) 2009-10-09 2010-10-06 Data analysis expressions

Related Child Applications (1)

Application Number Title Priority Date Filing Date
CN201510616470.5A Division CN105260347B (zh) 2009-10-09 2010-10-06 数据分析表达式

Publications (1)

Publication Number Publication Date
CN102782675A true CN102782675A (zh) 2012-11-14

Family

ID=43855804

Family Applications (2)

Application Number Title Priority Date Filing Date
CN2010800455064A Pending CN102782675A (zh) 2009-10-09 2010-10-06 数据分析表达式
CN201510616470.5A Active CN105260347B (zh) 2009-10-09 2010-10-06 数据分析表达式

Family Applications After (1)

Application Number Title Priority Date Filing Date
CN201510616470.5A Active CN105260347B (zh) 2009-10-09 2010-10-06 数据分析表达式

Country Status (5)

Country Link
US (4) US9275031B2 (https=)
EP (1) EP2486501A4 (https=)
JP (1) JP6017309B2 (https=)
CN (2) CN102782675A (https=)
WO (1) WO2011044286A2 (https=)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104050223A (zh) * 2013-03-15 2014-09-17 国际商业机器公司 用于文本挖掘和搜索的数据透视面
CN106502966A (zh) * 2015-09-07 2017-03-15 北京国双科技有限公司 Excel文档处理方法和装置
CN112784557A (zh) * 2019-11-08 2021-05-11 珠海金山办公软件有限公司 一种确定数据透视表的方法及装置
CN114912427A (zh) * 2021-02-10 2022-08-16 微软技术许可有限责任公司 响应于用户输入的数据表分析
CN118036579A (zh) * 2022-11-08 2024-05-14 中国石油天然气集团有限公司 表格的处理方法

Families Citing this family (33)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9747270B2 (en) 2011-01-07 2017-08-29 Microsoft Technology Licensing, Llc Natural input for spreadsheet actions
US9721030B2 (en) 2010-12-09 2017-08-01 Microsoft Technology Licensing, Llc Codeless sharing of spreadsheet objects
US8589336B1 (en) * 2011-04-25 2013-11-19 Netapp, Inc. Framework for automated storage processes and flexible workflow
US9348941B2 (en) * 2011-06-16 2016-05-24 Microsoft Technology Licensing, Llc Specification of database table relationships for calculation
US8645346B2 (en) 2011-06-16 2014-02-04 Microsoft Corporation Composable SQL query generation
US9135233B2 (en) 2011-10-13 2015-09-15 Microsoft Technology Licensing, Llc Suggesting alternate data mappings for charts
US9411797B2 (en) 2011-10-31 2016-08-09 Microsoft Technology Licensing, Llc Slicer elements for filtering tabular data
US10061473B2 (en) 2011-11-10 2018-08-28 Microsoft Technology Licensing, Llc Providing contextual on-object control launchers and controls
US8793567B2 (en) 2011-11-16 2014-07-29 Microsoft Corporation Automated suggested summarizations of data
US20130145244A1 (en) * 2011-12-05 2013-06-06 Microsoft Corporation Quick analysis tool for spreadsheet application programs
US9235633B2 (en) 2011-12-06 2016-01-12 International Business Machines Corporation Processing data in a data warehouse
CN102799652B (zh) * 2012-06-29 2014-11-12 用友软件股份有限公司 多维数据展现装置和多维数据展现方法
US8983900B2 (en) * 2012-10-23 2015-03-17 Sap Se Generic semantic layer for in-memory database reporting
US10664652B2 (en) 2013-06-15 2020-05-26 Microsoft Technology Licensing, Llc Seamless grid and canvas integration in a spreadsheet application
US20140372932A1 (en) * 2013-06-15 2014-12-18 Microsoft Corporation Filtering Data with Slicer-Style Filtering User Interface
US10156961B1 (en) * 2013-09-24 2018-12-18 EMC IP Holding Company LLC Dynamically building a visualization filter
US10895975B1 (en) 2014-09-08 2021-01-19 Tableau Software, Inc. Systems and methods for using displayed data marks in a dynamic data visualization interface
US9922081B2 (en) * 2015-06-11 2018-03-20 Microsoft Technology Licensing, Llc Bidirectional cross-filtering in analysis service systems
JP6716873B2 (ja) * 2015-08-10 2020-07-01 富士通株式会社 データ処理方法、データ処理プログラムおよび情報処理装置
US10521077B1 (en) 2016-01-14 2019-12-31 Tableau Software, Inc. Visual analysis of a dataset using linked interactive data visualizations
US10824803B2 (en) 2016-09-12 2020-11-03 DataRails LTD. System and method for logical identification of differences between spreadsheets
US11170164B2 (en) 2016-12-11 2021-11-09 DataRails LTD. System and method for cell comparison between spreadsheets
US11475212B2 (en) * 2017-04-06 2022-10-18 Otsuka Pharmaceutical Development & Commercialization, Inc. Systems and methods for generating and modifying documents describing scientific research
US10877735B1 (en) 2017-09-25 2020-12-29 Amazon Technologies, Inc. Automated generation of software applications using analysis of submitted content items
US10740550B1 (en) * 2017-11-20 2020-08-11 Amazon Technologies, Inc. Network-accessible data management service with web-of-sheets data model
US10705805B1 (en) 2017-12-12 2020-07-07 Amazon Technologies, Inc. Application authoring using web-of-sheets data model
US11586603B1 (en) 2018-05-23 2023-02-21 Amazon Technologies, Inc. Index sheets for robust spreadsheet-based applications
US12223262B1 (en) * 2019-03-27 2025-02-11 Amazon Technologies, Inc. Expressions management service for data sheet-based applications
US11429604B2 (en) * 2019-09-10 2022-08-30 Oracle International Corporation Techniques of heterogeneous hardware execution for SQL analytic queries for high volume data processing
CA3208517A1 (en) * 2021-02-26 2022-09-01 Cesar LEE Apparatus and method for forming pivot tables from pivot frames
CN115034175A (zh) * 2021-07-23 2022-09-09 北京字跳网络技术有限公司 表格数据处理方法、装置、终端和存储介质
CN116303546A (zh) * 2023-04-13 2023-06-23 北京字跳网络技术有限公司 数据查询方法、装置和电子设备
CN117909382A (zh) * 2024-01-05 2024-04-19 浪潮卓数大数据产业发展有限公司 一种可实现数据透视的数据分析方法及装置

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1755679A (zh) * 2004-09-30 2006-04-05 微软公司 用于引用电子表格公式内动态数据的方法和实现
CN1755668A (zh) * 2004-09-30 2006-04-05 微软公司 对数据表格起作用的电子表格函数的设计
US7337176B1 (en) * 2003-08-29 2008-02-26 Sprint Communications Company L.P. Data loading tool for loading a database

Family Cites Families (37)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH0737008A (ja) * 1993-06-29 1995-02-07 Hitachi Ltd 表計算処理装置の表示制御方法
US5603021A (en) 1994-09-02 1997-02-11 Borland International, Inc. Methods for composing formulas in an electronic spreadsheet system
US5870747A (en) * 1996-07-09 1999-02-09 Informix Software, Inc. Generalized key indexes
US6292811B1 (en) * 1997-09-19 2001-09-18 Modernsoft, Inc. Populating cells of an electronic financial statement
US20020029207A1 (en) * 2000-02-28 2002-03-07 Hyperroll, Inc. Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein
AUPQ836500A0 (en) * 2000-06-26 2000-07-20 Dstc Pty Ltd Parallel execution mechanism for spreadsheets
US20020184260A1 (en) * 2001-05-30 2002-12-05 Paul Martin Multidimensional data entry in a spreadsheet
US20030009649A1 (en) * 2001-05-30 2003-01-09 Paul Martin Dynamic conversion of spreadsheet formulas to multidimensional calculation rules
US7925616B2 (en) * 2001-06-19 2011-04-12 Microstrategy, Incorporated Report system and method using context-sensitive prompt objects
EP1618488B1 (en) * 2003-04-18 2006-11-08 International Business Machines Corporation System and method in a data table for managing insertion operations in recursive scalable template instances
US7530012B2 (en) * 2003-05-22 2009-05-05 International Business Machines Corporation Incorporation of spreadsheet formulas of multi-dimensional cube data into a multi-dimensional cube
US7299223B2 (en) 2003-07-16 2007-11-20 Oracle International Corporation Spreadsheet to SQL translation
US7882132B2 (en) * 2003-10-09 2011-02-01 Oracle International Corporation Support for RDBMS in LDAP system
US7213199B2 (en) * 2004-07-16 2007-05-01 Cognos Incorporated Spreadsheet user-interface for an enterprise planning system having multi-dimensional data store
US7991804B2 (en) * 2004-07-30 2011-08-02 Microsoft Corporation Method, system, and apparatus for exposing workbooks as data sources
US20060036939A1 (en) 2004-08-13 2006-02-16 Microsoft Corporation Support for user-specified spreadsheet functions
US7676738B2 (en) * 2004-09-13 2010-03-09 Whitebirch Software, Inc. Scenario-dependent evaluation formula
US20060085386A1 (en) 2004-10-19 2006-04-20 Microsoft Corporation Two pass calculation to optimize formula calculations for a spreadsheet
US7634730B2 (en) * 2004-12-15 2009-12-15 Microsoft Corporation Task helpers
US20060235834A1 (en) 2005-04-14 2006-10-19 Microsoft Corporation Path expression in structured query language
US7747939B2 (en) * 2005-05-31 2010-06-29 Microsoft Corporation Generating free form reports within a data array
US8234293B2 (en) * 2005-09-08 2012-07-31 Microsoft Corporation Autocompleting with queries to a database
US7792847B2 (en) * 2005-09-09 2010-09-07 Microsoft Corporation Converting structured reports to formulas
US8095866B2 (en) * 2005-09-09 2012-01-10 Microsoft Corporation Filtering user interface for a data summary table
US7805433B2 (en) * 2005-10-14 2010-09-28 Microsoft Corporation Multidimensional cube functions
JP4140919B2 (ja) * 2006-03-14 2008-08-27 インターナショナル・ビジネス・マシーンズ・コーポレーション 表計算などの処理を行うシステムおよびその方法
CN1821993A (zh) * 2006-03-24 2006-08-23 无锡永中科技有限公司 基于时间序列的电子表格数据处理方法
US8656271B2 (en) 2006-07-31 2014-02-18 Sap Ag Adapting a spreadsheet for use with a complex object
US7814052B2 (en) 2006-11-03 2010-10-12 Salesforce.Com, Inc. Implementing formulas for custom fields in an on-demand database
US20080294612A1 (en) * 2007-05-22 2008-11-27 It-Workplace Method For Generating A Representation Of A Query
US8200604B2 (en) 2007-06-29 2012-06-12 Microsoft Corporation Multi-platform business calculation rule language and execution environment
US8112701B2 (en) * 2007-08-06 2012-02-07 Apple Inc. Reference adding behavior in formula editing mode
US9268837B2 (en) * 2007-12-04 2016-02-23 International Business Machines Corporation Data entry commentary and sheet reconstruction for multidimensional enterprise system
US9330149B2 (en) * 2007-12-18 2016-05-03 Oracle International Corporation Techniques for query and DML over relational tables using spreadsheet applications
US20090327851A1 (en) * 2008-06-27 2009-12-31 Steven Raposo Data analysis method
US9996519B2 (en) * 2008-09-30 2018-06-12 Apple Inc. Context sensitive computations
US8386916B2 (en) * 2008-12-29 2013-02-26 SAP France S.A. Systems and methods to create a multidimensional expression calculated member in a spreadsheet cell

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7337176B1 (en) * 2003-08-29 2008-02-26 Sprint Communications Company L.P. Data loading tool for loading a database
CN1755679A (zh) * 2004-09-30 2006-04-05 微软公司 用于引用电子表格公式内动态数据的方法和实现
CN1755668A (zh) * 2004-09-30 2006-04-05 微软公司 对数据表格起作用的电子表格函数的设计

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104050223A (zh) * 2013-03-15 2014-09-17 国际商业机器公司 用于文本挖掘和搜索的数据透视面
CN104050223B (zh) * 2013-03-15 2017-10-31 国际商业机器公司 用于文本挖掘和搜索的数据透视面
US10180984B2 (en) 2013-03-15 2019-01-15 International Business Machines Corporation Pivot facets for text mining and search
CN106502966A (zh) * 2015-09-07 2017-03-15 北京国双科技有限公司 Excel文档处理方法和装置
CN106502966B (zh) * 2015-09-07 2019-08-20 北京国双科技有限公司 Excel文档处理方法和装置
CN112784557A (zh) * 2019-11-08 2021-05-11 珠海金山办公软件有限公司 一种确定数据透视表的方法及装置
CN112784557B (zh) * 2019-11-08 2023-06-30 珠海金山办公软件有限公司 一种确定数据透视表的方法及装置
CN114912427A (zh) * 2021-02-10 2022-08-16 微软技术许可有限责任公司 响应于用户输入的数据表分析
CN118036579A (zh) * 2022-11-08 2024-05-14 中国石油天然气集团有限公司 表格的处理方法

Also Published As

Publication number Publication date
US20160132481A1 (en) 2016-05-12
US11366960B2 (en) 2022-06-21
US9665555B2 (en) 2017-05-30
US20110087954A1 (en) 2011-04-14
US20210019472A1 (en) 2021-01-21
US9275031B2 (en) 2016-03-01
EP2486501A4 (en) 2018-01-17
US20180032498A1 (en) 2018-02-01
JP6017309B2 (ja) 2016-10-26
US10762289B2 (en) 2020-09-01
WO2011044286A2 (en) 2011-04-14
CN105260347B (zh) 2019-04-19
CN105260347A (zh) 2016-01-20
EP2486501A2 (en) 2012-08-15
WO2011044286A3 (en) 2011-07-28
JP2013507689A (ja) 2013-03-04

Similar Documents

Publication Publication Date Title
US11366960B2 (en) Data analysis expressions
US11741059B2 (en) System and method for extracting a star schema from tabular data for use in a multidimensional database environment
US10579723B2 (en) User interface for creating a spreadsheet data summary table
US8095866B2 (en) Filtering user interface for a data summary table
US8185509B2 (en) Association of semantic objects with linguistic entity categories
US20060074879A1 (en) Easy-to-use data context filtering
US9633077B2 (en) Query of multiple unjoined views
WO2010091456A1 (en) Creation of a data store
US20090006455A1 (en) Automated time metadata deduction
US7711709B2 (en) Efficient storing and querying of snapshot measures
US8577862B2 (en) Answer-augmented query suggestion
US9811931B2 (en) Recommendations for creation of visualizations
Clark Beginning Power BI with Excel 2013: Self-Service Business Intelligence Using Power Pivot, Power View, Power Query, and Power Map
Ferrari et al. Microsoft PowerPivot for Excel 2010: Give your data meaning
US20150006579A1 (en) Custom grouping of multidimensional data
Kellenberger et al. Time Range Calculations
Kellenberger et al. Time Range Calculations and Trends
Desktop et al. Beginning Power BI

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
ASS Succession or assignment of patent right

Owner name: MICROSOFT TECHNOLOGY LICENSING LLC

Free format text: FORMER OWNER: MICROSOFT CORP.

Effective date: 20150727

C41 Transfer of patent application or patent right or utility model
TA01 Transfer of patent application right

Effective date of registration: 20150727

Address after: Washington State

Applicant after: Micro soft technique license Co., Ltd

Address before: Washington State

Applicant before: Microsoft Corp.

C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20121114