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
Results:
in realtime
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
hana: online!
analysis results: number of documents etc
hana studio:
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 |