Prompt Optional Field
Normally On the BO Webi Prompt If an optional field (e.g. Year) is left blank the report will display everything for that field (e.g. every Year). If a value for the optional field is entered (e.g. with the Year) the report will display data just for that field (e.g. the information about that Year only)
Now unusally The requirement is to capture the blank value in the prompt say as Current Year in BO Webi Only
Here i donot want to use userresponse() as the value in Year optional prompt is blank where an BW exit code return at the BW side to set at the background as current Year in Year optional Prompt when left blank by the user.
To display the blank value of the prompt in BO Webi i was given an KF with Current Year restriction on it from the BW side.
In BO to get the Current Year details i created an empty blank cell with Year detail key object and applied an filter on the cell as KF is not Null.
On scheduling i need to get the Current year details when user left blank on the year optional prompt. After running 4500 sec the report throws CORBA Error. For a fix i tried removed the KF filter from the blank empty cell and tried scheduling where i was succesfually saw the data run for 2200 secs.I know that iam wrong with the KF setting on the empty cell of not null filter application on Year detial object.
Experts can anyone help me with an logic/formula which i need to get this only done from BO Webi side.