How to View Free Hand SQL in Webi Report

[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.

[Former Member]

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

[kohesco]

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

[former_member182342]

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