wilmott.com

I been trying to find decent excel examples or even books on MS Excel Cube Functions....Any good links or books in mind, pls... or even example files... Thanks

Dont know if this is what you want..

Thanks, i been to this page.... can you explain... ( i might look stupid to ask ) but really don't understand, I want , what are the relevent field....meaningCUBEMEMBER ( connections ???? , memberexpression ????How do i mapped it ??? any idonly reason to ask, its really neat stuff.. for modelling ALM

It shouldn't be that hard. The idea of implementing "cube" is to provide a way to work with database, in addition to the "query" method, and make the logic cleaner (of course there are cases query would be a better solution.).You can think of "cube" containing the aggregate data and readily avaiable to Excel. If you look into the diagram following "click to enlarge", you should be able to get a sense how it works. If you want to know why CUBE helps, try to think how you would do the same thing using the query way.Hope this helps.

Thanks Jjyu