Invention Grant
US07702622B2 Advanced techniques for SQL generation of performancepoint business rules
有权
用于SQL生成性能点业务规则的高级技术
- Patent Title: Advanced techniques for SQL generation of performancepoint business rules
- Patent Title (中): 用于SQL生成性能点业务规则的高级技术
-
Application No.: US11771523Application Date: 2007-06-29
-
Publication No.: US07702622B2Publication Date: 2010-04-20
- Inventor: Baomin Li , George Yan , Mark Yang
- Applicant: Baomin Li , George Yan , Mark Yang
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Merchant & Gould, P.C.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

Abstract:
Computer-implemented methods and computer-readable storage media are disclosed to facilitate the application of business rules. A rule is received, the rule defining one or more calculations to be performed on specified data stored in a multidimensional database to yield at least one result. At least one database query is generated seeking the specified data to be retrieved from the multidimensional database. An intermediary table is created to accommodate the specified data retrieved from the multidimensional database. The specified data is stored in the intermediary table and the specified data is manipulated when the data is retrieved or after the specified data is stored in the intermediary table.
Public/Granted literature
- US20090006370A1 ADVANCED TECHNIQUES FOR SQL GENERATION OF PERFORMANCEPOINT BUSINESS RULES Public/Granted day:2009-01-01
Information query