发明授权
US07702622B2 Advanced techniques for SQL generation of performancepoint business rules
有权
用于SQL生成性能点业务规则的高级技术
- 专利标题: Advanced techniques for SQL generation of performancepoint business rules
- 专利标题(中): 用于SQL生成性能点业务规则的高级技术
-
申请号: US11771523申请日: 2007-06-29
-
公开(公告)号: US07702622B2公开(公告)日: 2010-04-20
- 发明人: Baomin Li , George Yan , Mark Yang
- 申请人: Baomin Li , George Yan , Mark Yang
- 申请人地址: US WA Redmond
- 专利权人: Microsoft Corporation
- 当前专利权人: Microsoft Corporation
- 当前专利权人地址: US WA Redmond
- 代理机构: Merchant & Gould, P.C.
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/00
摘要:
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.