Skip to Content
Author's profile photo Jörg Knaus

/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:


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Nikolay Evstigneev
      Nikolay Evstigneev

      Hi, Jörg!

      Many thanks for SE16H! Such a cool thing! I've already sent a brief tutorial to our consultants, now they have a unique opportunity of not making joins in Excel 🙂

      Author's profile photo Jörg Wulf
      Jörg Wulf

      Hi Jörg,

      great to know! I have stumbled across se16h before, but wasn't aware that we can use it on classic database as well.

      Thanks a lot for pointing out.

      Best regards - Jörg

      Author's profile photo Matt Fraser
      Matt Fraser

      I wasn't previously aware of SE16H, and it turns out it works in NW 7.01 (sp13). Shiny new toy -- er, tool -- to go play with!

      Author's profile photo Jörg Knaus
      Jörg Knaus
      Blog Post Author

      thats good news, I did not know this is already working from 7.01, i will add this to the blog! thanks!

      Author's profile photo Shao Rou Ming
      Shao Rou Ming