Publication in BO 4.0 SP4

[Former Member]

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

[former_member185403]

Hi Vinay,

You can implement and use Bex Variable with Processing Type Customer Exit in SAP BEx Query, which always would populate with latest Year/Quarter  as Current Year/Quarter.

The suitable object is 0CALQUARTER which is in format QYYYY.

Actually you should know how frequently and when the data is loaded to the Cube. This would help you decide on the logic "how to design your BEX Query".

Note: There is an option to read the latest data from Cube by calling Func. Module in Customer Exit, but reading from cube is not a good solution from Performance perspective.

Thanks,

Krishnendu Roy.

[Former Member]

Vinay,

I think you can use Master report and segmentation report concept to create publication reports.

1)     master report will have detailed data with year and quarter parameters as prompts

2)     segmentation report or child report will only have year and quarter data

In the publication you will match the master report prompts to child report data columns and in the publication each year and quarter values are passed to master report to create report.

You can burst these reports to users or FTP location based on your requirement

-- Gopal