Simple Calculations

daredevil at 14h43
17
Aug
2010
Simple Calculations

Where should I place simple calculations such as A/B where A and B are fields in the database. Should the calculation exist in the database as a separate column or should it be a calculation in the report. What are the pros and cons of both approaches? What are the variables that could help us decide?

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
time calculations
I was looking for the best way to create time calculation in my cubes. Besides using the "add time intelligence" option of BIDS (I use 2008) I found arounf a different technique which implements a "shell dimension". Pro of such
inventory snapshot - GMROI calculation
Hoping someone can advise on this. I've got the DW Toolkit book and it's been invaluable in setting up a simple retail sales fact table with conformed dimensions. We've now moved on to chapter 3: inventory and our users have requested a stock snapshot,
Simple Smilies
Pretty classical smilies. Hope you like them!
Happy Birthday Simple
Happy Birthday Simon!! Hope You Have A Great Day With Your "New Build". Didn't Know What To Get Ya, Since You've Been Busy Buying Yourself Everything!! Enjoy!! Larry
Photoshop Sig Tutorial Pt2. Simple Abstract Signature
Some links to good abstract backgrounds. http://www.brusheezy.com/Brushes/1150-Keep-Dreaming-Volume-43 Gives it a good background 1.Size i use is 5 inches by 1.5 inches. 2.Load your abstract brushes.Look at 1st tutorial if you don't know
Forums from same category
See also
more_less
Informations

4 Replies For the topic :
"Simple Calculations"

This topic has been viewed 1178 times.

Last message :
17/08/2010 at 14h43 by "daredevil"