cancel
Showing results for 
Search instead for 
Did you mean: 

Deski SQL Queries

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Prithvi,

Thanks for the answer, much appreciated.

Regards,

Mitesh Joshi

Answers (0)