Home >> IT Workplace >> Knowledge Management

CEO, Jedox GmbH

By: Kathleen Lau On: 22 Jul 2008 For: ComputerWorld Canada Creator

Jedox's Palo server stores and parses company data according to a number of dimensions, unlike the 2-D format of Microsoft's ubiquitous spreadsheet. How to synch, slice and dice

Quick Access

Enroll in a Tech Learning Space course 2010 Salary Calculator

Close X

Your Name:

Your E-mail:

Friend's Name:

Friend's E-mail:

Close X

| Text Size (+) / (-) | Views: 978 | Rating:

(0 votes)

Rate this article on a scale of
1 to 5 stars,5 being the best.

Close X

A Freiburg, Germany-based vendor is converting the ubiquitous Microsoft Excel spreadsheet from a singular two-dimensional application into an interface that presents global data fed from a multi-dimensional back-end.

Typically, when a user makes modifications to an Excel spreadsheet, those changes are applied only to that standalone version. However, Enterprise Spreadsheets by Jedox GmbH, a vendor of enterprise technologies for Excel applications, allows this data to be shared by all Excel users across the organization.

Your 3 complimentary guest passes have expired. Access to IT World Canada articles is for registered users only.
Please register now to gain FREE access to all of our premium Canadian technology content. If you are already registered, please log in here.

Sign up for our Newsletters

Tags: server, Enterprise Spreadsheets, spreadsheets, real-time, enterprise-wide spreadsheet

Page 1 | 2

Kathleen Lau is a senior writer with ITWorldCanada.com and ComputerWorld Canada since December 2006.In her role as senior writer, she covers broadly technology news and issues relevant to the Canadian en... more

Related Blogs

Comments (6)

MOLAP: by Martin Thompson 7/28/2008 12:00:00 AMPalo is MOLAP technology. There are APIs in multiple languages and a web-based Palo worksheet server. It does work in real-time which Microsoft Sharepoint doesn't do at this time (according to the article). It allows you to update data in the cube from worksheet cells.
Developer: by Jim 7/29/2008 12:00:00 AMWhat is new in this? Nothing at all. Cubes sound cool and Borg-like--but really, and rdbms is better. If you have data in a stict hierarchy and high usage--then OLAP and help with performance--but usually cubes are enormously inefficient and costly relative to traditional options. But they are the latest FAD! ' )
What Is Palo?: by info@grid-dynamics.com 11/1/2008 12:00:00 AMHere is some further info for you... Palo is an open-source (M)OLAP database. Palo is tightly integrated with Excel, and allows non-developers (business users) to do data analysis and reporting without the need to learn how to use additional, often complicated (OLAP) tools. They can do everything by themselves (no developer required) from within the familiar spreadsheet environment via a simple plug-in. Palo 'decouples' the data from the spreadsheet and stored it in a single, central (MOLAP) database, eliminating data segmentation and duplication issues. But users can still use Excel's graphing and other functions upon which they have come to depend. Palo 'frees' the user from the 2 dimensional limitations of the spreadsheet, and makes Excel truly multi-dimensional. No longer are users required to hard-code row/column headings and link sheets. Regarding Relational vs. OLAP databases and which is 'better'. Niether one is better than the other. They both have pros/cons and are meant for different applications.
Palo Details: by info@grid-dynamics.com 11/1/2008 12:00:00 AMPalo is an open-source (M)OLAP database. Palo is tightly integrated with Excel, and allows non-developers (business users) to do data analysis and reporting without the need to learn how to use additional, expensive, often complicated (OLAP) tools. They can do everything by themselves (no developer required) from within the familiar spreadsheet environment via a simple plug-in. Palo 'decouples' the data from the spreadsheet and allows it to be stored in a single, central (MOLAP) database, eliminating data segmentation and duplication issues. But users can still use Excel's graphing and other functions upon which they have come to depend. Palo 'frees' the user from the 2 dimensional limitations of the spreadsheet, and makes Excel truly multi-dimensional. No longer are users required to hard-code row/column headings and link sheets. Regarding Relational vs. OLAP databases and which is 'better'. Niether one is better than the other. They both have pros/cons and are meant for different applications.
CVS: by Wayne Deleersnyder 7/24/2008 12:00:00 AMI have to agree with Alex, it does sound like OLAP to me. Recently I began working with an OLAP system and it operates similar to what has been described in this article. However, I think I should give it a try anyways. Who knows, maybe it's something different?
OLAP by another name?: by Alex Anglin 7/23/2008 12:00:00 AMSounds to me like just about every other OLAP tool/suite out there. Perhaps they're doing something different (certainly being open source is a good start), but it's difficult to see how 'enterprise spreadsheets' are innovative in anything other than naming.

Name: (required)

eMail: (optional)
Your email address will not appear online and will be used only if the editor wishes to contact you personally for additional comments.

Comment:

Related White Papers

Multi-Entity Master Data Management: The 4th Generation of MDM - This white paper by Aaron Zornes, Chief Research Officer at The CDI-MDM Institute, outlines the requirements for integrating master data across. the great divide between "party" master data (customers, suppliers, employees) and "product", while providing an industry road map that highlights the planning assumptions necessary.

Secure Remote Access for the Distributed Business - It's a constant challenge to provide remote users, or teleworkers, with convenient access to enterprise information resources. This challenge can become a problem when teleworkers need remote access from almost anywhere, including a growing number of temporary work locations like airport Internet kiosks, WiFi hot spots, and even computers of friends and relatives. At the same time, enterprise information resources must be protected from attack from those same remote locations.

Branham Group Report - Deploying New Workloads to System z: Strategic Options (An Introduction to System z Cost Benefits and Supporting Solutions) - Where distributed systems were once viewed as potentially more cost effective and easier to manage than the mainframe

The dynamic warehousing infrastructure: Establishing a foundation to meet new information requirements - This white paper outlines the options and decision criteria for selecting the right components that define the extended infrastructure for dynamic warehousing. Complimentary with registration.

IT Service Management Solutions - This white paper offers concrete examples of how IBM IT Service Management helps companies optimize processes that extend across traditional IT silos, while delivering better service to the business – cost-effectively and efficiently.

more: White Papers