Interview Question - Got Stuck

system · February 8, 2010, 2:59pm

aniketp:

… 1. Suppose we have a measure object called Amount and If I open that object and go to Edit, there the projection is Sum and also I am writing query like -
SELECT SUM(FINANCE.AMOUNT)
So what will be effect? Means does it make any sense or how it will behave?..

Please, see also this post on Measures: SQL aggregation & projection.

Andreas (BOB member since 2002-06-20)