While adding datedimension to cube it is showing three other dimensions.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » While adding datedimension to cube it is...

While adding datedimension to cube it is showing three other dimensions.

Rate Topic

Display Mode

Topic Options

Author

Message

mahesh.gupta 55272

Posted Tuesday, March 19, 2013 6:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 25, 2013 6:33 AM
Points: 2, 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

//Ravi

Posted Friday, March 22, 2013 1:28 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:13 AM
Points: 77, Visits: 255

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

mahesh.gupta 55272

Posted Monday, March 25, 2013 12:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 25, 2013 6:33 AM
Points: 2, 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 »

Permissions