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

While adding datedimension to cube it is showing three other dimensions. Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 6:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 25, 2013 6:33 AM
Points: 16, Visits: 9
Hi, i am newbie to ssas..
while i was creating a new project following instructions in msdn(using adventureworks dw db) and trying to add date dimension to the cube it is adding three other dimensions like shipdate,duedate,orderdate and actual datedimension doesnt appear in the cube.

pls help me understand why is it like that..what shuld it do to make it correct..


  Post Attachments 
dimensiondifff.gif (6 views, 170.48 KB)
Post #1432607
Posted Friday, March 22, 2013 1:28 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 2, 2014 1:47 PM
Points: 97, Visits: 363
Read up on datawarehousing and Denormalization, that will help.

Basically, you do have three different date values. This those dates are describing(dimension) the values in the fact table.


------------
:)
Post #1434498
Posted Monday, March 25, 2013 12:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 25, 2013 6:33 AM
Points: 16, Visits: 9
thanks ravi..
i got the issue...i have three date keys in fact table ..so when i am adding date dimension i am having 3 dimensions one for every foriegn key with date dim
Post #1434758
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse