4 ms·
Show HN: Egeria, a collaborative multidimensional web-based spreadsheet
- ocdtrekkie 11y agoWhen I launch the demo, it asks for a login and password. Obviously, I don't have a login and password for this site.
- egeria_planning 11y agoSome 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.
- ocdtrekkie 11y agoI did not see that at all in my 'I didn't read the whole page' exploration, and ended up not really studying further because of it. That might be UI feedback for you, I guess. I'll take another look when I'm at my desk.
- wingerlang 11y agoSame here, but considering we (I, at least) found the "launch demo" via a dedicated demo-page it was quite obvious to me that there would be passwords on that page, and there were. I did get turned off from it though, so I guess the UI comment stands.
- ocdtrekkie 11y agoI didn't read. It's fair to blame me for that, but a lot of potential customers or users won't read. If I had a specific suggestion, I'd say to move the Launch Demo button to right above the Login info subheading. So it's hard to click it without noticing the login section.
- wingerlang 11y agoI didn't read at first either, and I was burned just like you. So I totally agree with the suggestion, in case my reply indicated something else.
- fiatjaf 11y agoThis may be something the world is needing for a long time. Who made it? Why?
- egeria_planning 11y agoThanks. This is my "side project".
- fiatjaf 11y ago"There are several similar solutions offered by very large companies." What? Where? How similar? (I'm not critizing the copy, I'm just asking for more explanation, since I don't know anything about very large companies).
- cgio 11y agoOracle (Hyperion stack), IBM (Cognos TM1 and maybe Controller), SAP (BPC), Infor (PM) are the big ones. Also, SQL Server Analytic Services is in a similar space but mostly from a BI, read-only perspective. Smaller include Jedox Palo (GPL but with a weird openness history) and many other vendors (e.g. Anaplan etc.)
- egeria_planning 11y agoThanks for a complete list. I was not sure I could legally use the names on my website.
- cgio 11y agoNo worries. I played around a little, given that I have done implementations with all the systems I mentioned above, and it looks interesting at first sight. I would have to look into it in more detail. By the way, I tried to create a new spreadsheet and it creates it (test) but when I try to view it, it gives me an error. It looks pretty easy for someone who knows what they are looking for, but others would be confused.
- egeria_planning 11y agoThanks 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.
- fiatjaf 11y agoI don't understand it. When you said "multidimensional" I thought of it as a database that could be displayed as different spreadsheets from different viewpoints, but in the examples I cannot see the multidimensionality, nor where is the data coming from on each calculation, I don't see formulas anywhere also; and I can edit the values manually. I am probably missing something.
- steventhedev 11y agoMultidimensional in this case refers to OLAP cubes. In other words, it's a relational database with a star schema. The formulas in this case are built in the "metadata editor". The expectation is that a data scientist would build the tables, and then pass it off as an analysis tool to the MBA types. It can be really unintuitive if you've never seen these types of dashboards before.
- speedkills 11y agoSpeaking of OLAP, is that the old Microsoft OLAP demo database data I see, the one with all of the bicycle shops?
- fiatjaf 11y agoThank you. Considering this (and my experience in the demo), this is probably not the nice tool I was imagining.
- cgio 11y agoDon't know about the specific implementation, but OLAP does not necessarily mean relational with a star schema. There is a distinction between ROLAP (Relational OLAP, which is what you describe, plus snowflakes), MOLAP (Multidimensional OLAP, which is true multidimensional, as in Essbase or TM1) and HOLAP (Hybrid OLAP, which is a combination of ROLAP and MOLAP as in SQL Server Analytic Services.)
- egeria_planning 11y agoMultidimensional 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.
- chm 11y agoYou can also use Egeria as a free and easy-to-use alternative to expansive commercial budgeting and planning software. I assume you meant "expensive", but in this case "expansive" works fine if you consider that a disadvantage and your product is more focused. Check it out :) EDIT: I see there are a handful of typos and incorrect/unclear wording. I'm writing you an email with the corrections I would make.
- egeria_planning 11y agoThanks. Just fixed it. :)
- rizky05 11y agoIs this open source ?
- mrmondo 11y agoIs it open source and can it be self hosted?
- pandatigox 11y agoSays here: http://egeria.rocks/downloads http://egeria.rocks/downloads
- mrmondo 11y agoAh, I see so no, it's not open source - http://egeria.rocks/LICENSE.TXT http://egeria.rocks/LICENSE.TXT
- dfurlong 11y agotypo speadsheet