All, I am new to OBI and kind of stuck on one issue. Due to report requirement I have a self join of a Dim table with it's alias and it's a left outer join. A measure is derived using the column from Left outer joined table. When I create a report with this measure and the attribute column from left outer joined table, I get correct results. But as soon as I remove the attribute column form the report, the measure is showing wrong values, basically it's not evaluating the case condition in its logic where I have used the attribute column. Please check screenshots below. The 'Result1' picture shows measures values by acrual action type, but i do not need accrual action type column in the report so I was expecting I would get total sum for Toyota here but that's not happening. When I hid the column from view, I still get multiple rows for Toyota, please check 'Results3' picture, ignore the values though, the dummy data keeps changing.
Any hint would be highly appreciated.
Result1:
Result2:
Results3:
