Is there any way that I can copy a data provider within a single document ? Much of the criteria for the second data provider is the same as the first data provider and I’d hate to have to key it all in again.
Thanks,
Matthew
Listserv Archives (BOB member since 2002-06-25)
Have you tried inserting a new table into the document and selecting all the objects from the current data provider or going to the bottom left corner (“Report1” tab), right click, and selecting Duplicate Report?
George Baranowski
Is there any way that I can copy a data provider within a single document ? Much of the criteria for the second data provider is the same as the first data provider and I’d hate to have to key it all in again.
Listserv Archives (BOB member since 2002-06-25)
I haven’t stated my issue very well. What I need is to write a separate query against the database (within the same document) that is very similar but not exactly the same as the first.
Can I copy the data provider and modify it ?
Thanks,
Matthew
George Baranowski gbaranowski@QUADRAMED.COM on 09/01/98 12:55:06 PM
Please respond to Business Objects Query Tool BUSOB-L@LISTSERV.AOL.COM
cc:
Have you tried inserting a new table into the document and selecting all the objects from the current data provider or going to the bottom left corner (“Report1” tab), right click, and selecting Duplicate Report?
George Baranowski
Is there any way that I can copy a data provider within a single document ? Much of the criteria for the second data provider is the same as the first data provider and I’d hate to have to key it all in again.
Listserv Archives (BOB member since 2002-06-25)
I have had that need many times before but have not as yet found any way to accomplish it. I think I tried about everything!! If anyone knows how to do this, it would be great!!
Maria D. Carter 
BusinessObjects Developer
mcarter@gbncmail.ims.att.com
[Carter, Maria]
I haven’t stated my issue very well. What I need is to write a separate query
against the database (within the same document) that is very similar but not
exactly the same as the first.
Can I copy the data provider and modify it ?
Thanks,
Matthew
Listserv Archives (BOB member since 2002-06-25)
I don’t think you can do that. What you may have to do is just make your first query more generic so it can be used for both report objects (table/crosstab/chart/etc) and use filtering at the report level.
For example, if you had the query:
SELECT A, B FROM T1 WHERE C=10
and you wanted to copy and modify this query so that it said:
SELECT A, B FROM T1 WHERE C=15 AND D=1
then what you may have to do is create a more generic query:
SELECT A, B, C, D FROM T1
When you create Table1 from this query, you would apply the filter C=10, and when you create Table2 you would appy the filters C=15 and D=1.
Just a humble suggestion…
Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com
I haven’t stated my issue very well. What I need is to write a separate query
against the database (within the same document) that is very similar but not
exactly the same as the first.
Can I copy the data provider and modify it ?
Listserv Archives (BOB member since 2002-06-25)
On Sept 1, Matt asked
Is there any way that I can copy a data provider within a single document ? Much of the criteria for the second data provider is the same as the first data provider and I’d hate to have to key it all in again.
Thanks,
Matthew
Matt,
There are a number of us that here that wish you could do so, but you cannot create a new data provider by first creating a copy of an existing one and then editing same.
Maybe in the next version
Shannon Lee Wittal
swittal@qgraph.com
Listserv Archives (BOB member since 2002-06-25)
Is there any way that I can copy a data provider within a single document
?
Much of the criteria for the second data provider is the same as the
first
data provider and I’d hate to have to key it all in again.
Maybe I’m missing something here, but can’t you just go in to edit the original data provider, highlight all the text that you want to copy and press Cntrl+Insert to copy it. Create your second data provider and Shift+Insert to paste what you just copied into the new query box and then make whatever modifications you need to make.
David Berg
dbberg@duke-energy.com
Listserv Archives (BOB member since 2002-06-25)
Matthew Ferguson schrieb:
I haven’t stated my issue very well. What I need is to write a separate query against the database (within the same document) that is very similar but not exactly the same as the first.
Can I copy the data provider and modify it ?
Unfortunately, this is not possible in the current version. I will put this as en Enhancement Request…
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Listserv Archives (BOB member since 2002-06-25)
You could write a script to read the objects and conditions in a data provider and then create a new data provider with this information.
Andrew J. Erthal
Orion Project Manager
Business Objects University
Chicago Office (847) 391-9898
St. Louis Office (314) 209-1994
St. Louis Fax (314) 209-7926
Listserv Archives (BOB member since 2002-06-25)
I do not believe any of the methods suggested would allow you to reproduce the graphical interface to your universe so you could just drag and drop new objects and conditions to that panel. All suggestions made would deal with script or SQL…
I (and.I believe Matt) just want to be able to “clone” the graphical interface part of the data provider.
Shannon Lee Wittal
swittal@qgraph.com
Listserv Archives (BOB member since 2002-06-25)
Hi
I have about 5 reports in which I want to add 2 new data provider. Is there a way that I can copy an existing data provider and make some minor changes to it and then rename it within the report.
Please let me know any suggestions that you might have. I am trying to meet a deadline.
Thanks
Harpreet
Listserv Archives (BOB member since 2002-06-25)
In a message dated 00-03-22 09:36:32 EST, you write:
I have about 5 reports in which I want to add 2 new data provider. Is there
a way that I can copy an existing data provider and make some minor changes to it and then rename it within the report.
Glenn Fredericks, a fellow “list person”, has contributed a script to do just this. You can find his scripts at our web site, on the page listed below:
http://www.islink.com/bobjtech.htm
He has two scripts, one to duplicate a data provider from one document to another, which is not the one that you need, and one to duplicate a data provider within the same document. That should do the trick!
Thanks again Glenn!
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
Do these scripts work with 5.0? BO also supplies a similiar macro in 5.0, but I have not been able to make it work.
Listserv Archives (BOB member since 2002-06-25)
In a message dated 00-03-22 11:07:21 EST, you write:
Do these scripts work with 5.0? BO also supplies a similiar macro in 5.0,
but I have not been able to make it work.
Glenn has sent me a 5.0 version; I have been lax in posting it on our site. I hope to get that done today.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)