Pegasus Opera II Accounts Software Specialists and Developers - Systel Ltd
Pegasus Certified Partners - Pegasus Opera II Accounts Software Resellers

 

 

XRL

Talking to Excel

 

Using XRL (Excel Reporting Layer), Opera II allows Microsoft® Excel access to live data at the click of a mouse, so users don’t have to copy and paste, re-key or work out formulas. Key data from other sources can also be combined to offer complete enterprise reporting and analysis.

 

Budget information, stock adjustments and price lists manipulated in Excel can be written directly back into Opera II. Reports can be set up and run without intervention, using the Opera II XRL Macro Builder.

 

XRL includes the use of headers, details, subtotals and footer sections, so you can apply Excel’s diverse range of report styles, formats and printing options to all your business data. XRL is a powerful and flexible tool that can change the way you do business.


The Cube Analysis utility provides a simple and extremely effective insight into summarised business operations and trends. Users can select Opera II data to form the dimensions of a cube using a simple drag and drop technique.These results can then be manipulated further, providing greater insight, including drilling down and displaying data trends visually with the help of the Charting Wizard.