cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to restrict two infoproviders of different characterisitcs by creating single variables

Former Member
0 Kudos

Hi Experts,

I am new to BEx. I am facing some issues in variable creation. I have two infoproviders(composite provider in my case). One infoprovider is loaded with ECC data and another infoprovider is loaded with transaction data. In reporting layer, our requirement is to show 3 dashboards all together by using tabs and filter panel should be same for all the 3 dashboards.

For example, one of the filter panel variable is "date range", our requirement is to use one "date range" variable to restrict all 3 dashboards. Since the characteristics of these two infoproviders are different like 0calday for transaction data and 0ship_date for ECC date. So I couldnt create a single variable for these two infoproviders(since the characteristics are different).

But I want to know, is there any other way to meet our requirement in BEx.

Thanks in Advance.

Regards

Saranya S

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member194898
Active Contributor
0 Kudos

Hi,

You can combine data from two infoproviders in an infoset.

Inner join is default operation in infosets, left outer join is also possible.

Regards, Leszek,

Former Member
0 Kudos

Hi Saranya,

i think you need to post this question in Business objects forum.

but since you are usign composite provider, you can map the0calday with 0ship_date right?

so that it will be one object for filters working on this composite provider?


Regards,
Sakthi