| 基于Excel的OLAP的应用研究 |
| |
| 引用本文： | 王标,汪光阳,孟宪磊. 基于Excel的OLAP的应用研究[J]. 计算机与现代化, 2008, 0(1): 88-90 |
| |
| 作者姓名： | 王标 汪光阳 孟宪磊 |
| |
| 作者单位： | 安徽工业大学计算机学院,安徽,马鞍山,243002 |
| |
| 摘 要： | 针对目前OLAP在实际应用中存在的问题，本文引入了Excel分析软件，提出了一种基于Excel的OLAP。给出了一个完整的OLAP解决方案。这一方案将用户熟悉的Excel环境与OLAP技术完美结合起来，充分发挥用户分析数据的主动性。实际应用中的结果表明，提高了企业对现有的信息数据的利用效率，提高了企业决策分析的能力。
|
| 关 键 词： | 商务智能系统 Excel 联机分析处理 |
| 文章编号： | 1006-2475（2007）01-0088-03 |
| 收稿时间： | 2007-08-06 |
| 修稿时间： | 2007-08-06 |
Research and Application of OLAP Based on Excel |
| |
| WANG Biao,WANG Guang-yang,MENG Xian-lei. Research and Application of OLAP Based on Excel[J]. Computer and Modernization, 2008, 0(1): 88-90 |
| |
| Authors: | WANG Biao WANG Guang-yang MENG Xian-lei |
| |
| Affiliation: | ( Anhui Univ. of Tech. , Maanshan 243002, China) |
| |
| Abstract: | Aiming at the problems of OLAP in the practical application,this paper introduces Excel,proposes one kind of OLAP based Excel,puts forward a comprehensive solution of OLAP.The solution integrates OLAP technology into Excel application environment,promotes users to analyze date on their own initiative.The result in the practical application indicates that the using efficiency of the existed information data has been heightened,and the ability of the enterprise decision analysis has been improved. |
| |
| Keywords: | BI Excel OLAP |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
