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

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. 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 🙂

    (0) 
  2. 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

    (0) 

Leave a Reply