on 11-17-2016 5:34 PM - last edited on 02-04-2024 6:43 AM by postmig_api_4
Hi All,
I have a requirement where my master data is a fixed list, but the transaction could be different (and it is different). Customer wants a report where the columns are consistent whether the company has transaction or not. The transaction data comes form a hana model and I built a master data custom table (it is a requirement). I did the right outer join with the master data table ( Transaction left element and Master Right element) and still not getting the right data.
Also I tried to create the master data as a separate calc view and did an outer join at the universe Data Foundation and still not working right...
Any suggestion?
Thanks,
Arthur.
Thank you for your replies. I have fixed the issue by enhancing one of the dimension in the hana model and got the result as expected.
- Arthur.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Another approach would be to keep inner joins in the universe, but create two separate queries in the WebI document - one for master data and one for transaction data, then merge master data dimensions in WebI ( this would be an equivalent of full outer join)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please share the IDT DF joins screenhsot.
Also what is the join type coming in the webi->View scripts?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.