dbTalk Databases Forums  

Relationship between AMO AttributeType and ADOMD.NET LevelTypeEnum

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Relationship between AMO AttributeType and ADOMD.NET LevelTypeEnum in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stan Kondrat
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.