on 10-05-2015 4:21 PM
Hi, Can someone suggest if there is an option to run SQL code which is generated in a webi report (view script), we used to have TOAD or SQL developer tools on top of relational db in my previous projects.
I realized that DBACOCKPIT or ST04N are only for DBAs, not for developers like myself or atleast we do not have access to SQL command editor in these tcodes in SAP BW
Please provide any inputs in this regard
Thanks in advance, Kris
Hi,
if your question is related to Webi reports SQL based on the IDT universe on BW cube or DSO then you can use Data Federator Admin tool to run the scripts.
it's under the BO clients applications.
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andres thanks for your response, I am not authorized for DB access so I am unable to use any of these tcodes.
1. Is it possible to use Toad or SQL developer with BW as backend.
2. Also the limitation with data federation client tool is that i do not see all my infoproviders under Catalog list, there are only a few but not all from my BW system (is there a reason why it doesn't show all the IPs). This tool surely comes handy if you have your IP in the list and execute any SQL
Your help would be appreciated,
Kris
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.