Crystal-Universe XI R2

[Former Member]

1. How do I know my report is connected to the right Universe? On CMC it says Universe Query as Data Source. But it doesn't say which Universe it is connected to.

Even when I import the report to Crystal Client, it doesn't say which Universe it is connected to. It only gives the login Info.

2. How can I add new columns to the report that is connected to Universe?

When I update the universe query - Crystal Set Data source, it is asking for all list of Objects and I have to manually choose the objects. What if the report has many columns?

Besides manual selection of Objects and matching them, updating the data source is affecting the crrent report Parameters. I have to recreate them after the re-point.

Is there any workaround?!!

[Former Member · Accepted solution]

Open the report in Crystal Designer

Go to Database Expert

Right click on the command in the right pane and select Edit Command

The Universe Name should be at the top of your object list in the left pane

[Former Member · Accepted solution]

Jody,

I am looking at CMC / Infoview level not the Crystal client tool. I don't want to open each report in the client to see the datasource.

I contacted the Business Objects support. They told me that it is a limitation in XI R3 also. They asked me to raise an enhancement request. I am really surprised with that answer. It is such a simple thing!!

Thanks,

SG.

[Former Member · Accepted solution]

You could try some modification of

select * from CI_INFOOBJECTS where si_kind = 'CrystalReport' and si_universe.si_total > 0

in Query Builder.

Best,

Srinivas

[Former Member · Accepted solution]

Srini,

Here is what I am looking for and it is not possible in the current BOBJ Xi versions. SAP sent me a link to raise the enhancement request.

CMC>Folders> <Report Flder> --> <Report> --> Process -->Database

We can view and edit db info here. but there is no info. about the universe. It just says 'Universe Query'. It is really hard to manage the Crystal Reports if there are many Universe. We have to login to Crystal to see which Universe the report is connected to.

Thanks,

SG.

[Former Member · Accepted solution]

Hello,

The query I included above does show universes associated with a Crystal Report (in my case SI_LOGON_INFO >> SI_LOGON1 >> SI_SERVER). I however only tested on XI 3.1.

Also, a Select * probably returns much more information than you need/want.

I don't believe there is any other method to pull this information.

Best,

Srinivas