on 09-02-2014 2:18 PM
Hi Team,
I am using the below mentioned line of code to get the queries for webi report.
SQLDataProvider sqlDP = (SQLDataProvider)dProvider;
SQLContainer sqlContainer = (SQLContainer)sqlDP.getSQLContainer();
int containerCount = sqlContainer.getChildCount();
System.out.println("Container count :: " + containerCount);
for(int k=0;k<containerCount;k++)
{
SQLSelectStatement sqlStmt = (SQLSelectStatement)sqlContainer.getChildAt(k);
System.out.println("The SQL Statement :: " + sqlStmt.getSQL());
}
The same code does not work for Deski reports.
Could you please let me know the code to get SQL query used in FullClient Dataprovider.
Env: BO XI 3.1 SP3
Regards,
Mitesh Joshi
Hello Mitesh,
You cannot get the sql for a deski report.
The Report Engine SDKs is not full complaint with Deski.
You would not be able to get the dataprovider details of a deski report using Report Engine SDKs.
Refer to SAP Note: 1395501 - Is it possible to retrieve Desktop Intelligence SQL query using Java Report Engines SDK?
Thanks,
Prithvi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.