Skip to Content
0

How to View Free Hand SQL in Webi Report

Dec 15, 2017 at 03:26 PM

56

avatar image
Former Member

Hi ,

I need to view the query of the free hand sql report but when i click on the data access i see the below error.

I even logged in as administrator but its not working .

Can you please tell me how to view/edit the free hand sql.

My user reported that he got the below error while refreshing this free hand sql report.

"Database error occured - ORA00904 - "ColumnName" - invalid identifier"

only if can able to view the sql i can able to investigate further.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Dec 15, 2017 at 10:03 PM
0

Hi Muthu,

Are you able to run the report or did you faced any issue while refreshing the report as well. If its the issue then there is problem with your admin rights.

Or if its not a case then try to remapped the objects using change source functionality and then try to edit the query and there u will see free hand sql option.

Regards,

Anish

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Dec 19, 2017 at 08:20 AM
0

Hi,

if you open the WebI document locally in your client it should work and if you open in on web, you should as well be able to it as asplett, via HTML it will not be possible to see it.

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 27, 2017 at 09:36 AM
0

Thanks for the response.

It was related with user id.

I user the id which has the Olap connections and Free hand sql report access

Many thanks

MK

Share
10 |10000 characters needed characters left characters exceeded