Setting BEx variables

[Former Member]

Hi !

I want to create several worksheets in BEx each with a different query. I want to run these different queries with the same variables, one of which I want to calculate automatically (based on the date the report is run).

Is there a way I can automatically set the variables in the queries either directly from values in excel cells or via visual basic ?

Thanks in advance,

Richard

[former_member181964 · Accepted solution]

Hi,

You create different Customet Exit variables and then pass the values for that variables using CMOD.Else

you can directly restrict the values in reports.

Thanks

Reddy

[Former Member · Accepted solution]

Reddy,

Many thanks for the advice - I'm new to BEx so will now research customer exits/CMOD !

Kind regards,

Richard