Products, Spreadsheet, Manual, Changes, New

Static products also are at disadvantage to Palo Spreadsheet. While offering the possibilities of storing data which is better than storing them in Excel they imply manual updating each time data changes or new data is added.  [...] Palo Spreadsheet offers in the web the well-known interface and handling of Microsoft Excel, but adds new features like the DynaRanges ( a dynamic formatting technology). The Palo Dyna Ranges offer the consequential method of combining spreadsheet calculation and formatting with dynamic database functions.  [...] As the Palo Spreadsheet is very much like Excel, users are able to work productively after a brief introduction, and to create reports or planning templates in the very same way they are used from Excel. The difference is that the database will be updated in real time as soon as data is inserted for example, if an element in a dimension is added.  [...]

A highlight of version 3.1 is the new Palo Spreadsheet. The Palo spreadsheet offers an Excel -like interface in a Web browser. With this development there is the capability to easily and efficiently access data in Palo OLAP through a web browser. Jedox consistently pursues with Palo the spreadsheet approach to create business intelligence applications.  [...] With this, business users won't require training to transfer existing Excel Reports and applications to the web and deploy new reports with their Excel know-how. In contrast to the traditional use of Excel, the combination of Excel + Palo ensures centralized data consistency in the spreadsheets.  [...] Another innovation is the Dyna-Ranges. For the first time when using this function it is possible to create structurally dynamic reports which when changes happen change into typical dimensions such as products or accounts thus saving the corresponding burden of adjustments and preventing transition errors.  [...]

Palo Spreadsheet contains a repository of reports and report structures. A convenient, hierarchically arranged directory is available to navigate within the report structure. The report structures may be linked with Palo master data (dimensions). when changes are made in Palo, navigation and report structure are adjusted automatically.  [...] Palo Spreadsheet offers the look and feel of a convenient desktop application but runs in your web browser. It is not necessary to install components (ActiveX, Java Applets) locally. Changes to reports, planning forms, dashboards or the application logics are immediately available to all users.  [...] Palo Spreadsheet is a Business Intelligence solution that allows many users to simultaneously access and process corporate data. As opposed to spreadsheets, Palo Spreadsheet stores data centrally.  [...]

Palo Spreadsheet. Palo spreadsheet offers the comfortable User interface and usability known within Microsoft Excel, but also adds new features such as Dyna Ranges (a dynamic formatting technology) which simplify creation of dynamic Reports and Planning.  [...] Palo File Manager.The Palo File manager allows you to set user rights for every file within the Palo suite in addition to the Palo Pivot and Palo Spreadsheet files. Palo File Manager offers every user and every application a data space to save files on. Hence, other information that may be included in a text doc or a PDF can easily be integrated into the Palo Application.  [...] Palo ETL Manager. Within the Palo ETL Manager all Data integration projects are created, supervised and launched. In addition to the definition of source and target, the transformation and loading of Data into a Palo OLAP Data bases, the Palo ETL Manager also creates monitoring reports of the launched Data integration processes.  [...]

Palo can be installed locally or in a company network. In network mode, all users work with the same data, changes in one spreadsheet are immediately seen by the other workstations in the intranet.  [...] In addition to providing a multi-dimensional data analysis of existing data, Palo allows the input of new data directly into the cube and facilitates both top-down as well as bottom-up planning. This important characteristic makes Palo different from relational OLAP servers.  [...] In Palo, this list is called a dimension. So basically a dimension is a list of categories that has some contextual relationship like a list of products, regions, customers or months. Above Excel list could be used in Palo to model a dimension with the name Products.  [...]

Palo OLAP Server also supports real-time modelling. This means users can modify hierarchies and even create new cubes on the fly in the familiar Excel environment. The database returns new aggregated values immediately. Real time modelling is a powerful simulation feature, that lets planners play out what-if scenarios involving changes in their corporate structures.  [...] When the data in the cube changes, all aggregated numbers change as well as all calculation results are instantly available real-time. The cubes do not have to be reprocessed. They are ready to use as soon as the users defines them.  [...] A spreadsheet supports maximum 3 dimensions. What do you do in Excel if you want to organize your data in more than two dimensions From experience we know that large organisations and enterprises usually require five to ten dimensions to store their data in a sensible and for them convenient way.  [...]

Palo OLAP Server 3.0 offers increased stability and performance, as well as new logical algorithms. It is a multi-user, high-performance data server application that allows workers throughout an enterprise to access, change and collaborate on BI data instantaneously.  [...] Palo BI Suite 3.0, backed by Jedox's own 25 strong development team, as well as a customer base of around 10,000 Palo enthusiasts, is the first commercial-strength, open source BI solution that combines the familiarity and productivity of a web-based online spreadsheet with the centralized server capacity typical of BI applications, together with multi-dimensionality (in-memory MOLAP).  [...] Palo Worksheet Server 3.0 is an Ajax- and Web-based online spreadsheet that combines the look-and-feel of a spreadsheet with state-of-the-art requirements for modeling, reporting, planning and analysis. Palo Worksheet Server has the ability to automatically adjust the structure of the spreadsheet according to the OLAP query results.  [...]

With Palo, business users in all departments can quickly adjust the key indicator system working in a familiar spreadsheet environment that allows them to focus on the subject matter at hand without being distracted by technical issues. This in turn helps companies immediately adapt to changing conditions.  [...] Palo also ensures consistent data and a single point of truth. Actual and budget data can be retrieved from almost any source system and, through centrally defined rules, be quickly consolidated to meaningful KPIs. If needed, the drill-through allows you to return to the data's origin.  [...] This transparency builds trust throughout an organization, eliminates unproductive discussions about the derivation of key figures, and allows steering bodies to focus on generating the strategic data that can help guide business direction.  [...]

One of the strengths of Palo's BSC is the ability to include soft factors that don't fit into standard KPI reporting by simply storing comments in data cubes. Palo makes it easy to manually enter data via Excel or the web. Other advantages include extremely fast data consolidation and easy system adjustment in response to changes in KPIs or corporate organization.  [...] In addition, Palo's Open Source architecture and low-cost licensing models make it possible to introduce the Balanced Scorecard with the smallest operational unit. In this way, you can use Palo to communicate and drive strategy execution throughout your entire organization.  [...] Integration of soft factors by manually filling in incomplete data and comment functions.  [...]

Created with Palo Spreadsheet.  [...] In order to not have to request adjustments in your application to be done by your IT department, Palo offers you a complete business intelligence platform which includes standardized reports, that can be created quickly out of Microsoft Excel by any given user.  [...]