here is some code implementing an (extremely) simple Olap system. At runtime the data is stored in a hashmap, MS Excel is used as a frontend.
Just extract all the files into one directory, open Excelsheet, enable macros, press ctrl-L and start playing around.
As I don't know much about (new)Lisp the code looks ugly. It just illustrates some ideas about implementing such systems. More challenging are consolidations between dimensions (aka rules). No time to finish this.
Files:
1) Olap.lsp contains the code
2) olap-demo-model.lsp contains a simple model.
3) olap-demo.xls contains the frontend. The approach makes more sense with models with more than 3 dimensions. These models are somewhat complicated in plain XL.
4) cube-demo.ldb The datastore. It is maintained automatically.
5) newlisp.dll This one is 8.4.0 but newer versions should work. Just replace the dll with a newer version.
You find the necessary files at
In case you have any questions just send me a mail to j dot kalsbach at t-online dot de.
Regards,
Jörg