Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


DM for project management: Where to put the project name?

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

DM for project management: Where to put the project name? Empty DM for project management: Where to put the project name?

Post  gbritton Mon Nov 18, 2013 10:26 am

I'm starting up a the DM cycle for project management at my company. The one item I can't figure out where to put is the project name. It's just a string that is unique by project. So...do I make a project dimension or include the name in a fact table? What are the best practices for this sort of thing?

gbritton

Posts : 6
Join date : 2013-11-18

Back to top Go down

DM for project management: Where to put the project name? Empty Re: DM for project management: Where to put the project name?

Post  ngalemmo Mon Nov 18, 2013 12:38 pm

There are no other attributes? Generally, Project would be a dimension with a lot more attributes than just the name.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

 
Permissions in this forum:
You cannot reply to topics in this forum