Linking Data Providers

building reports desktopintelligence
1

I have a report which has multiple calculated fields. Each of these fields need to be calculated based on a different data ranges.
I have a universe created for the main data which includes date fields(Start Date, Status Date). I have created an additional data provider(Excel sheet) which includes data ranges(Year, WeekNo, FromDate, ToDate).
The problem is that when I try create the necessary calculations between Start Date in the universe and FromDate(Excel), I get a #COMPUTATION error.

toscajo (BOB member since 2002-09-04)

2

Hi,

Have you linked the two data providers.
Firstly, I feel u need to link the two data providers withe the right objects.
In your case it can be Start date (DP1) to FromDate(DP2).

Then you can create filter conditions to restrict data from start date to from date as required.

This can be table level or you can add them to ur data providers as prompt conditions.

Regards,
:wave:

zullehuma :india: (BOB member since 2008-08-04)

3

[Moderator Note: Moved to BO Desktop - Jansi]

Jansi :india: (BOB member since 2008-05-12)