Skip to Content
0

how to create a web intelligence report when transaction data is missing

Nov 17, 2016 at 05:34 PM

41

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Nov 17, 2016 at 06:50 PM
0

Please share the IDT DF joins screenhsot.

Also what is the join type coming in the webi->View scripts?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Nov 17, 2016 at 07:00 PM
0

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)

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 30, 2016 at 08:38 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded