Start of Dimensional Modelling

View previous topic View next topic Go down

Start of Dimensional Modelling

Post  Anush1521 on 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

View user profile

Back to top Go down

RE:Start of Dimensional Modelling

Post  hkandpal on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top


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