This document will be covering below areas in WEBI publishing:
A. Publishing Webi reports using dynamic recipient for 2 scenarios
B. Issues faced during Webi publication using dynamic recipient and correction steps
A. Publishing BO Webi reports via dynamic recipient
Publishing reports through dynamic recipient solves two purposes:
Step by step implementation of above scenarios using dynamic recipient:
Scenario 1:
The dynamic recipient report must contain below fields:
Country Key | Country Name | User Name | |
Ind | India | Amit | |
Ind | India | Ravi | |
Pak | Pakistan | Amit |
e. The main report which needs to be scheduled should have Country Key in report output. Based on this only splitting of report for different users will take place.
Document id | Country Key | State | Sales |
1 | Ind | Uttar Pradesh | 50 |
2 | Ind | Delhi | 100 |
3 | Pak | Karachi | 200 |
4 | Pak | Islamabad | 600 |
f. Create a publisher on the parent report. Right click --> New --> Publication
g. In general properties give the description of the publisher
h. Go to source documents and select the report which needs to be published to different users
j. Select the recipient Webi report created in step a to step e.
k. Select the query and uncheck Use Entire List. Remember after doing uncheck data should appear below. This has to display else we will end up throwing errors. Select which call countries you want to split data else check Use Entire list for all countries.
Save.
l. Go to Personalization
Here mapping between fields of source document and dynamic recipient list report is done.
m. Go to Format. Select the output format.
n. Go to Destinations.
As shown in above screen shot:
The file which user will receive will be determined by Use Specific Name. Here we have mentioned Report %SI_OWNER%.%EXT%
The user will receive report as Report Ind.ext, Report Pak.ext
o. Click on Ok and we can see publisher “Country sales Publisher”. Right click --> Schedule
p. Check options Destinations and Formats , it should have values same as given in publisher. Click on schedule.
Scenario 2: Scenario 2 can be achieved by modifying above steps
q. In step k, only mapping for Recipient Identifier is required, remove mappings for Name and Email
r. Step l and Step m will be same
s. In Step n, destinations need to be modified. Choose FTP server and provide the details
The reports will get saved in Publication folder of FTP server. There will be different copies of the report based on country values.
The reports will be saved on FTP server as Report Ind.ext, Report Pak.ext
t. Step o and Step p will be same. Only in destinations FTP Server must appear.
B. Errors occurred in Publication and rectification:
This may be because of below reasons:
If this is empty then we will get error after scheduling. We can see that in above screenshot there are 1 to 7 pages but there is no data.
Solution: Here we opened the Dynamic Recipient report in info view and refreshed the query and saved it. Then go to edit query and uncheck if it is refresh on open. Click on save --> close the prompt for edit query --> again save the report.
It may happen that still data might not appear. In such cases delete the publisher and re-create it. After following above steps my issue got resolved.
This error is received when we are trying to publish and save report on shared folder which is Windows machine. Since Bobj server is UNIX server so issue occurs because of incompatibility between two systems. Below needs to be followed:
This error occurs because of destinations. For example if one wants to schedule a report with destination as “EMAIL” and gets above error, then this because of adaptive server.
Solution: This is because of setting in Personalization. We need to check whether mappings are properly done.
Solution: This error occurs if there are more than 1 million rows or 10 million cells in report(SAP Note -1459759). Here, we need to reduce the number of records. Another way is to schedule the publisher by un-checking “Use Entire List” in dynamic recipient and putting selection. When this gets successful then reschedule the publisher with other selections.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |