Date Calculations

[UcfMike]

Calculations like YTD, that have to be query items in the report. Is it easier to create them in the database or in the Framework Manager?

Opinions Wanted

 

[blom0344]

For a relational model the easiest solution is to have a database view on the date/time table that stores columns relating to YTD and such. You can then define different grain for YTD calculations, like having a YTD based on whole months and one for the day-level.

Ties Blom

 

[UcfMike]

What about for a dimensional model?

I'm worried about complexity and speed on the FM side. I know these calculations are pain if they're done on the report side.

Can you think of any reason why you would want to take a dimensional model and flaten out in FM?

thanks

 

[blom0344]

Extremely roughly division:
Dimensional model is great for analysis, relational (flattened) is much easier for a casual user and for pure , fixed management reports

Ties Blom