BusinessObjects Board

Displaying a report using an excel data provider & unive

building reports desktopintelligence
#1

I need help bringing in data from my excel spreadsheet. I’m very new to BO and I’m trying for the 1st time to create a report usind data from both my local universe and an excel spreadsheet.

I’ve brought the data in & linked the 2 data providers by a single variable (Company ID), my problem is bringing over the other variables from the excel spreadsheet. The only variable that I can drag over to the report is the one that’s linked. What am I doing wrong? I don’t want 2 separate tables next to each other. I want to combine all of the variables and create one table.

Please help!

:confused:

klpumpkin (BOB member since 2004-04-07)

Getting Duplicate Records when linking data providers.
#2

You can define the dimension objects from excel spreadsheet as detail of CompanyId.

reemagupta (BOB member since 2002-09-18)

#3

Rule for linking data providers : - Only Measures or Detail objects remain compatible desides the linked dimension object.

If you want to display data from both the dp’s, you would either need to define them as Detail object or Measure object.

Hope this helps…

Anjan Roy (BOB member since 2002-07-10)

#4

Take a look at this link: S. Bickerton “Solving the Mystery of Data Provider Synchronization” from the Business Objects user conference 2002 in Miami: http://www.bonymaug.com/reporter.htm or http://www.bonymaug.com/Presentations/synchofdataprov1.zip

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

#5

I’ve tried to change them to details and to measures, when I change them to details, they all get graued out, when I change them to measures, incorrect data comes through, it just repeats the same numbers.

Will there be a problem if there are more Company ID’s in my Universe than there are in the excel spreadsheet?

klpumpkin (BOB member since 2004-04-07)

#6

How about giving us a little more information about what your data looks like.

It sounds like you are only linking on Company ID. So does that mean that each data provider only has one row per Company ID?

If not – how do you expect the multiple lines to “correlate” to each other?

Anita Craig :us: (BOB member since 2002-06-17)

#7

Yes, each data provider only has one row per COID. What I’m trying to do is to analyze our internal revenue picutre vs. external data that I downloaded from a website.

So, I started over from scratch & did the Universe query 1st, then added the excel query & it seems to be working better. I linked by both the COID & the Company name & I made the rest of the variables details of the COID.

Does that sound like the right approach?

klpumpkin (BOB member since 2004-04-07)

#8

Yes. Linked dimension objects are considered “keys” and function essentially like database joins. Additional fields are details or measures (attributes from a database table). As long as each key only has one detail value associated with it (note that the reverse is not required) then you are fine.

Dave Rathbun :us: (BOB member since 2002-06-06)

#9

That totally makes sense! Thanks so much… it’s working now.

klpumpkin (BOB member since 2004-04-07)