Copy Query from one report to another

building reports webintelligence
1

Hi - I have to create a new web intelligence report and would like to use an existing query in another web intelliegence report. Is it possible to copy the query from one to the other? This is in a brand new web intelligence report and not just a new report tab in the old report.

Thanks

pcb_bi (BOB member since 2013-02-13)

2

Welcome to B:bob:B
This isn’t currently possible.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hi,

Save the original report with a new name. Then open the new report, keep the query that you need and remove everything else. Done.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

Thanks - I would’ve thought something so simple could be done :frowning:

pcb_bi (BOB member since 2013-02-13)

5

I think the new report already exists.

Nick Daniels :uk: (BOB member since 2002-08-15)

6

I’m actually adding a report tab to an existing report. The new tab has to use the same query from another webi report.

pcb_bi (BOB member since 2013-02-13)

7

Then you need to re-create the query in the existing report.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

8

The SDK is getting better. It may be in the future this can be done with a bit of code. Or who knows, maybe SAP will provide it as an out of the box option.

You could see if anyone has raised it as an idea, if not why not create one yourself!

https://ideaplace.brightidea.com

Nick Daniels :uk: (BOB member since 2002-08-15)

9

I’d say a repo of common queries would be fantastic. Thanks for all the help!

pcb_bi (BOB member since 2013-02-13)

10

Copy and paste was available in 5.n
Another useful feature removed from BO

mikca :australia: (BOB member since 2005-12-16)

11

Supposedly with Webi 4 one should be able to copy a table for example to another Webi Document and the underlying query should automatically get copied as well. But… so far I have not seen it work ;(

Andreas :de: (BOB member since 2002-06-20)

12

We should have a sticky topic for this - those useful features from prior versions which were removed in the latest greatest version.

Nick Daniels :uk: (BOB member since 2002-08-15)

13

Hi Andreas

I tried it BI4.0 SP5. and it actually worked!!

  • I created one webi doc, and saved it in My Favorites.
  • Then i created another webi doc, and saved it in My Favorites.
  • Then i edited the first webidoc, and copied (CTRLC+C) the table.
  • Then i edited the second webidoc, and did a paste. After a few seconds, i got a the table as in the first webidoc, and i got a new Dataprovider.

I only had one dimobject, and one measure, without queryfilters. Dont know if this will work when having a more complex query…

/Björn

Bjorn :sweden: (BOB member since 2006-02-10)

14

Hi Folks !

I tried as well on BI4, and it works only with the Rich Client and for the basic table. And sometimes, it’s not very reliable (error message, multiple data provider created…), but it’s better than nothing :wink:

cheers

kenny :fr: (BOB member since 2007-01-02)

15

Hi Kenny,
Thanks for detailing this feature as Rich Client funtionality only…
It’s frustrating that the Formatting rules are only editable or able to be created from Rich Client also :roll_eyes:

Joe Szabo :us: (BOB member since 2002-08-19)

16

Hi Joe.
Are you referring to conditional formatting, formerly known as alerters? Those can be created & edited in Webi web version as well!

Andreas :de: (BOB member since 2002-06-20)

17

Hi Andreas,
Yes, our current version (14.0.5) of BI40 does not support conditional formatting in the web, just in the Rich Client. Which version are you seeing the functionality in :?:

As you know this is a basic ‘feature’ that users are most interested in, it will be good to see it back in the Web version :smiley:

Joe Szabo :us: (BOB member since 2002-08-19)

18

I don’t have 4.0 running where I’m at now but perhaps you need to go into the preferences in the bi launchpad and change to the java version in web instead of interactive. I can’t remember the terminology but in 3.1 it’s interactive or advanced for webi editing, or rich client of course (desktop)

erik.stenson :us: (BOB member since 2012-07-30)

19

we tried the same and it works for us as well…it carried the SQL from another report as well.
Use No Universe Option while creating 2nd Report and paste the 1st query table and you will get the table and underlying SQL in the 2nd report…
we are in Business Objects SP5

Thanks

mnarne :uk: (BOB member since 2007-09-17)

20

We have 4.0 SP5. I wanted to share the following related to this:

We got an error when trying the Table copy method to get the Query to another report. So I tried something similar and this worked: I clicked multiple times within the table to make sure all cells were highlighted, did a “Copy”, then went to other report and right-clicked to “Paste” and then “OK”. The data provider showed up just as I wanted to in the other report.

Although the query just had 3 dims in it, it was a Combined Minus query which may be why the simple Table copy didn’t work.

highew :us: (BOB member since 2011-01-13)