Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CubeSet Excel 2010 Question
Hello all,
At long last my company has decided to upgrade from 2000 to 2010. Now that I have a program written in the last 10 years I can start to look at some advanced features. Forgive me if I do not use the right terms here. I have a data cube from SQL server. I have built a pivot table on this and turned my table into formulas. What I need to do is allow users to build custom lists on a sheet (they may need more than one list) and have this custom list passed into the Cubeset. What I have now in my field list =Cubeset("Server",,"{[Dim Store]. [Dim Store].&[1234], [Dim Store].[Dim Store].&[2345]}","(MyName)") What i need is for users to type different store numbers in a sheet and have that range passed through to the cube. Is there no way to say [Dim Store].[Dim Store].& [A12:A15] Any ideas or help would be great. I have spent several days poking around looking for this. Maybe I am using the wrong search terms. Thanks in advance Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I expand a funtion's maximum character length? eg CUBESET | Excel Worksheet Functions | |||
excel 2010 question regarding determining the last row | Excel Programming | |||
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 | Excel Programming | |||
Can any help with CUBESET function? | Excel Worksheet Functions |