ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CUBECELLMEMBER (https://www.excelbanter.com/excel-discussion-misc-queries/25180-cubecellmember.html)

Moises

CUBECELLMEMBER
 
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.


All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com