Re: Time Dimension Hiearchy Issue

Check your settings in the "Process", "Change Settings", "Dimension Key
Errors". I think the default converts to 'unknown', you may need to
customize it to discard the record since your date dimension is missing
a day... ?

Sal wrote:
Hi:

I have a time dimension hiearchy (Year - Month - Day) . Time dimension does
not have a record for 01/01/2007. When I fully process the dimesnion, the
hiearchy is fine and it shows 2007 (Year) - January (Month) - Day (Jan 2,
Jan3...).

When I process the dimesnion with "Process Update" which is the default,
the hiearchy shows as 2007 (Year) - Unknown (Month) - (Jan 2, Jan3...). It
shows Unknow instead of January . For all other months, it is fine.

I know 01/01/2007 is missing from time dimension but the rest of the January
dates are present. Even if there is a record in Fact table for 01/01/2007
which is not in time dimension, it should give an error when processing. Not
sure why it shows Unkown for the month of January. Please let me know.

Thanks

.

Relevant Pages

  • Re: How to work with a time dimension
    ... Create a time dimension using the wizard pointing to this table. ... could be the "best" way to make a 3 level dimension based on a SQL Date? ... > Regarding the sort order, you set the sort order on the attribute. ...
    (microsoft.public.sqlserver.olap)
  • Re: Blueprint Bloopers Quiz
    ... The whole title block is missing. ... I assumed that the vertical and horizontal centerlines in the side view meant that the round feature D was in the center of the 5'0" vertical dimension plus the in the center of the 5'6" horizontal dimension. ... Some prints note that the part is to be assembled with normal hardware without showing every screw and dowel location - but that note is missing so it could qualify as 20, ... If I were the teacher grading this quiz in class - I'd have to say you passed with flying colors - and would probably try to recruit you to draw up the next quiz. ...
    (alt.machines.cnc)
  • Re: Attribute relatioships not working?
    ... the time dimension and the fact table or the configuration of the time ... relationships I have setup in my time dimension. ... Calendar Semester ... followed the steps in the tutorial (Lesson 5: ...
    (microsoft.public.sqlserver.olap)
  • Re: How to Draw a Straight line?
    ... you'll always have to grant another dimension to develop the ... If you breach your brane you'll wind up with FTL signalling. ... the one time dimension. ... Why Spacetime? ...
    (sci.math)
  • Re: Left Join like link between Dimension and Fact table
    ... The idea with the unknown member is that, for each level of a hierarchy ... by 20 dimension tables. ... Let's say the fact table has a Sales measure. ...
    (microsoft.public.sqlserver.olap)