Do you already use the new SE16H Transaction?
see note http://search.sap.com/notes?id=0001636416 (it turns out it works in NW 7.01 (sp13), and it also works for Classic Databases)
advantage here: we can also define JOINS!
just select group or total and you will get the distinct/total values instead of the detail lines
create join definition:
click on Arrow-Button under ‘Output’ to select output fields of join
Remember Transaction /NTAANA?
Transaction TAANA is a very useful transaction to analyze number of documents per year or per Document Type etc for Data Archiving Projects, Carve-Out analysis etc.
TAANA is able to compute the statistics in Batch so even in tables with millions of rows, we are able to analyse the results in a comfortable way.
i played around with this on hana, and of course i don’t need batch analytics, the results come in dialog in seconds.
see also note for some limitations: http://search.sap.com/notes?id=0001879808
select ‘create ad hoc variant button’
choose statistic fields like organisation values (salesorg, co area) or order type etc
non-hana: choose in the background for large tables
analysis results: number of documents etc
get a quick impression by using data preview/distinct values:
or use analysis for more details (select x/y axis):
in my version of web ide there was no preview feature, i think this is coming in Hana SPS9: