Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Why can´t I see all dates when creating attribute relationship the "adviced way"? Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 6:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 4, 2013 5:12 AM
Points: 6, Visits: 71
I have a problem with my time dimension, I can only see some of the dates, why is this?





When I set my attribute relationship like this.


Result:


When I set my attribute relationship like this:


Result:


This last picture is what I am after, but I thought that the first way was the proper way for performance..


  Post Attachments 
hierarchy.PNG (50 views, 17.45 KB)
hierarchy_browser.PNG (49 views, 5.03 KB)
hierarchyCorrectResult.PNG (48 views, 7.10 KB)
hierarchyFailedResult.PNG (48 views, 3.65 KB)
hierarchyResultCorrect.PNG (48 views, 7.67 KB)
hierarchyResultFaile.PNG (48 views, 5.15 KB)
Post #1443211
Posted Monday, April 29, 2013 10:41 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 12, 2014 10:23 PM
Points: 53, Visits: 911
Even though I was taught first way, I always use the second way as well :) as I have data consistency issue with the first way in many cases. Your data need to be perfect to make first way to work, otherwise better use the the second. By perfect I mean no nulls, no unclean data, all rows are populated with correct data.. I assume you are having some nulls or data inconsistency...
Post #1447869
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse