on 09-03-2014 12:37 PM
Hi All
I am using oracle 11g as backend to develop using crystal reports and I am using Business View Manager as the connection in crystal reports.
Now my issue here is I have created the DC, DF, BE and BV using abc schema but as the request has changed I need to update the schema to xyz as table structure is same in both the schemas.
I was able to successfully update the schema in DC but that is not reflecting in DF, BE and BV as a result of that when I use the updated BV in report report is not run as there was abc.tablename for all tables.
I have searched google but unfortunately unable to find any useful solution for the problem.
Experts please help me to update the new schema connection to DF, BE and BV
I am using Crystal Reports 2008 SP3 and Business Objects 3.1
Thanks for your time.
Hi Siva,
Go to Data Foundation layer and open the option Data Foundation where you can see all the list of tables and joins. Click all the tables and right click on it you will see option Change Qualifer/Owner, there you can change it to xyz. In this way all the objects will reflect the xyz.column name.
Note: Derived table will not show the option for Change Qualifer/Owner.
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 continous assistance Mantu Sahu.....
Unfortunately I can't paste the screenshot aswell... but will try to explain in detail what I am doing...
to the left most part there will be datafoundation name... below that there are tables so what I have done is right click on the table in those options there is no change qualifier or ownere but there is option Set table location. Is this option you are discussing about?
To add more information I am working on Business Objects 2.1 SP0... will this have any impact on the options that are displaying.
Regards
Siva
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.