Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to implement incremental load from SAP BI data and when I use where clause it giving an error OpenStream failed. Any clue what I am doing wrong.
Load
MATERIAL
as [MATERIAL],
[MATERIAL]
AS [TMATERIAL_PMATERIAL_KEY],
LANGU ;
Select * From /BI0/TMATERIAL WHERE LANGU='E';
Don't you need a "Sql" in front of your select clause? i.e.
Load
as [LBU];
SQL
LANGU = 'E';
where
[TXTSH] as [LBU Desc],[/BIC/ZLBU]
Just put a bracket around /BI0/TMATERIAL -
Select * From [/BI0/TMATERIAL] WHERE LANGU='E';
Don't you need a "Sql" in front of your select clause? i.e.
Load
as [LBU];
SQL
LANGU = 'E';
where
[TXTSH] as [LBU Desc],[/BIC/ZLBU]
Yes for sure. Thanks.
Dear srinivas,
Can you guide me . How to extract Increamental data from SAP BW ?.
if There is no time stamp available in Cube , DSO.
Pls reply me as soon as possible.
Regards;
Sunil Jain