Copy Data Providers / Copy Report Variables

system · May 11, 2003, 11:42pm

Author: Dwayne Hoffpauir, EDS Corporation

Updated 26-May-2004 for compatibility with V5.1.8 …

Further discussion on this utility should take place in this topic

Author Notes:

In addition to copying data providers, this utility will also copy named report variables and their formulas between documents.

Installation:

Extract the .rea files to a local directory.

In Business Objects, choose Tools, Add-Ins…

Browse to the local directory, select BusObj Utilities.rea, click Open.

Click the checkbox next to BusObj Utilities and then OK.

Usage:

New options are added to the Data menu labeled Copy Variables and Copy Data Provider.

When this option is selected, a dialogue box is displayed.

In the top box, choose the source document.

From the middle box, choose one or more items to be copied.

From the bottom box, choose the destination document. Destination for data provider(s) can be any open document, including the source document if desired. Destination for variables cannot be the source document.

Data Provider Copy Functionality:

Copy multiple data providers simultaneously.

Handles combined queries (union, intersect, minus).

Keeps the same data provider name if possible.

Copies all properties available to the object model (including sorts and settings like IsRefreshable, DuplicateRows, and so forth).

Minor annoyances:

Though syntactically equivalent, the layout of the condition format (parenthical nesting) is not retained. For example, a query with 7 conditions nested as follows:
(#1 AND #2 AND #3 AND ( (#4 AND #5) OR #6) AND #7)
is reformatted to look like this:
(#1 AND (#2 AND (#3 AND ( ( (#4 AND #5) OR #6) AND #7) ) ) )
Data Provider returns the SAME RESULTS, it just displays unnecessarily complex.

Does not COMPLETELY handle data providers using subqueries or other objects as operands. The majority of the data provider is copied. Only the operand and subquery / object itself must be manually added after the copy.

When copying report variables, the syntax must be valid in the destination document. If one variable depends on another, you may need to copy them in multiple passes so that each is valid at the appropriate time.

Feedback is preferred via BOB (busobj.forumtopics.com), but I can also be reached at dwayne.hoffpauir@eds.com as well. Enjoy!!

Please download the code to review it. Most of the active code is in the form provided in the add-in.
BusObjUtilitiesV2.2.zip (63.0 KB)

BOB Downloads (BOB member since 2003-05-05)

system · May 11, 2007, 1:07pm

Posting an updated version of the utility that works with XI. Changes:[list]A slight syntax change is needed for referencing a universe … enterprise folder instead of domain.

Added an item to the Data menu that creates a default report from a data provider, like the Report Wizard.[/list]
BusObj Utilities XI.zip (108.0 KB)

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · May 18, 2008, 5:54pm

I used the addin provided in BOBs downloads to copy data providers in BO 5.1.8.

I get a message saying

Multiple Universe.Please select repository.

Can someone help me in this regard.

Is this a limitation of BO 5.1.8.

Regards

Keepitsimple (BOB member since 2007-08-15)

system · May 19, 2008, 1:14pm

That means you have more than one universe locally with the same name. This usually happens when someone has done a “save as…” and made a copy locally, that has not been exported to a repository. Delete (or rename) the duplicate and you should be fine.

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · February 18, 2009, 11:35am

I install this ADDINS … can you tell me how can I use it?
I receive this error :
“Error 20 : No Universe with this Name and Repository”

Thanks.
Giulia

Giulia (BOB member since 2007-08-10)

system · February 19, 2009, 2:00pm

What version of DeskI / Reporter and what version of the utility are you using?

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · March 3, 2009, 11:32am

I have installed the the updated XI version. I am on Deski R3, the addin has been registered in Deski, but copying Data-providers throws the following error:

Error 31: Not Implemented

then the next error comes up

Run-time error `91`:
Object Variable or With block variable not set

ghostman (BOB member since 2006-01-12)

system · March 3, 2009, 2:49pm

I can’t get the add-in to load automatically in 3.x, but otherwise than that it seems to work fine. Try disabling the error handling, or step through the code one line at a time to see which line is actually causing the error. That may give us a clue to the real problem.

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · March 3, 2009, 4:39pm

This is where the debugger starts:

'DataProviderFrom.Unload (version 5.1.8 only allows one data provider to be loaded!
    DataProviderTo.Unload

Disabling the error handling on this sub means the list of dataproviders gets duplicated with every attempt. No successful copies. The Variables seem to be OK.

ghostman (BOB member since 2006-01-12)

system · March 9, 2009, 2:14pm

DeskI 11.5.0.0
BusObj Utilities XI.zip

Giulia (BOB member since 2007-08-10)

system · March 9, 2009, 2:45pm

Just a theory here. The universe must be downloaded locally first. Try downloading a clean copy, just to be sure it has the right repository security attached to it.

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · March 31, 2009, 8:50pm

THANK YOU FOR THIS!!!
This is the best thing ever! It just saved me hours of work.
I love BOB!

2spots (BOB member since 2008-07-29)

system · April 1, 2009, 12:14pm

The result doesn’t change.

Giulia (BOB member since 2007-08-10)

system · April 9, 2009, 12:25pm

Ghostman,

Did you ever get a solution to your problem with using the Copy Data Providers routine (BusObj Utilities) - I also get the Error 31: Not Implemented with the “Run-time error `91:Object Variable or With block variable not set”!

I’m using BO XI R2

Emailed Dwaye Hoffpauir but have not yet received response.

TonyR

TonyR (BOB member since 2006-07-17)

system · May 4, 2009, 7:32pm

I’m trying to copy a variable from one report to another (using XI R2, have used this utility successfully before) and am getting
Run-time error “9”
Subscript out of range.

Can you help?
Thanks!

2spots (BOB member since 2008-07-29)

system · May 6, 2009, 5:34pm

Can you try the steps suggested here?

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · May 27, 2009, 9:34pm

Hi,

I got a requirement to merge two different BO reports.

I tried the Addin which has been provided here for XI.
But i don’t see any copy variable or copy data provider after adding addin .
i am using BO XI R2.

can anyone help ?

Thanks

lmp1 (BOB member since 2007-02-21)

system · May 28, 2009, 1:41pm

hi,

finally I could make it to get copy Dataproviders and variables in Data menu and able to select dataproviders in source and destination.

but when i am checking my destination report, I don’t see the data provider which i have added from source report.

I think I am missing something here.

Can anyone help me please.

appreciate your help.

thanks,

lmp1 (BOB member since 2007-02-21)

system · May 28, 2009, 7:35pm

Hi,

This actually worked great.
Thanks a lot for this addin.

Excellent work.

I am also looking to copy exact Report layout with format.
any ideas.

Thank you so much.

lmp1 (BOB member since 2007-02-21)

system · June 2, 2011, 10:40am

tht’s wonderful, thanks.
but i got an issue here data providers copied successfully with no error but when i open it the structure look something different from that of original.
Any idea? I’m using R3 is it because of that?

lahca_ac (BOB member since 2010-01-18)

Copy Data Providers / Copy Report Variables

Error 31: Not Implemented

Run-time error 91: Object Variable or With block variable not set

Run-time error `91`:
Object Variable or With block variable not set