Workaround Needed for Free-hand SQL with DDL statements in Web Intelligence BO 4.3

[Asit_Mukherjee]

Hello SAP Experts,

We are in SAP BO 4.3 , Windows based, Single Node.

Now, we have few Free Hand SQL based reports to be developed which has DDL commands in those.

 Also we are aware, the SAP Note, which mentions DDL commands are not supported in SQL Panel (BI LaunchPad).  

2248236 - Free-hand SQL with DDL statements in Web Intelligence.

Can anyone please guide with an workaround to resolve this issue at the earliest?

Has anyone tried resolving this issue , please help with an approach.

Thank you , in advance , for reading,  coming forward and resolving this issue.

Regards,

Asit Mukherjee.

[anuttohsu]

If you are trying to use temp tables, create a stored procedure that uses a temp table then use an ODBC connection for Webi FHSQL.

[nscheaffer]

What is your DDL statement?

Web Intelligence is a reporting tool. I both would not expect DDL statements to work and would expect them to not work. In other words I am not surprised they do not work and I would be alarmed if they did. Imagine the chaos if a reporting tool such as WebI were able to alter the structure of the database.

Noel

[nachtaktiv]

create a stored procedure in your DB and execute this procedure from WebI FHSQL

[nscheaffer]

Have you tried this? Years ago I attempted creating a stored procedure that created and used a temp table and BOBJ would not allow it.