Publication in BO 4.0 SP4

Hello,

We had created the Webi reports by connected to Bex queries through BICS connection. User is sending the reports to their customers through publication.

Here the concern is webi report contains the prompt values and every time user has to manual select the prompt values at the time of the publication.

Prompt values are year and quarter and customer requirement is prompt values should dynamically consider the latest year and quarter which is present in the Infocube .So that user is not require to manual select the prompt at the time of publication.

We need the expert suggestion,is there any possible way to fulfill the requirement.

MY BO and BW environment details are mentioned below

BO-4.0 SP4

BW -7.3 SP3

Regards,

Vinay