CUBECELLMEMBER

M

Moises

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel and CubeCell Formulae 0
Analysis Cubes add-in for Excel 2003 - Two Problems 0
Excel 07 - converting pivot to formulas gives #N/A 0
Excel 2007 pivot table using analysis services cube as data source 0
Summary Worksheet. 1
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
number of months and days between two dates without approximation 3
Drop down list control value in vba 2

Top