Skip to Content

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

Do you already use the new SE16H Transaction?

see note (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



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:


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 Logged on to comment or reply to a post.