Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Calculations

Status
Not open for further replies.

UcfMike

IS-IT--Management
Mar 29, 2007
184
US
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
 
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

 
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
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top