cancel
Showing results for 
Search instead for 
Did you mean: 

Reports based on Universe Short name

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Forgot to mention, I am using BI 4.0 SP04. Any chance of getting a query builder query?

-Laxminarayana

Former Member
0 Kudos

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

Answers (2)

Answers (2)

former_member182521
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi All,

Thanks all for your reply.

This is what I did to get the short name

Select * from ci_infoobjects where si_name='my report name'

Once you run this query you will find the details of the universe short name in 'SI_WEBI_DOC_PROPERTIES'   column.

Laxmi

Former Member
0 Kudos

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