Question Re: Business Object checking SQL scripts in BO access in Technology Q&A

Business Object checking SQL scripts in BO access

Former Member — Mon, 14 Sep 2015 10:37:30 GMT

Hi Experts,

What access level I should assign so user can see SQL script in Webi report.

e.g. In webi report click on Edit and then click on script and they should able to see script.

Currently Edit option in Webi greyed out.

Please send screenshots.

Re: Business Object checking SQL scripts in BO access

amitrathi239 — Mon, 14 Sep 2015 11:46:14 GMT

Hi,

Right click on the Web Intelligence application user the application and grant the access to "reporting-enable formatting."With this design mode will enable.

After this right click on the report folder and assign the "edit object" under the general category."Edit query" under the section content->web intelligence.

See screenshot.

Amit

Re: Business Object checking SQL scripts in BO access

manikandan_elumalai — Mon, 14 Sep 2015 11:56:14 GMT

Hi Pavan,

It seems the right Query script- Enable editing is missing. Try the below steps

- In CMC, go to Applications

- Right click Web Intelligence and choose User Security

- Click the Add Principles button to add the user or group you wish to grant

- Highlight the user or group and click Assign Security

- Click the Advanced tab, then Add/Remove Rights

- On the left, choose Application, then Web Intelligence

- Grant the right "Query script" enable editing (SQL, MDX,...) and click OK

Thanks

Mani