I am trying to create column and row reports in MS Excel by calling data from the cube and populating the spreadsheet and I am looking for the best way to this (beyond brining a pivot table back from the cube). I want to create a custom function in Excel and then call the cube, but I do not...
I have built a model to perform what if analysis of about 150 different scenarios with ~20 varibles that change. I want the model to cycle through my scenario, copy and paste the output to a spreadsheet, reset itself and go to the next scenario, repeating until it gets to the final scenario...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.