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 past, re-key or work out formulas.

Key data from other sources can be combined with information held on Opera II to offer a complete enterprise reporting and analysis facility.

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 allows variable report styles

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 simply 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.