Bex Workbook variables

[Former Member]

Hi All,

We have a couple of variables included in our report:

Fiscal Year

Posting period

We are populating these fields using a customer exit that is based on the current system date and this works well for queries.

The problem is that when we use the workbook the customer exit variable values are not flowing through to the workbooks variable screens as the workbooks were already saved with a different Fiscal Year and Posting period selection and this now seems to be overwriting the customer exit variables.

Is it possible for the customer exit value to override the saved workbook value for the Fiscal year and Posting Period without making the variables optional and saving them as blank in the workbook?

Thanks

[Former Member]

Hai guys,

Start---BEx Analyzer--

---

Create new work book.While executing the work book,it is asking me to enter variable values.Once the variables are given and when start executing it, i am getting the ouput correctly and when i broadcast the same through email,in work precalculation tab, again it is asking me to enter variable values.I have done that and executed. But I am not able to receive any email.Infact,after taking 3 mnts it showing Timed out error.Kindly,suggest me with a solution to this. Where should I exactly enter variables?

Could u please,give me some solution.

Thanks,

Mohan Chand Reddy A

[anshu_lilhori]

Hi,

Please check out this thread it might be informative for you.

Regards,

AL

[Former Member]

Hi Raj,

I have tried this but the workbook insists on using the saved values still instead of the customer exit vales.

Any thoughts?

Regards,

[koleti_madhusudan]

Hi,

follow these steps

1. open workbook

2. Go to work book properties

3. select check box 'Return on Global definition refresh'

4. now , refresh workbook

hope it will help

Thanks

Madhu

[rajkumar_kandula]

Hi

Try this.

Goto WB Designer Mode.

Here in the Global Settings make the below check boxes enable.

1. In General Tab --> Refresh WB on Open

2. In Variables Tab --> Process Variables on Refresh.

Hope this helps you. Thanks.

Regards,

Raj

[Former Member]

Hi

it worked for us after we have removed the flag in point 2.

1. In General Tab --> Refresh WB on Open (enable)

2. In Variables Tab --> Process Variables on Refresh (disable)

Regards

[Former Member]

Thanks for your response.

Can you let me know your end to end default settings on the workbook right through to the Broadcast settings?

Are your variables mandatory?