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 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!

/wp-content/uploads/2014/12/se16h_604885.jpg

just select group or total and you will get the distinct/total values instead of the detail lines

create join definition:

/wp-content/uploads/2014/12/se16h_join_604889.gif

click on Arrow-Button under ‘Output’ to select output fields of join

Results:

/wp-content/uploads/2014/12/se16h_result_604890.gif

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

/wp-content/uploads/2014/12/taana_604836.gif

select ‘create ad hoc variant button’

/wp-content/uploads/2014/12/taana2_604837.gif

choose statistic fields like organisation values (salesorg, co area) or order type etc

/wp-content/uploads/2014/12/taana3_604883.gif

non-hana: choose in the background for large tables

hana: online!

/wp-content/uploads/2014/12/taana4_604884.gif

analysis results: number of documents etc

hana studio:

get a quick impression by using data preview/distinct values:

/wp-content/uploads/2014/12/hana_studio_604891.gif

or use analysis for more details (select x/y axis):

/wp-content/uploads/2014/12/hana_studio2_604895.gif

in my version of web ide there was no preview feature, i think this is coming in Hana SPS9:

/wp-content/uploads/2014/12/hana_web_ide_604904.gif

Assigned Tags

      5 Comments
      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

      nice