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