MS SQL Data Warehousing - YTD() in AS2005

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

YTD() in AS2005

Justin

2006-02-16, 1:23 pm

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?

Justin

2006-02-17, 7:23 am

underprocessable

Sponsored Links