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

C

Connie-UTHSCSA

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]")
 
C

Connie-UTHSCSA

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top