Hi,
I have to implement the below DB logic in OBIEE.
DB Side:
SUBSTR(Invoice_Description,INSTR(Invoice_Description,'W',1,1)+1,( INSTR(Invoice_Description,'W',1,2)-INSTR(Invoice_Description,'W',1,1) )-1))
Then I divided logic into two parts in OBIEE and checked and displayed the data same as DB.
1st part:
DB Side:
SUBS-TR(Invoice_Description,INSTR(Invoice_Description,'W',1,1)+1
OBIEE:
SUBSTRING ("- Nx_GLG0_Je_SLA_AP_Inv_Dist (General Ledger Views)"."Invoice Description" FROM LOCATE('W',"- Nx_GLG0_Je_SLA_AP_Inv_Dist (General Ledger Views)"."Invoice Description",1) +1) then it displayed the same result as DB.
2nd Part:
DB : ( INSTR(Invoice_Description,'W',1,2)-INSTR(Invoice_Description,'W',1,1) )-1
OBIEE:
LOCATE('W',"- Nx_GLG0_Je_SLA_AP_Inv_Dist (General Ledger Views)"."Invoice Description",2)-LOCATE('W',"- Nx_GLG0_Je_SLA_AP_Inv_Dist (General Ledger Views)"."Invoice Description",1)-1.
When I implemented total logic in OBIEE I am getting syntax error..
SUBSTRING ("- Nx_GLG0_Je_SLA_AP_Inv_Dist (General Ledger Views)"."Invoice Description" FROM LOCATE('W',"- Nx_GLG0_Je_SLA_AP_Inv_Dist (General Ledger Views)"."Invoice Description",1) +1,
LOCATE('W',"- Nx_GLG0_Je_SLA_AP_Inv_Dist (General Ledger Views)"."Invoice Description",2)-LOCATE('W',"- Nx_GLG0_Je_SLA_AP_Inv_Dist (General Ledger Views)"."Invoice Description",1)-1).
Can you please suggest how to resolve this...
Thanks,
Jagadish.