set a range for a variable Bex

[Former Member]

Guys,

I am just trying to set a range for a variable below is a example.

Varialbe :

Technical Name          Value

ZCSO_INDUS       

101_MNTH                     01/2013 - 05/2013

ZSO_SOD         

ZSO_SHP                      80159371

Code :

    Set RANGE1 = Sheets("sheet1").Range("A1:B4")

    Run "BEXanalyzer.XLA!SAPBEXsetVariables", RANGE1

    Run "BEXanalyzer.XLA!SAPBEXrefresh", True, RANGE1

It doesn't work, someone give me an exaple to give a variable range.

[anshu_lilhori]

HI,

You can make in query designer variable of type range.

While creating a variable on any characteristic ---In details tab you can choose interval.

Hope this is what you are looking for.

Regards,

AL

[former_member182470]

Hi,

If you just want to create a range variable, you can simply create Range variables in query designer under the characteristic.

http://help.sap.com/saphelp_scm700_ehp02/helpdata/en/f1/0a56a7e09411d2acb90000e829fbfe/content.htm

Regards,

Suman

[former_member213043]

Hi

If you want to restrict the list of values in the F4 for a variable, there is a BADi developped by SAP for that.

Have a look at that blog

http://scn.sap.com/people/rajeev.kumar23/blog/2011/08/09/bw-restricting-the-value-help-in-the-variab...

PY