Filtering a Query

[Former Member]

Hi All,

I have this problem. I want to create a Query, with a filter. This filter should find the last data load, and use only this data.

Does anybody knows how to do this?

thanks for the help,

Mauricio

[Former Member · Accepted solution]

Doodle,

thanks for the help. I activated it and it's working.

There is a popup message that says no aggregated will be used... Is there other way to use only the last data load, and not getting this message?

thanks again,

_Mauricio

[Former Member · Accepted solution]

Hi Mauricio,

You will get that warning even if you dont have aggregates on the cube.You could ignore the warning message.

Hope this helps.

-Doodle

[Former Member]

Hi Doodle,

I checked, and there is no variable under 0REQID,

Should I activate it, first?

Where?

thanks for the help,

Mauricio

[Former Member]

Hi Mauricio,

You need to activate the sap exit variables from Business content

-doodle

[Former Member]

Hi Mauricio,

Under the Datapackage dimension you will find "0requid" infoobject.It has a SAP Exit variable "0LSTRQID" - Last Request Loaded.

Drag and drop this infoobject and select that particular variable.

Hope this helps

-Doodle