Setting up Essbase VBA
SummarySetting up Essbase VBA
First of all, please excuse me if I am posting my query in the wrong place.
To get into it - I basically have an excel file where I pull data from our servers on to one sheet through Essbase, let's call this Sheet A, and I have members on this very sheet that can be changed through another sheet, say, Sheet B. Sheet B is just for users to be able to choose different members in order to generate reports as per their areas of interest. Without getting too much into detail, what I am trying to do is simplify this process through a macro. Currently, the user selects their choices on Sheet B and