Deski reports custom sql

[Former Member]

Hi Team,

I am using the below mentioned code to get the list of webi reports which use custom sql:

dProvider = dProviders.getItem(j);

if(dProvider instanceof SQLDataProvider)

{

     SQLDataProvider sqlDP = (SQLDataProvider)dProvider;

     if(sqlDP.isCustomSQL())

     {

          SQLContainer sqlContainer = (SQLContainer)sqlDP.getSQLContainer();

          System.out.println("Data provider name :: " + dProvider.getName());

          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());

          }    

     }

  }

Is there a similar version for deski report. Or any sample code which will help me to get the list of deski reports which have custom SQL in it.

BO Version BI 3.1 SP3

Regards,

Mitesh Joshi

[Former Member · Accepted solution]

Hi Mitesh,

Refer to thread http://scn.sap.com/thread/3612962

Probably it might be possible using the Deski COM SDKs, however not sure about it.

You can raise your queries in the below forum to check if you get the answers

http://scn.sap.com/community/bi-platform/microsoft-net-sdk

Thanks,

Prithvi

[Former Member · Accepted solution]

Hey Thanks Prithvi..