When your formula is copied and pasted into a cell, the error message
says:

"Text values in formulas are limited to 255 characters. To create text
values longer than 255 characters in a formula, use the CONCATENATE
function or the concatenation operator (&)."

Hopefully, you looked those two topics (CONCATENATE and the
concatenation operator) up in the help, but had problems figuring out
how to use them.

In an arbitrary area of your worksheet (I used B26:B30) enter the
following text in the cells

{[Fiscal_Period].[All Fiscal Period].[2009].[Quarter 1],
[Fiscal_Period].[All Fiscal Period].[2009].[Quarter 2],
[Fiscal_Period].[All Fiscal Period].[2009].[Quarter 3],
[Fiscal_Period].[All Fiscal Period].[2009].[Quarter 4].[June],
[Fiscal_Period].[All Fiscal Period].[2009].[Quarter 4].[July]}

Then, enter in some cell (B35 for me)

= B26 & B27 &B28 & B29 & B30

Your cubeset formula (wherever you had it) now becomes:

=CUBESET("RMDSCHED",B35,"[Multiple Items]")

That should work, though of course for me it throws a #NAME error
because I don't have RMDSCHED or any of these fields/parameters
defined.

Hope this helps.... :Bgr


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122447