Precalculation - variable/variant setting

[Former Member]

Hi Gurus

I got a requirement to pre-calculate and publish a web template in a portal. This web template is having 3 query views (all these query views are on the top of same query). I want to schedule it every day with selection screen value (creation date) as yester day's date and for another template with last week.

Is there any way to change the value of my variant using some program so that I will not have to schedule it every day by changing the selection screen value? I checked the table RSRVARIANT but I can not see the variant created in the WAD.

We are in BI 7

Thanks in advance

nisha

[Former Member]

Hi Nisha,

Check this link,

I know it is for workbooks and yours is a template, but you can check topic 4 Input options in this document.

http://www.scribd.com/doc/6219255/How-To-Troubleshoot-Information-Broadcasting-BEx-Workbooks

For BI7, variants are generally stored in html format in RSRPARAMETRIZA in contents field.

However, there is an easier way.

You can create customer exit variable for the query with i_step = 1 to populate the variables default value as yesterdays date.

RSRVARIANT is for BW 3.x , I think.

Regards,

Sunmit.

[Former Member]

Nisha,

I am using an ABAP program to create/modify entries in the table TVARC, and then using the selection variable type T to pick up the values.

I hope this helps.

Regards,

Chris Pruitt