on 03-24-2009 2:49 PM
HI
I am trying to use custom sequel and the option is grayed out for our web intelligence. Where do I make this option active so I am able to add my own SQL?
Thanks!!
In the CMC, in the BusinessObjects Enterprise Applications > Web Intelligence > Advanced Rights section there is a right called: Java Report Panel: Edit SQL.
I think if you grant this right to yourself or your group then you should be able to edit the SQL (providing you're using the Java editing panel).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I created a Custom SQL,validated it,saved it then refreshed the report saved the report and closed it.
Then when again I opened my report in EDIT mode and i get same report with contain Custom SQL..
after you created a Custom SQL and then you add,delete objects or any change in query filter,then Custom SQL convert to Script..
Regards
Mustafa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Terri,
I had one question on using custom SQL in webi 4.0.I created a Custom SQL,validated it,saved it then refreshed the report saved the report and closed it.
Then when again I opened my report in EDIT mode and through Data Access when I tried to see the SQL generated by my Custom SQL ,I saw that the query no longer remains a Custom SQL but it has the query generated by my script.How is it possible?.Or when you are in the EDIT mode of the report you won't able to see the script which contains Custom SQL.
I hope I have made myself clear.
Any help on this will be appreciated.
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rddhi,
have you got ant solution for your query, i am facing same problem. Kindly let me know if you have any solution.
(
I had one question on using custom SQL in webi 4.0.I created a Custom SQL,validated it,saved it then refreshed the report saved the report and closed it.
Then when again I opened my report in EDIT mode and through Data Access when I tried to see the SQL generated by my Custom SQL ,I saw that the query no longer remains a Custom SQL but it has the query generated by my script.How is it possible?.Or when you are in the EDIT mode of the report you won't able to see the script which contains Custom SQL.)
Thanks
Praveen
What exactly is greyed out in Webi? Can you view the SQL generated by the query but not type over it?
If you can view the SQL you have to select the radio button marked 'use custom SQL' before you can type into the SQL window.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You'll need to have administrator access to the CMC to make this change though.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In the CMC you can set the option to allow viewing of the SQL generated by the query at either the folder level or across the whole of Web Intelligence. It's down the bottom of the 'rights' tab for the folder.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.