Runtime-error 1004

[Former Member]

Hi ,

I get " runtime-error 1004" when I try to use SAPBEXsetfiltervalue. Has any come across this error. plz advise.

Kartheek

[Former Member]

Hi,

Are you using any Macro (VBA code) to format the output....?

Eswari.

[Former Member]

No , just passing the filters.

[Former Member]

Hi Eswari,

yes we use the VBA API from SAP to set filtervalues and so on.

Could it be that there is an frontend installation problem? But Sapbex-test is green.

Markus

[Former Member]

are you on latest FEP - 11??

if not try downloading the same from

http://service.sap.com/swdc

Download>Support Packages and Patches>Entry by Application component-->Support Packages and Patches" ->SAP Frontend Components">SAP GUI FOR WINDOWS"-->SAP GUI FOR WINDOWS 6.40

for NW2004s Bex

Bw700SP11_1100-10001615.exe

for 3.x Bex

bw350_11-10001615.exe

Hope it Helps

Chetan

@CP..

[Former Member]

Hi ,

I am on latest SP 11.

Thanks,

Kartheek

[Former Member]

Error is quite generic,did you try executing trace from Bex?whts the error detailed messages ...

Hope it Helps

Chetan

@CP..

[Former Member]

Hi Chetan,

can u detail me the exact steps to pass filters using sapbexsetfiltervalue, so that I can make sure I am not doing wrong.

Thanks,

Kartheek

[Former Member]

You might want to check this

http://www.bwexpertonline.com/downloads/boeke04.doc

Hope it Helps

Chetan

@CP..

[Former Member]

I want the corresponding code for NW2004s. Any ideas pls.

thanks,

Kartheek

null

[Former Member]

If you look at the functional API, you'll see the function input:

Public Function SAPBEXsetFilterValue(intValue As String, Optional hierValue As String, Optional atCell As Range) As Integer

extErrorBegin ("3.x API SAPBEXsetFilterValue called")

If atCell Is Nothing Then Set atCell = Application.ActiveCell

SAPBEXsetFilterValue = pAddin.SAPBEXsetFilterValue(ActiveWorkbook.Name, intValue, hierValue, atCell)

extErrorEnd

End Function

So your parameters are pretty dynamic. If you just call the function

SAPBEXsetFilterValue('1000'), this will filter the current cell that you're on to a particular value '1000'. If you want to pass the particular cell for the characteristic filter to take place, then you should pass that in as well.

[Former Member]

Hi Prakash,

Thanks for the reply. I have tried the way u have mentioned. But, I get runtime error 91. Please advise.

Thanks,

Kartheek

[Former Member]

Hi Kartheek,

i get the same error in the BEx Analyzer Workbook.

Do you have already a solution for this problem?

I installed the newest patches on backend and frontend and it doesn't works.

Regards,

Markus