/NSE16H, /NTAANA, or Hana Studio, which way to go? Instant Database Analytics

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: