Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 11, 2014 at 09:27 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2014 at 09:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded