About david_j_hays

david_j_hays · 11-21-2023

We are running WebIntelligence SAP BusinessObjects BI Platform 4.3 Support Pack 1 Patch 12. I have a Snowflake database schema in which I have created Procedures and Functions in addition to my Table/View objects. When I try to access these in IDT, I...

david_j_hays · 01-30-2023

For Sarbanes Oxley auditing I audit DML statements to SAP-owned data by users other than SAPSID. This a monthly report of this activity is almost always empty but recently I discovered that the SQL Statement "MERGE DELTA OF...." executed by user syst...

david_j_hays · 12-09-2022

As I attempt to implement procedures to safeguard our HANA Data, I have run into a challenge in which I need to prevent ad-hoc logins to HANA using the SAP Data Owner (SAPSID) account. This is the only account in the database with privileges that all...

david_j_hays · 01-24-2022

Hi Patrick, We are actively preparing to upgrade our Business Objects WebIntelligence clusters from 4.2 (SP9,Patch1) to 4.3 (SP1,Patch10). We have multiple non-production clusters, and one production cluster - and our preferred method is / has alwa...

david_j_hays · 07-23-2021

Hi, After applying a support pack to my system, I am attempting to follow the guidelines of Knowledge Base Article 1794297 - Secondary Indexes for S/4HANA and the business suite on HANA. I ran SHDB_INDEX_ANALYZE without issues, and captured a va...

david_j_hays

well done, that fixes my issue 

david_j_hays · 11-22-2023

Hey you are right! - even though a UDF doesn't appear in my connection panel, I can apparently use one without issue in at least one scenario. Below I created a Derived Table that uitilizes a UDF that just switches the values of 2 columns as in "las...

david_j_hays · 11-22-2023

It seems like behavior in IDT varies with the particular database platform behind the Universe Connection. I tried the same test with an Oracle DSN, and I am able to expose both Functions and procedures. Below, P_REVERSE is a pl/sql procedure, REV...

david_j_hays · 08-07-2023

Have you looked completely into where the stored procedure has actually been activated? is it in your HANA User Domain or something like _SYS_BIC ? if this is the case you might try something like :EXEC "_SYS_BIC"."My-Schema/My-Procedure"@HHLink-da...

david_j_hays · 08-07-2023

Hi, YL Chen, I've edited this response yet one more time. I did not read your post carefully enough, sorry. So it looks as though you actually have confirmed connectivity using I assume Oracle Transparent Gateway to HANA. The fact that you can query...

User Statistics

User Activity

Are Database Functions in Snowflake Database visible to Information Design Tool ?

Why does MERGE DELTA OF produce an UPDATE DML statement against the table being delta-merged?

How to prevent adhoc logons to SAP HANA using SAPSID

Can I preserve Subversion VMS content in a 4.2->4.3 Side-by-Side upgrade ?

SHDB_INDEX_CREATE: "Wrong transport request. Index not activated"

Re: The resource of type "Document" with identifier "Number" is not available er

Re: Are Database Functions in Snowflake Database visible to Information Design Tool ?

Re: Are Database Functions in Snowflake Database visible to Information Design Tool ?

Re: Execute HANA procedure via Oracle DBLINK

Re: Execute HANA procedure via Oracle DBLINK