Skip to Content
avatar image
Former Member

How to View Free Hand SQL in Webi Report

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2017 at 08:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 27, 2017 at 09:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded