| 基于FLEX和MDX的Web-OLAP设计及实现 |
| |
| 引用本文： | 向新,陈德焜,李良.基于FLEX和MDX的Web-OLAP设计及实现[J].微计算机应用,2011,32(3). |
| |
| 作者姓名： | 向新 陈德焜 李良 |
| |
| 作者单位： | 上海大学上海市机械自动化及机器人重点实验室,上海,200072 |
| |
| 摘 要： | 传统的OLAP分析基于关系结构,过度依赖其数据模型,影响分析效率.为此提出一种对驻留在Web上的任何标准多维数据源的通用Web-OLAP解决方案.详细设计了FLEX三状态控件树的界面多维分析工具,通过多维模型元数据访问和XML结构树的遍历算法实现了MDX多维查询语句的定制,并结合XMLA服务代理和仪表盘技术实现了多维模型在第三方平台的OLAP分析.该方案能适应灵活变化的主题分析需求,及时向决策者提供全面的分析结果.
|
| 关 键 词： | 数据仓库 MDX 联机分析处理 XMLA 仪表盘 |
Design and Realization of Web -OLAP System Based on Flex and MDX |
| |
| XIANG Xin,CHEN Dekun,LI Liang.Design and Realization of Web -OLAP System Based on Flex and MDX[J].Microcomputer Applications,2011,32(3). |
| |
| Authors: | XIANG Xin CHEN Dekun LI Liang |
| |
| Affiliation: | XIANG Xin,CHEN Dekun,LI Liang(Shanghai University,Key Laboratory of Mechanical Automation and Robotics,Shanghai,200072,China) |
| |
| Abstract: | Traditional OLAP based on relational structure and data resource mostly,so it affects analyzing efficiency.In this paper,a general web-OLAP tool is proposed to analyze any standard multi-dimension model present on the web.Multi-dimensional data analysis tool based on Flex three-state control tree was designed in detail.With the access to metadata web service of multi-dimension model and traversal of XML structure tree,the MDX multi-dimension SQL is customized.OLAP analyzing of multi-dimension model on the t... |
| |
| Keywords: | Data Warehouse MDX OLAP XMLA Dashboard |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
