Fact to Dimension Join (Best Practice)

View previous topic View next topic Go down

Fact to Dimension Join (Best Practice)

Post  BIDW on Thu May 07, 2015 5:13 am

I have a table which records the date/time when an employee uploads a specific document type such as Information Form, Request for Advance Form and so on. I have a dimension table which will list down all the available document types/forms in the system.

I now have a requirement to prepare a report which will list down for each employee all document types with a tick mark based on if they have uploaded.

The problem is I only to get see document types if the employee is uploaded them. How can i see all document types for an employee even if they have not uploaded them.

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re:Fact to Dimension Join (Best Practice)

Post  hkandpal on Thu May 07, 2015 11:44 am

Hi,

If you need the list of document printed for each day by employee or you just need the document types per employee only once.
if it is the later then try doing a Outer join between the dimension and the fact table.


thanks

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Fact to Dimension Join (Best Practice)

Post  BIDW on Sat May 09, 2015 4:28 am

What is the best practice as this would be a very common theme in dimensional modelling.

We would show the dimension value irrespeticve of the fact occurrence.

Thanks

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Fact to Dimension Join (Best Practice)

Post  ngalemmo on Sat May 09, 2015 12:33 pm

As hk stated, you do an outer join.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Fact to Dimension Join (Best Practice)

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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