Variable and Exit

[Former Member]

Hi all,

I have this problem: I need to create a variable, so I can filter values in a query. This variable needs to find a value in an infocube. The value i'm looking for is the same for every record in the infocube, it is an ID for the data load. The infocube holds only one dataload (the last one), because every time it loads something, it deletes the previous one.

I think I shouls use an exit to find this ID, but I don't know how to build one. Then I should create a variable that uses this exit, but I don't know how to do that.

Thanks in advance,

mauricio.

[Former Member · Accepted solution]

Hi Mauricio,

See the documents below,

1. <b>User Exits in SAP BW (ppt)</b>

https://websmp104.sap-ag.de/~sapidb/011000358700005475091999

2. <b>User Exits Examples (doc)</b>

https://websmp104.sap-ag.de/~sapidb/011000358700005475101999

Hope it Helps

Srini

[Former Member]

hi,

go to WWW.SERVICE.SAP.COM/BI and look for HOW TO DERIVE A VARIBALE VALUE OUT OF ANTOTHER ...

Here is an exampe attached.

You need to run the exit at Step 2 i suppose.

GET the SID of the request ID out of /BIC/D<CUBENAME>P -Table out of the first entry where the value is not inititial nad fill it into the vaiable with I and EQ.

Presupposed you can create var's on 0requid .....

hth

cheers

sven

[Former Member]

Mauricio,

Try for docs from WWW.SERVICE.SAP.COM/BI under BI Infoindex-Exits.

-Doodle