|
|
Opera
II XRL Excel Reporting Layer - Accessing Opera II Data Within Excel |
Opera II XRL
is an intuitive addition to the capabilities of Microsoft Excel.
This Excel reporting layer provides powerful and flexible access to the financial information
held within Opera II. With its flexibility, ease of use and drilldown
capabilities, Opera II XRL delivers fast and accurate information,
providing enhanced analytical power, assisting the decision-making
process.
|
 |
 |
Purpose-built functions allow dynamic access to data from the Opera
II financial and distribution modules to populate your Excel worksheets.
Nominal Ledger budgets, price lists and stock adjustments manipulated
in Excel can be written back into Opera II, removing the need to
re-key any information.
Comprehensive Enterprise Reporting and Analysis
Information extracted from Opera II to Excel can be combined with
key data from other corporate or external sources to offer comprehensive
enterprise reporting and analysis.
Automated Processes
Reports can be set up and run without your intervention using the
Opera II XRL Macro Builder. At the click of a mouse, different types
of data can be extracted from Opera II and processed in Excel.
Powerful Reporting Capabilities
Opera II XRL provides powerful but flexible reporting formats. It
includes the use of headers, details, subtotals and footer sections
to provide professional-looking reports, and it enables Excel's
diverse range of report styles, formats and printing options to
be applied to your business data.
Secure Access and Control
Opera II XRL supports the Opera II security features, protecting
your data by ensuring only authorised users have access to sensitive
company information.
Key Features
- Allows information
to be incorporated into Excel from the Opera II financial and
distribution modules
- Cross-company
reporting
- Cube analysis
for multi-dimensional reporting
- Report Designer
facilities
- Dynamic
write back facility for Nominal Ledger Budgets, price lists and
stock adjustments
- Progressive
drilldown from Excel to the live underlying Opera II transactions
Access to data controlled by Opera II security settings
|
| |
|
|
|
|
|
