Copy Data Providers / Copy Report Variables

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)

system · July 27, 2011, 8:21pm

Hi All,
When I tried to use “copy data provider” utility ,I am facing an issue saying “Error:20 No Universe with this name and repository” in BO XI (Version: 12.3.0.601).

I know I need to tweak the code a bit but have no idea as to how I should open the .rea file (VB ?? ) , where to put in the changes and what are the changes .I have already imported my universe (“Valuation”) into the local folder “Universes”.
Should I change the repository name too (as I am using local universe) ?.

Help Please.Thanks a lot in advance.

Ravi

chanru4u (BOB member since 2011-07-27)

system · January 9, 2012, 4:19pm

Hi, has anyone found a way of copying the exact report layout to another BO report ? Appreciate the help and support. Thanks !

ajaz.jamil (BOB member since 2012-01-09)

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