How do I expand a funtion's maximum character length? eg CUBESET
 

A function's maximum character length is limited to 255. However, our cube
has multiple date layers [year, quarter & month]. We are in the 11th month
of the fiscal year. Therefore, I am max'ing out the character length
maximum. Any ideas of how I can get around this? Here's what I need to
retrieve.

=CUBESET("RMDSCHED","{[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].[All Fiscal
Period].[2009].[Quarter 4].[July]}","[Multiple Items]")

How do I expand a funtion's maximum character length? eg CUBESET
 

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

How do I expand a funtion's maximum character length? eg CUBES
 

Thanks! This worked. We also read that a text only cell has a 37,000+
character limit. Therefore, we could type the text in cell A1

{[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]}

and the function would be written thus

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

Your explanation spurred my workmates to think outside the box. Thanks!
Connie


"jamescox" wrote:


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

Hi James,

I have also formula like this connecting to DB cube:

=EPMOlapMultiMember("CCS4792508,CCS4792509,CCS4792 534,CCS4792540,CCS4792544,CCS4792537,CCS4792542,CC S4792546,CCS2822501W,CCS4792547,CCS5162501,CCS5162 502,CCS2862501W,CCS4452501W,CCS4450701W,CCS1882501 W,CCS1892501W,CCS3032701W,CCS3092501W","000;002;00 1","[COSTCENTER].[PARENTH1].[CCS4792508]","[COSTCENTER].[PARENTH1].[CCS4792509]","[COSTCENTER].[PARENTH1].[CCS4792534]","[COSTCENTER].[PARENTH1].[CCS4792540]","[COSTCENTER].[PARENTH1].[CCS4792544]","[COSTCENTER].[PARENTH1].[CCS4792537]","[COSTCENTER].[PARENTH1].[CCS4792542]","[COSTCENTER].[PARENTH1].[CCS4792546]","[COSTCENTER].[PARENTH1].[CCS2822501W]","[COSTCENTER].[PARENTH1].[CCS4792547]","[COSTCENTER].[PARENTH1].[CCS5162501]","[COSTCENTER].[PARENTH1].[CCS5162502]","[COSTCENTER].[PARENTH1].[CCS2862501W]","[COSTCENTER].[PARENTH1].[CCS4452501W]","[COSTCENTER].[PARENTH1].[CCS4450701W]","[COSTCENTER].[PARENTH1].[CCS1882501W]","[COSTCENTER].[PARENTH1].[CCS1892501W]","[COSTCENTER].[PARENTH1].[CCS3032701W]","[COSTCENTER].[PARENTH1].[CCS3092501W]")

I tried following:
=EPMOlapMultiMember(C10,"000;002;001",D10)
But I am getting an #value error.
In C10 I put part before "000;002,001"
and in D10 the part after.

Could you advise me please?
Many many thanks in advance,

Tomas.