I'm trying to do something with the CUBECELLMEMBER formula.
I write CUBECELLMEMBER("CUBE NAME", "DIMMEMBER)
On the DIMMEMBER I have a few dimensions like "Timeyymm.Tiempo.All
Timeyymm.2005.march"
What I'm trying to do is to make march or the month I'm working a variable.
I want the month to be a cell so I can change the cell and all the
information on the other sheets that I have created with cube analysis will
change.
This is in order to save time and to be sure all the tables I've created are
working with the same month
I wish to know how to do this, if it is possible to do it.