Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Incremental load from SAP BI data

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';





Tags (3)
1 Solution

Accepted Solutions
Not applicable

Incremental load from SAP BI data

Don't you need a "Sql" in front of your select clause? i.e.
















Load




as [LBU];

SQL




LANGU = 'E';


Select TXTSH LANGU /BIC/ZLBU from /BIC/TZLBU

where

[TXTSH] as [LBU Desc],

[/BIC/ZLBU]





4 Replies
disqr_rm
Valued Contributor III

Incremental load from SAP BI data

Just put a bracket around /BI0/TMATERIAL -

Select * From [/BI0/TMATERIAL] WHERE LANGU='E';

Not applicable

Incremental load from SAP BI data

Don't you need a "Sql" in front of your select clause? i.e.
















Load




as [LBU];

SQL




LANGU = 'E';


Select TXTSH LANGU /BIC/ZLBU from /BIC/TZLBU

where

[TXTSH] as [LBU Desc],

[/BIC/ZLBU]





disqr_rm
Valued Contributor III

Incremental load from SAP BI data

Yes for sure. Thanks.

suniljain
Honored Contributor

Incremental load from SAP BI data

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

Community Browser