on 2014 Mar 18 12:49 PM
Hi Gurus,
i am facing some issues using the HANA PAK.
When i create a SQLscipt procedure as advised in SAP help
http://help.sap.com/saphelp_nw73/helpdata/de/d8/8c62391de045cb936ca2afd2a84c9a/content.htm
and the srcipt does nothing except:
E_T_TABLE = SELECT * FROM :I_VIEW;
Everything works, i.e. the scipt is getting executed and all key figures included in my agg. Level are doubled everytime i execute the planning function.
When i alter the above Statement slightly, for instance to
CREATE PROCEDURE SAPBT2.SP_YPAK_CL_DEMO_3( IN I_VIEW SAPBT2.TT_YPAKA003,
DECIMAL (000017, 000003) ,
OUT E_T_TABLE SAPBT2.TT_YPAKA003 ) LANGUAGE SQLSCRIPT READS SQL DATA AS
BEGIN
DECLARE a INT ;
SELECT * FROM :I_VIEW ;
END
and execute in RSPLAN, i get the following Errors:
and
Same issue when removing the part
READS SQL DATA AS.
For creating a local temporary table. I always get some internal PE Errors.
While Debugging the SAP Planning Framework, i found out, that at runtime several views belonging to the planning session a created at HANA DB Level, which are queryable. But only when i have a procedure doing nothing but select.
There might be some issues with authorizations of the SAP<SID> user.
Do you have any ideas how i could proceed on that issue?
That would be highly appreciated.
THX in advance
Jonas
Hi Jonas,
Did you find a way to solve your issue
I encounter the same problem and cannot find a solution.
Thanks in advance.
Best regards,
Juan Pablo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.