Excel 2007 - Cube Functions Examples

RiskCapital · December 3rd, 2008, 6:41 am

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

jjyu · December 3rd, 2008, 11:57 am

Dont know if this is what you want..

RiskCapital · December 3rd, 2008, 12:19 pm

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

jjyu · December 3rd, 2008, 2:10 pm

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.

RiskCapital · December 3rd, 2008, 2:19 pm

Thanks Jjyu