我使用了 Office Web Components (OWC),现在怎么办?
我有一个完全基于这些 Microsoft 技术的简单 Windows 应用程序:
- Office Web Components (OWC) 作为前端
- OLAP 服务的 OLEDB 提供程序 作为后端
OLEDB 提供程序读取来自多个 ODBC 源的数据并构建一个多维数据集文件,而客户端仅显示连接到此生成的多维数据集文件的 OWC ActiveX。用户可以使用多维数据集文件中的维度和度量,并创建图形或数据透视表、筛选数据、向下钻取、使用一些 MDX 语法...... OWC 支持的一切。
我的客户喜欢 OWC GUI 的简单性。其中存在可怕的限制(维度为 64K 行),但更糟糕的是微软完全放弃了 OWC 开发。看起来OWC 没有任何天然的继承者。我想有一个解决方案,以Excel作为前端,MSSQL Server作为后端。
我的优先事项是:
- 与 OWC 相同或相似的 GUI(Excel 适合)
- “可传输文件中的多维数据集”概念(?)
我现在应该使用哪些技术?
I have a simple Windows application entirely based on these Microsoft technologies:
- Office Web Components (OWC) as front-end
- OLEDB Provider for OLAP Services as back-end
The OLEDB Provider reads data from several ODBC sources and builds a cube file while the client simply shows OWC ActiveX connected to this generated cube file. The user can use dimensions and measures from the cube file and create graphs or pivot tables, filter data, drill-down, use some MDX syntax... everything that OWC supports.
My customer loves the simplicity of the GUI of OWC. There is terrible limitation within (64K rows in dimension), but worse is that Microsoft completely abandoned OWC development. It looks like there isn't any natural successor of OWC. I guess there is a solution with Excel as a front-end and MSSQL Server as a back-end.
My priorities are:
- same or similar GUI as OWC (Excel fits)
- "cube in a transportable file" concept (?)
What technologies should I use now?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论