on 04-05-2013 6:06 PM
Hello All,
I am trying to build a query which gets the list of reports and the associated reports. We have achieved this against the query builder by using the relationship queries and loaded it in a excel. The problem here I am not able to get the reports which are pointing to Universe Shortname. I mean I can refresh those reports but I see no universe associated with it. I check this by going to the properties of re[port from CMC and under Default settings>>Report Universe. when I query the same against the query builder I dont see any universe for this report neither do i see the Report ID associated with the Universe.
How to get the list of reports along with the Universe shortnames?
-Laxminarayana
Hi Laxminarayana,
Which version of BusinessObjects server are you using?
If you are using XI 3.1, below is the way how you can retrieve universe related to webi reports
The below code uses the report engine java sdks.
Below is the link from wherre you can download the api reference and developers guide for the same.
http://www.sdn.sap.com/irj/boc/samples?rid=/webcontent/uuid/90db428d-71ba-2e10-7eb7-d3286eec5ac0
Refer to the Report engine java sdk section.
IEnterpriseSession enterpriseSession = null;
ISessionMgr boSessionMgr = null;
ReportEngine webiRepEngine;
boSessionMgr = CrystalEnterprise.getSessionMgr();
enterpriseSession = boSessionMgr.logonWithToken(securityToken);
webiRepEngine = (ReportEngine) enterpriseSession.getService("", "WebiReportEngine");
DocumentInstance reportInstance = webiRepEngine.openDocument(reportId);
DataProviders dps = reportInstance.getDataProviders();
if(dps != null && dps.getCount() > 0){
DataProvider dp = dps.getItem(0);
if(dp != null ){
universe = dp.getSource();
}
Thanks,
prithvi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Laxminarayana,
The reports that are not showing universe name in the properties in CMC must be migrated from some other environment.
As the universe short name is same in the previous and recent environment, reports are working fine, however, these reports are still not mapped to a universe in the neweerr environment.
As a test, you can open any such report in web intelligence rich client, refresh it and save it back to BO enterprise. Once the report is saved successfully, you would be able to see universe name in the properties of the report in CMC.
Regards,
Anchal
Hi Laxmi,
Can we check this.
SELECT SI_ID, SI_KIND, SI_NAME, SI_UNIVERSE FROM CI_INFOOBJECTS
WHERE SI_KIND='WebI' and SI_INSTANCE=0 and SI_UNIVERSE.SI_TOTAL< 1
For all the unbound reports SI_UNIVERSE wont hold any value.
Regards,
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Laxminarayana,
Try remapping the report to the universe again either from Webi rich client or BI Launchpad and recheck the universe name in properties of report in CMC.
Regards,
Akhilesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.