Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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]") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum length of file name? | Excel Discussion (Misc queries) | |||
Chart Title - exceed maximum length? | Charts and Charting in Excel | |||
Maximum length of a number | Excel Worksheet Functions | |||
what is maximum row length in excel | Excel Discussion (Misc queries) | |||
maximum formula length | Excel Worksheet Functions |