4 ms·
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
by egeria_planning 8y ago
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 https://en.wikipedia.org/wiki/Dimensional_modeling
- benj111 8y agoYes I get that but A. All spreadsheets are multi dimensional, so why point it out. B. The blurb seems to conflate it with structured/typed data. I've tried reading the link, but it isn't making much sense at the moment, but doesn't seem to be using dimensions in the same way as I would expect a spreadsheet to?
- egeria_planning 8y agoA 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 https://en.wikipedia.org/wiki/OLAP_cube