on 03-25-2011 6:28 PM
We are setting up a new testing environment. So I made a copy of our BO universe so we could have two different testing universes. I then created a copy of the data source database that will be used as the data source for the reports in the copied universe. The two different databases have the exact same tables, columns and indexes as the development database. The only difference will be the data inside the tables.
I now need to change the reports to use the new universe since the reports were written using the universe instead of using the database. I am not changing anything else in the reports. I just need them to run against a different Oracle database.
So I go into Crystal Reports version 11.5.0.313 and open the report up. I then go into Database fields in Field Explorer to change the data source. I then go to the Set Datasource Location screen. I open up the universe label by clicking on the plus sign and I select the copied universe. When I do that, the Business Objects Query panel screen opens up. Because I have switched universes, Crystal Reports wants me to reselect the columns and rebuild the query.
We have over three thousand reports so we are trying to avoid rebuilding them. I am looking for a better way to change what database a report runs against.
Note: All of the reports will be run ion demand. Nothing will be scheduled.
Any suggestions and information will be greatly appreciated.
Has anyone run into this? What was your solution to this problem?
Hi Joe,
Moved your post to the Universe Forum.
First you are using the original release of XI R2. You need to upgrade to Service Pack 6 by:
Run License Manager first to get the keycode if you don't have it on paper somewhere.
Then download these and uninstall then run full build first:
https://smpdl.sap-ag.de/~sapidp/012002523100011802732008E/crxir2_sp4_full_build.exe
https://smpdl.sap-ag.de/~sapidp/012002523100013876392008E/crxir2win_sp5.exe
https://smpdl.sap-ag.de/~sapidp/012002523100015859952009E/crxir2win_sp6.exe
Try again
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your reply. I read through it and I understand what you wrote. But i do have a question. Are you saying that if we apply patches and bring our software to the current patch level, that I will be able to do what i need to? Please let me know.
I'll contact the group that does software upgrades about this to start the process.
Thanks for the information.
A simple logic can be that it will use an id of the universe to build the query now in our case you have copied a new universe which obviously will have a different id in the enterprise with different IDs for the objects that it holds.
Now when you change the data source you are altogether changing the universe Id associated with report and the objects are also new,
So I think it should be default behavior although we can test it further.
One question the copied universe name is it same as the original universe on which the report was made ?
Regards
Kultar
Thanks for the reply. I understand what you wrote and it makes perfect sense. I still do not want to re-buld over 600 reports. So i am still looking for a better answer.
To answer your question, the copied universe has a different name since it is stored in the same Business Object instance as the universe I made the copy from.
Hi,
If you just want to test the reports with another databse, why don't use the same universe and same reports.
You don't need to do any changes any where in reports.
Only change you should do is in universe.
Go to universe --> Tools --> Manage Access REstrictions --> Create a restriction --> in the restriction change the connection to the new test database --> Save it --> Assign this restriction to test user.
Only test user accesses the new test database connection. Rest all users use the same database as it is while running reports.
Edited by: Gowtham Sen Potnuru on Mar 31, 2011 7:39 AM
I messed up when I marked who gave the right answer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you are using CR 2008, right click on data source and select "Set datasource location" --> create new connection --> Universes --> Change to New Universe
it works fine without any changes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
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.