D
Doug
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
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