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

Start of Dimensional Modelling

2 posters

Go down

Start  of Dimensional Modelling Empty Start of Dimensional Modelling

Post  Anush1521 Tue Sep 09, 2014 6:10 am

HI,

I need to start with Logical model of Dimensional Model. I have some existing reports. Using that I have identified some of the Dimensions and Measures.
Can any one please guide me through detail steps to move ahead.

Thanks,
Anush

Anush1521

Posts : 1
Join date : 2014-09-09

Back to top Go down

Start  of Dimensional Modelling Empty RE:Start of Dimensional Modelling

Post  hkandpal Tue Sep 09, 2014 10:02 am

HI,

Dimensional modeling uses the concepts of dimensions (context) and facts (measures).
Facts are typically numeric values that can be aggregated and dimensions are descriptors that define the facts.
You will have to see/understand what type of process is being captured in the reports. Then see if the dimension modelling will help you. Once you conclude that dim modelling is going to helo then identify the grains, the facts and the dimentsion.

thanks

Himanshu

hkandpal

Posts : 113
Join date : 2010-08-16

Back to top Go down

Back to top

- Similar topics

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