6 ms·
Could you explain what you mean by multidimensional. My first thought was that all spreadsheets are at least 2D, some like SC are explicitly 3D, but the write
by benj111 8y ago
Could you explain what you mean by multidimensional.
My first thought was that all spreadsheets are at least 2D, some like SC are explicitly 3D, but the write up seems to suggest something different?
"Multidimensional data model: worksheets are organized by business entities (SKUs, departments, years, months, scenarios and so on). The data is stored in a more structured way which has many benefits like simple and robust computations across multiple worksheets
"
- egeria_planning 8y agoMultidimensional 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
- egeria_planning 8y agoThe 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.
- abathur 8y agoThe tutorial videos were useful for putting a handle on what it means.