Creates a calculated set of members or tuples by sending a set expression to the server’s cube, which generates the set and subsequently relays that set to Microsoft Office Excel.
Want to give some magic to your Excel modeling? Then its time to call Galdalf and seriously learn about Excel Cube functions! One of my favorite Excel functions to do business modeling are Cube functions. They act as a more efficient replacement for SUMIFS, GETPIVOTDATA functions that serve to sum aggregated results with various filters […]