HNHacker News
TopNewBestAskShowJobs

egeria_planning

233 karma · joined September 2, 2015

submissionscomments
egeria_planning··on Show HN: Egeria, a multidimensional spreadsheet for everybody
A normal spreadsheet is considered 2D. You could probably call Excel 3D if you count the multiple worksheets, but thats it. You cannot add the forth dimension. Dimenional model is mostly used in the databases right now. I agree, it is a bit more complex than normal spreadsheets. Here is an article which describes the concept a bit better: https://en.wikipedia.org/wiki/OLAP_cube
egeria_planning··on Show HN: Egeria, a multidimensional spreadsheet for everybody
- I am not really familiar with Anaplan. You could probably compare them, but as far as I understand Anaplan is a more specialized (planning) tool. - Egeria is a database itself. I use Sqlite as a key value store for persistence now. I will probably use Mongo in production. - I will provide a command line tool to automate import and export with ETL tools in CSV format first. A better integration with relational databases would probably come later on. - All formulas are computed on the server, so users don't run them. Only superusers/designers will be able to change formulas. A normal user will only be able to enter values and change metadata. The concurrency is implemented using locks and in-memory data structures on the server. Open two tabs on the same sheet and try changing values in one of the tabs to see how it works.
egeria_planning··on Show HN: Egeria, a multidimensional spreadsheet for everybody
The laptop screen is 2D, so you always see only one slice of the spreadsheet. You can choose which slice you see using the filters on the left.
egeria_planning··on Show HN: Egeria, a multidimensional spreadsheet for everybody
Multidimensional sheet is like a tensor (a multidimensional matrix). You have a cell for every coordinate combination of it's axis. You can imagine a 3-D sheet as a stack of 2-D sheets. You can also check this one out: https://en.wikipedia.org/wiki/Dimensional_modeling
egeria_planning··on Show HN: Egeria, a collaborative multidimensional web-based spreadsheet
Thanks. Just fixed it. :)
egeria_planning··on Show HN: Egeria, a collaborative multidimensional web-based spreadsheet
Thanks for testing. There are some misleading error messages. I will look into it. The problem was you did not "apply metadata" (from the tools menu) after creating a spreadsheet. If you have any ideas I would really like to simplify the UI. A spreadsheet gets much more complex with multidimensional data model. My idea was that people who are familiar with tools like TM1 or BPC would use the system to create planning solutions for their small and mid-size clients.
egeria_planning··on Show HN: Egeria, a collaborative multidimensional web-based spreadsheet
Thanks. This is my "side project".
egeria_planning··on Show HN: Egeria, a collaborative multidimensional web-based spreadsheet
Thanks for a complete list. I was not sure I could legally use the names on my website.
egeria_planning··on Show HN: Egeria, a collaborative multidimensional web-based spreadsheet
Multidimensional means every cell of a worksheet is associated with multiple dimensions like year, month, company, currency and so on. This implementation is not really a ROLAP. Instead of a relational database I use a document database for storing metadata. You can access formulas via context menu on cells (grey cells have formulas on them, white are input). The whole thing has become a bit complex. Some information is in the docs.
egeria_planning··on Show HN: Egeria, a collaborative multidimensional web-based spreadsheet
Some demos show the user authorization concept. Logins and passwords are in the description of the demo under "Login information". Admin account is always: admin/pass.
← PreviousPage 2 of 2