Need help on Join related issue in BO on HANA

[Former Member]

We have the IDT Universe structure as shown in diagram1. We have set Left Outer Join enabled, so all the Account Nos in HANA View will be retrieved. Please refer diagram 2 for the sample data from each table.

We have to display the Amount for each Flag Type by excluding other Some other Flag type and including nulls for flag type, as per below conditions.

While calculating Flag X amount we have to exclude Flag Y Account Nos and include null Flag Types

While calculating Flag Y amount we have to exclude Flag Z Account Nos and include null Flag Types

While calculating Flag Z amount we have to exclude Flag X Account Nos and include null Flag Types

Say for example we have tried to create measure Account type X Amount by excluding Flag type at Universe level, Account type X Amount = SUM(HANA View. Amount) Where Custom Table. Flag Type < > ‘Y’ AND Custom Table. Flag IS Null.

Also we have tried to create the same measure by including Flag type, Account type X Amount = SUM(HANA View. Amount) Where Custom Table. Flag Type IN (‘X’,’Z’) AND Custom Table. Flag Type IS Null.

Above formulas is not working, filter condition is only working when we have Account Nos in both the tables.

From above example Amounts for 1008 & 1009 Accounts are not shown, as they are not maintained in Custom table. Please let me know if we have a solution for this issue1.jpg2.jpg

[amitrathi239]

have you tried first creating HANA View. Amount as Amount dimension object and then later use this dimension object in the below object.

= SUM(HANA View. Amount) Where Custom Table. Flag Type < > ‘Y’ AND Custom Table. Flag IS Null.