Getting right information on time out of ERP systems is crucial for Business Users in operating everyday business. Inquiry screens and Reports in these systems can only give them limited information.
Business users heavily rely on custom built reports and data extracts directly from the database using sql queris. In reality, sql querying is the most flexible and highly used method of data retrieval which is then used for preparing various reports and graphs by using Excel and similar products.
let's get to Oracle E-Business Suite:
Oracle E-Business Suite (EBS) is no different. Even though there are various reporting tools and solutions from Oracle Corporation, the real reporting is done by using the data fetched by sql queries. To be precise, majority of the Master Data Management, Configurations, Interfaces Monitoring, Reconciliations and Financial Reporting depend on use of sql queries.
The downside of using sql queries is the dependency it builds around people who knows how to run, database access and thereby security concern and importantly the performance impact on Oracle EBS.
ReportsXpress (Rx) is a simple, secure and effective solution. ReportsXpress lives and works inside Oracle EBS providing web interface for :-
- registering sql queries as Reports in Oracle EBS and to assign them to relevant Oracle Users.
- Oracle users to run the reports and to get output in various formats (Excel, XML, HTML, Text) in few clicks.
ReportsXpress brings down the development, deployment, on going changes and maintenance of everyday reports to 75% lower compared other Oracle tools like Oracle Reports, Discoverer and Analytics.
An example of time / cost saving:
For example, to develop a report to monitor Projects Expenditure Items Interface would take at least 5 days using Oracle Reports method (including sql query, report output layout, formatting, unit testing). Whereas, with ReportsXpress same report can be developed in 1 day. The reason being, all it needs is sql query. Rest of development steps are taken away.
Making most of your investment in Oracle E-Business Suite:
ReportsXpress execute the reports as concurrent requests in Oracle. It is optimum utilisation the immense power of Oracle database and E-Business Suite capabilities. It leaves a audit log of who has run which report, as well, it is better way of controlling the system performance (as opposed to making a direct sql query extracts from external tools).
It is 100% Secure:
Security is applies at all levels of ReportsXpress solution.
Reports are assigned to Oracle users using a multi-level innovative security model. It not only improves the security, and also reduces work for system administrators.
Data filers provided by ReportsXpress can be used in building sql queries to bind Oracle security rules like Multi organisation security (MOS), projects security, inventory organisations access control, etc.
ReportsXpress runs from a custom schema that has Read-Only access to Oracle modules. it is 100% read-only. Modules that are to be included into this reporting solution is controllable, for example, PayRoll module can be excluded from this solution if need be.
Make most of the Oracle People you have:
Writing and analysing SQL Queries is widely known skill than developing reports using tools like Oracle Developer, Discoverer or OBIEE tools. You can engange wide range of resources including Business Analysts, Functional Analysts, Technical Analysts, Database Administrators. No need to look for specialist skilled people anymore. This is one of the fundamental idea behind ReprotsXpress.
There are most things we build into ReporsXpress that you are going to like for sure, including performance controls, simplified user experience.
Please visit our ReportsXpress product page for quick overview and more details. Please contact us for a walk through session or if you want to access our live environments to try.
Thank you for your valuable time, we look forward to talk to you.
Kind regards
Jag
SkySys Consulting Australia
-- innovate to simplify --
No comments:
Post a Comment