View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie-UTHSCSA Connie-UTHSCSA is offline
external usenet poster
 
Posts: 1
Default 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]")