Poborsky 发表于 2013-1-6 00:52:40

仁科提供的常用报表工具

<div id="cnblogs_post_body"> The main reporting options that PeopleSoft offers are:
ApplicationDescriptionPS/nVisionAllows you to import information directly from your query into predefined Excel layouts. Use PS/nVision for data analysis.PS/QueryOnline ad hoc reporting tool. Can be used with various report for-matters.Crystal ReportsVersatile report formatter from Crystal Decisions Software. Using PeopleSoft’s Open Query, Crystal accesses all database platforms supported by PeopleSoft.ExcelQuery Link provides the ability to send queries from Query to a Mi-crosoft Excel spreadsheet. Your data is sent directly from your query into a predefined spreadsheet layout.SQRYou can copy the Query-generated SQL statements into an SQR re-port using copy/paste commands. Use SQR for procedural logic and to update database tables.OLAPOnline Analytical Processing is used to create reports and to ana-lyze data. OLAP can be used to create predefined report templates, for ad hoc analysis, and for what-if scenarios.
    PeopleSoft中提供的报表工具如上表所示。其中我使用的最多的是SQR和Qurey,目前正在看PS/nVision的介绍。


下图为仁科报表工具的架构图
http://pic002.cnblogs.com/images/2012/368428/2012101617125365.jpg

PS:好久没有更新了,最近刚进项目,学习中-----
页: [1]
查看完整版本: 仁科提供的常用报表工具