Merging Reports

building reports desktopintelligence
1

X-cc: Randy Griffith Randy.Griffith@ForemostFarms.com

Has anyone figured out an easy way to merge the structure of a report tab
from 1 document to a different document. We have tried multiple methods,
none of them pretty, and assume there must be an easier way.

Thanks in advance.

Mike Andersen
Data Warehouse Administrator
Foremost Farms USA, Cooperative
(608) 355-8617
Mike.Andersen@ForemostFarms.com

Listserv Archives (BOB member since 2002-06-25)

2

Mike,

You will find a script on the Business Objects technical support site to
copy a dataprovider. Maybe you’ll have to adapt it to copy a dataprovider
from one document to another.
So first copy the dataprovider from the source document to the target
document. Go in the source document and save the report tab as a template.
Apply this template to a tab in the target document.

I have never tried this but it should work.

Christophe

Listserv Archives (BOB member since 2002-06-25)

3

Hi. I have 2 questions.

  1. Is there a way to merge 2 reports? Eg. Merge them by patient id. 2) Can I create a BO universe from excel spreadsheet data? My guess is not. Am I right?

Sylvia

Listserv Archives (BOB member since 2002-06-25)

4

REPLY>
Sylvia,

  1. You can link two queries/reports together if the have common fields eg. patient id.

From my archives here is Dave Rathbun’s take on how to do this:

First you have to link any common dimension objects. This is done so BusObj knows how to get the two data sets together, and is done on the Data Manager window. (Select View + Data to get there.)

Now that you have done that, here are the “rules” 1. You can use any linked dimension
2. You can use any Detail object associated with a linked dimension 3. You can use any Measure object
4. You can use any unlinked dimension from one query only, but you probably
don’t want to. See rule #5
5. The measure value results will only be valid for combinations of linked (or shared) dimensions. In other words, suppose you have Dimension A1, B1, and C1 from data provider 1. And then you have A2, B2, C2, and D2 from data provider 2. You link A, B, and C together. Then you have M1 from data provider one, and M2 from data provider 2. If you use dimension D2 in a block, then M1 will show repeating values. The measures M1 and M2 will only be appropriate with various combinations of A, B, or C, since they are the shared dimension objects.
6. Combinations of unlinked dimension objects are NOT allowed.

  1. Do you know that you can bring excel data directly into a query without a universe ?

Michele
michele.pinti@standardregister.com

QUESTION>

Hi. I have 2 questions.

  1. Is there a way to merge 2 reports? Eg. Merge them by patient id. 2) Can I create a BO universe from excel spreadsheet data? My guess is not. Am I right?

Sylvia

Listserv Archives (BOB member since 2002-06-25)

5

When linking data providers, which columns are allowed in the same block? What would make two columns incompatible to be put together?

Thanks,
Sylvia

Listserv Archives (BOB member since 2002-06-25)

6

All the dimensions in the link data providers should link. If you can’t link all the dimension, try to make them details.

-Durgesh

Listserv Archives (BOB member since 2002-06-25)

7

If two dimensions are of different types, for example production date is a date field like 1/1/2001 but ship date is a character field 01/10/01, they will link but will not be successfully joined in the report.

Ken

Listserv Archives (BOB member since 2002-06-25)

8

Can I merge two diffrent document with their all graphic information like tables / graphs, etc. into a new document that to with the help of BO SDK.

novneet (BOB member since 2003-09-09)