Partial Results

[system]

You should define the Count as a measure in the universe.

Count(TRANSFER_ORBIT.tid)

There is a good post here, by Andreas, with regards to SQL VS report level aggregation, well worth a read if you are just getting started…

120×120 10.4 KB

The query runtime might be slightly higher if any, but you will save on the network traffic and the total rendering time within your report, thereby the total runtime will be way less! It should be mandatory to use a SQL aggregate function (such as SUM, AVG, MAX, MIN, etc.) for measures IMHO. For SAP HANA this is a MUST. Anyway, one uses SQL aggregate function in measures to force a Group BY in the generated SQL statement so that the DBMS returns already aggregated rows (meaning: fewer databas…

---

Mak 1 (BOB member since 2005-01-06)