Knock knock! Anyone else also looking for handy illustrations of the hierarchy functions introduced with HANA 2.0? Well count me in then ;).
While trying hard not to write SQLs with recursive self joins to flatten a hierarchical data format presented...
Hello There!
Pretext :
The more we lean towards AMDP based HANA transformations compared to good old ABAP these days, the more we feel the need of having substitutes of reusable standard ABAP function modules & programs. One such instance is LAST_...
Hello There!
This blog post is an extension of one of my previous blog posts regarding replication of the methods in p_r_request into AMDP TRFNs in BW/4HANA 2.0 context. As already stated in the earlier blog post, a set of predefined parameters is ...
Greetings !
As promised in my earlier blog post, in this article I will be explaining the possibilities of using the view for external access or the external SAP HANA SQL view for aDSOs or the generated '8' view of aDSOs. The main idea is to gain op...
Hello there!
Context
In this blog post, I would focus on some of the key aspects of the generated view for external access or the external SAP HANA SQL View for aDSOs in BW/4HANA 2.0 by a use case scenario. The view is generated with naming conventi...
Hhave you tried SQL table function? Standard SQL query in Datasphere does not support all kind of functions. Switch to SQL script table function & you will be able to use most of the SQL functions you can use in HANA.
Hi ding.ye,Not very sure what exact information about the attributes you are looking for, but you can have a look at table : RSDBCHATR, this gives some info like if the attributes are time dependent or not, the F4 help order etc.Best Regards,Abhi
Hi Again,As you can see the column name in the script yourself, it is not schema name, but user name. But it is database user under which the statements are executed. If you are looking for application user which are executing the statements using da...
Hi Please try the following script for finding active sessions :select b.USER_NAME, a.WORKLOAD_CLASS_NAME, a.STATEMENT_STRING
from M_ACTIVE_STATEMENTS a
inner join M_CONNECTIONS b
on a.host = b.host
and a.port = b.port
and a.connection_id = b.connect...
Hi,We are not on S/4, but I don't think that would matter in this case (not 100% sure as I can't test). And we are on stand alone DMIS 2018_1_752 package in SLT terms. My guess is it could be due to some authorisation restriction you don't see the ot...
