Get SQL for deski reports

sdk development
1

Dears ,

i need your help to get the SQL for dataprovideers of deski reports , i tried to get the webi reports and i succeded in it .

below is the code i am using with deski :


boReportEngines  =  (ReportEngines)  enterpriseSession.getService("ReportEngines");
        ReportEngine boReportEngine =   (ReportEngine) boReportEngines.getService(ReportEngines.ReportEngineType.FC_REPORT_ENGINE);

boDocumentInstance = boReportEngine.openDocument(oInfoObject.getID());

DataProvider boDataProvider = boDocumentInstance.getDataProviders().getItem(0);

System.out.println(boDataProvider.getQuery().getSQL());

and i got the below error :

com.businessobjects.rebean.wi.NotImplementedException: This feature is not supported for Desktop Intelligence. (Error: RFC 00301)
at com.businessobjects.rebean.fc.internal.DataProviderImpl.getQuery(DataProviderImpl.java:250)

smsm-kw (BOB member since 2009-10-28)

2

As the exception states, the feature is not supported for Deski reports. I feel your pain as I have tried to do the same for our large percentage of Deski documents. I ended up downloading each report and using VBA to get the SQL which is ridiculously slow compared to the Webi method.

BoB LoblaW :us: (BOB member since 2007-10-23)

3

big shock :cry: :cry: :cry:

smsm-kw (BOB member since 2009-10-28)