Hello, I am new to using BO and I am using WEBI where a report has be shared with me. I am able to see the visual but when I try to go get the sql script : Design>Data Access>Edit>View script, I do not get the entire sql script which has been generated and under the Result Object Pane there are only 2 objects for which the script is being generated. How do I get the entire script for the visual?
My second question: When I try clicking on different tabs, I get the following error: This data provider cannot be edited because it is based on a Free Hand SQL Script.
Could you please help me in getting the entire sql query! Thank you for your time