YTD() in AS2005
- From: "Justin" <anonymous@xxxxxxxxx>
- Date: Thu, 16 Feb 2006 09:50:06 -0800
I'm trying to create a 'YTD Actual' calculated measure in AS2005. Using the
cube designer, under the Calculations tab I have the following code:
CREATE MEMBER CURRENTCUBE.[MEASURES].[YTDActual]
AS YTD([Measures].[Actual Value]),
FORMAT_STRING = "#",
NON_EMPTY_BEHAVIOR = { [Actual Value] },
VISIBLE = 1 ;
When I try to view the new member "YTD Actual' in the Browser, I get
"#VALUE!" in the field. On mouseover, i see an error:
"By default a year level was expected. No such level was found in the cube."
However I do have a Date dimension called "Date" with the following
structure:
Date
--Day
--Fiscal Quarter
--Fiscal Year
--FY
--Month
--Quarter
--Year
--CalendarYear
--Year
--Quarter
--Month
--Day
--FiscalYear
--Fiscal Year
--Fiscal Quarter
--Month
--Day
Any ideas?
.
- Prev by Date: Calculated Member in SQL 2005
- Next by Date: Re: Best practices for reporting: Replicated servers + data warehouse
- Previous by thread: Calculated Member in SQL 2005
- Next by thread: Design opinion?
- Index(es):