XL Cubed for SAP Business One solution

XLCubed for SAP Business One provides the multi-dimensional and financial consolidation requirements for either single or multiple group companies that organisations demand.

XLCubed for SAP Business One makes an immediate positive impact. Fast complex multi-company reports direct in Excel with Drill-Down, Drag and Drop on a true OLAP database are enabled. XLCubed for SAP Business One is a cost effective solution that allows you to have one reporting tool covering financial and management reporting in a familiar Excel environment.

Analysis Services

Delivering Cubes with a complex data structure is difficult and the SAP Business One Data Structure is complex, large and evolving. Analysis Services objects accessed via the “XLCubed Cube Builder” provide a full OLAP (On-Line Analytical Processing) environment integrated to Microsoft SQL Server 2000 and 2005.

What End Users want from SAP Business One?

Primarily end users want a return on investment through better business functionality and, critically, ease of use. Delivering Reporting and Analytics to drive the business also features heavily in the ROI calculation. SAP Business One already provides best in class business functionality and extensibility pound for pound. XLCubed for SAP Business One delivers end user reporting through OLAP cube(s) in world class front end technology – XLCubed Excel Edition and XLCubed Web Edition.

Where do end users want to work?

They want to work in familiar environments, where they can be productive with minimal training and maximum flexibility. Microsoft Excel is the world’s most popular business intelligence tool. XLCubed Technology for SAP Business One is about bringing data and processes to these familiar environments starting with Microsoft Excel.

XLCubed Excel Edition

XLCubed’s Excel Edition turns the world’s most popular desktop tool into an enterprise class reporting and analytics solution. Analyze data with full OLAP capability, format reports, create Dashboards and monitor KPI’s. Distribute them to any Excel user or publish them to the web without ever having to leave Excel.

Why Excel Add-ins?

Research carried out in the OLAP Survey showed that organizations deploying a full function third party Excel Add-In, such as XLCubed, as part of their OLAP project created a better return on investment.

It’s one thing to be able to connect to a cube and drill down through it, but what if I want to integrate Microsoft Excel functions or add some calculations and then distribute it?

If you want to build specific reports (Formula or Grid) you can use the Report Designer dialogue to construct sophisticated reports using an intuitive interface. Want to change the report? Simply drag and drop the dimensions where you want them. Apply advanced filters and ranking with sorting. Build member sets. Get the information that you want or your users have requested.

XLCubed Web Edition

The XLCubed Web Edition allows you to publish XLCubed OLAP reports created in the Excel Edition to the web. It is more than just a publishing tool. It lets you organize your reports on the web and provides OLAP functionality in your browser – no Java, no ActiveX and no Excel on the Server.

Ad-hoc Reporting

Publishing is a key requirement, but reports also provoke questions as well as answering them. AdHoc reporting allows those questions to be answered directly.

You can save your AdHoc report in the web repository and for those who want to take data back into Microsoft Excel you can even export the report back to that environment either as a live XLCubed Grid oras straight numbers.

Writeback

Writeback allows you to change the number in a cube (depending on your cube design)and is specially powerful in a cube environment that is optimized for writeback.