SAS Add-In For Microsoft Office(SAS与微软OFFICE的外接) 发表评论(0) 编辑词条

（SAS 外接微软Office）SAS Add-In For Microsoft Office 
（与微软Office的集成） Microsoft Office integration 
（SAS企业级商业智能服务器）SAS Enterprise BI Server

SAS Enterprise BI Server使用户能够直接利用SAS从微软Office中进行数据访问、报告、分析等行为。在到达预期的结果后，用户可以很容易的将这些Office文档分发给使用微软Office的相关决策者。由于数据是集中保存，IT部门可以监督和验证这些用于分析和决策的报告所使用的数据。

允许所有的Microsoft Word，Excel和PowerPoint用户访问经过批准的企业数据，并延长分析能力。
通过提供给该组织中更多的用户以标准的数据和数据分析的能力，使得决策有更大的一致性和稳定性。

与Microsoft Word, Excel and PowerPoint集成。
访问和查看数据集中的企业数据源。
使用本地Office脱机功能，查看和修改现有的分析报告。
从企业中央IT部门定义的数据源单击刷新数据。
减少数据源，通过浏览器对话，只浏览有关数据。
使用数据周期的原理解决Excel的行限制问题。
将由SAS分析处理所衍生出的资料嵌入到Word, Excel 和 PowerPoint中。
使用Excel功能上显示的数据，但有能力始终获取最新的信息观点。
在一个数据表或文件中运行多个任务或者处理多个数据源。
操纵数据透视表来说明各种来源的多维数据。
传递到Word，Excel或PowerPoint图形结果直接为ActiveX，GIF，JPEG或PNG格式。
自动刷新图表（并重新运行任何疑问和适用有关过滤器），以确保最先进最新的信息可用。
启用本机上使用微软Office的功能需求的嵌入式成果分配。
用户可以控制报告的篇幅。

SAS Add-In For Microsoft Office

Microsoft Office integration
SAS Enterprise BI Server enables users to transparently leverage the power of SAS data access, reporting and analytics directly from Microsoft Office. After arriving at the desired results, they can easily distribute the Office documents to relevant decision makers using native Microsoft Office functionality. Because the data is maintained centrally, IT can oversee and validate the data used for analyses and reports for confident decision making.
• Allows all Microsoft Word, Excel and PowerPoint users access to approved enterprise data for extended analysis capabilities.
• Provides greater consistency in decision making by delivering standard data and SAS Analytics capabilities to more users in the organization.
Features
• Integration with Microsoft Word, Excel and PowerPoint.
• Access and view data in any centrally IT-defined enterprise data source.
• View and modify existing analytic reports offline with native Office functionality.
• Refresh data at the click of a button from any central enterprise data source defined by IT.
• Reduce the data source being viewed via an intuitive Filter dialog, so users only browse pertinent data.
• Cycle through data that exceeds the row limitations of Excel.
• Embed SAS derived intelligence and information into Word, Excel and PowerPoint.
• Use Excel capabilities on the data displayed but have the ability to always access the latest view of information.
• Run multiple tasks with different data sources within one worksheet or document.
• Manipulate pivot tables to illustrate multidimensional data from various sources.
• Deliver results as RTF (Rich Text Format), HTML with Word, raw data (CSV), or HTML into Microsoft Office for native functionality.
• Deliver graphics results directly into Word, Excel or PowerPoint in ActiveX, GIF, JPEG or PNG formats.
• Refresh tables and charts automatically (and rerun any queries and apply relevant filters) to ensure the most up-to-date information is available.
• Enable distribution of embedded results on demand using native Microsoft Office functionality.
• Users can control the size of report to be returned. An intuitive prompt is presented whenever the result set is over the size limit that has been specified by the user.
For a complete list of key benefits and features, refer to the SAS Add-In for Microsoft Office fact sheet.