Business Object checking SQL scripts in BO access

[Former Member]

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.

[manikandan_elumalai]

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

[amitrathi239]

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