Crystal Report with Universe instead of Business Views: Any limitations ?

[Former Member]

Hi,

We were using Crystal Reports on top of Business Views until now. Due to considerable post-migration work with Crystal Reports on top of Business Views we are thinking of switching to Crystal Reports on top of Universe.

Can anybody explain me whether there is any drawback while using *Universe with Crystal Reports* instead of Business Views with Crystal Reports.

Please consider the following pointswhile giving an evaluation -

Dynamic parameter

(ii) LOV creation and maintainence

(iii) Maintaining order of parameters

(iv) Updating Universe/Business View level changes in Report (Verify database)

(v) Report performance

Your advice/views is appreciated.

Regards,

Neonevin

[Former Member · Accepted solution]

Here are my views..

Yes, you can create crystal reports on top of universes. But there is one major drawback using universe. You can connect to only one database at a time. But in Business View you can connect to multiple databases. If you are ok with this, you can absolutely go for universes.

Dynamic parameter --- Yes its possible

(ii) LOV creation and maintainence --- Whatever the LOVs you have in universe, you can use the same. And also you can use LOVs created in Business Views while creating reports on top of universes. Any how please check. not very sure about it.

(iii) Maintaining order of parameters --- Yes, the order of parameters can be managerd using universe designer itself.

(iv) Updating Universe/Business View level changes in Report (Verify database) -- No need of updates required to be done in report. There are few changes which can happen for universe. Seemlessly you don't need to do anything to reports. Unless you delete some objects in universe.

(v) Report performance -- Never checked in this perspective. Performance should be fine.

Regards

Gowtham