Relationship between AMO AttributeType and ADOMD.NET LevelTypeEnum -
09-21-2006
, 08:20 AM
The relationship between the 2 enumerations seems to be problematic when it
comes to time dimension levels. The following pairs provide good mapping (AMO
on the left, ADOMD.NET on the right):
Years -> TimeYears
HalfYears -> TimeHalfYears
Quarters -> TimeQuarters
Months -> TimeMonths
Weeks -> TimeWeeks
Days -> TimeDays
Hours -> TimeHours
Minutes -> TimeMinutes
Seconds -> TimeSeconds
UndefinedTime -> TimeUndefined
However, various other time types that are used in AMO AttributeType
enumeration and can also be entered by the user in Business Development
Studio do all map to Regular in ADOMD.NET LevelTypeEnum. They include the
following: Date, FiscalDate, FiscalHalfYears, FiscalMonths, FiscalQuarters,
FiscalWeeks, FiscalYears.
This is a problem for an application that displays periodicity type to the
client for creation of various time series sets.
Is this a bug that's going to be addressed in the near future?
Stan |