on 09-11-2014 10:01 AM
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.