/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:
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 🙂
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
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!
thats good news, I did not know this is already working from 7.01, i will add this to the blog! thanks!
nice