Hello,
I can't see a data in one column although I can see data in database,
here is my scenrio:
I'm creating analysis like this:
As you can see I'm able to see data only in 2 first columns but not in last one.
So I'm checking the query in logs and it looks like this:
from
DIM_ACCRUALPARTNER T2632,
DIM_REDEMPTIONPARTNER T3052,
FCT_TRANSACTIONSRELATIONS T4257 left outer join FCT_TRN_ACCRUALS T4318 On T4257.TDR_SRCTRANRESGID = T4318.TRA_TRANSACTIONGID,
FCT_TRN_REDEMPTIONS T8838
where ( T2632.APA_GID = T4318.TRA_ACCRUALPARTNERGID and T3052.RPA_GID = T8838.TRR_REDEMPTIONPARTNERGID and T4257.TDR_DESTTRANRESGID = T8838.TRR_TRANSACTIONGID ) ),
Alright so I'm executing very similar query in my database:
select apa_businessname, rpa_businessname, trr_m_quantityofpoints from
DIM_ACCRUALPARTNER ,
DIM_REDEMPTIONPARTNER ,
FCT_TRANSACTIONSRELATIONS left outer join FCT_TRN_ACCRUALS On TDR_SRCTRANRESGID = TRA_TRANSACTIONGID,
FCT_TRN_REDEMPTIONS
where ( APA_GID = TRA_ACCRUALPARTNERGID and RPA_GID = TRR_REDEMPTIONPARTNERGID and TDR_DESTTRANRESGID = TRR_TRANSACTIONGID )
And I can see data in all three columns.
So could you help me solve this issue, why I don't see the same data in OBI?
