BusinessObjects Board

Linking Data Providers

building reports desktopintelligence
#1

Hi - I am trying to link an Excel Spreadsheet to a Universe and bringing in the following from each side and linking Account# from both side

Universe
Account #
Account Location
% calculation

Excel
Account#
%

when use the %'s from the Excel spreadsheet for calculation, I only get one % for each account loaction and account with multiple locations will show zero.

Is there a way to show the same %'s for each location without having to add multiple location %'s on the Excel Spreadsheet?

Thanks for any help.

BOaddictNYC (BOB member since 2003-07-11)

#2

Does one account number have multiple locations? This presentation should help (it’s old but the functionality hasn’t changed much): Solving the Mystery of Data Provider Synchronization

One last question, is the % a measure or a detail?

SteveBickerton :canada: (BOB member since 2002-08-15)