I have used Dynamic Recipient for report bursting in a Publication which is working fine, now I want to use combination of RecipientID, User full name and Email from dynamic recipient source as report instance name.
I know that there are placeholders available for User full name and Email but there is no placeholder for Recipient ID available in the list.
Is there any workaround to use Recipient id in the instance name or any hidden placeholder available for the same?
Dynamic recipients are used in Publication if you want to burst report for the external users that are not part of BO enterprise.
To accomplish this, first you need to create a Dynamic Recipient Source document (a WebI or DeskI or Crystal report) which contains the information about the recipients and then define it as a Dynamic Recipient source in Publication.
The common fields in this include:
Recipient ID (Mandatory identifier field)
Full Name (User Name)
Email (Email ID of user)
Apart from this you can include some more fields in this document which can be used for personalization of data by mapping values of these fields to different objects used in the report, this is done in “Personalization” area of Publication -> Filter -> mapping Report fields with Dynamic Recipient fields.
For more information you can also refer to Publisher guide.
Environment: Business Objects XI 3.1, Oracle Database, Desktop Intelligence Reports.
In my deski report I have column called ID(State ID), that column has like 200-250 list of values and this varies every month, may increase or decrease.
I have to schedule this report(like for a period of one year and should run every month-end) and it should generate all separate .xls reports for all the ID lov’s , i,e it should generate like all 200-250 reports at a time and send it to a file system(Destination).
And these IDs are not users in BO and there are no Profiles created in BO.
As you told there is no column for Email id or Full name, in this case how should i proceed.
You can use State ID as Recipient ID in Dynamic recipient source document, Full name and Email are not mandatory fields, still you can use same object as Full name also as per my understanding.
Hi soni ,
Iam using publishing to distribute reports to dynamic reciepients for the first time. Iam getting the following error
server error. [[CrystalEnterprise.Smtp] ([1]/[3])]: [Error initializing SMTP server. Return code: [SMTP 501 - Syntax error in parameters or arguments.]. Reason: [2y1.xyz.com:25].] (FBE60013)
when scheduling a report for email is working fine but when trying to use publication for emails enterprise or dynamic recepients Iam getting the above error.
If we are using for the first do we need to configure any servers. if so can you please explain how can we configure
If you want to deliver Publication Schedule through Email then you must configure Email destination in the Destination properties of Publication Job Server since this is the server which is responsible for scheduling of publications.
As you mentioned:
Since report scheduling to Email is working fine, you can use existing Email settings (Domain, Host, Port, Authentication etc.) of report job servers (Adaptive Job Servers, Desktop Intelligence Job Server, Crystal reports job servers) for which scheduling is working fine to configure same settings in Publication Job server also and see if it works.
Amongst other things, guess we lost the original query:
" Is there any workaround to use Recipient id in the instance name or any hidden placeholder available for the same?"
We have a request for report bursting to enterprise users for a bunch of Webi Reports based on ID. How can this be accomplished and what the parameters that have to be set in Profile values , Publication ,etc
Think I am providing the reply to the initial question asked quite late. But hope this will help other people browsing the forum for help in the future for the same question
Recipient Identifier - %SI_OWNER%
Full Name - %SI_USERFULLNAME%
Email - %SI_EMAIL_ADDRESS%
%SI_OWNER% adds the actual BO user who set up the publication, but i have a similar requirement where i need to use the Identifier field mapped in the Dynamic Recipient list to be used in the name of the output file being delivered.
Say i have 2 fields in the Dynamic Recipient list (from another WebI Report with 2 fields as shown below, Say Key report)
Key || Value
K1 || V1
K2 || V2
And i want the output of my publication as 2 pdfs; K1.pdf and K2.pdf respectively. Where Key field is mapped as my Recipient ID in the publication with say some other source report SRC report.
Are the output files being generated with the correct content, and only the name is wrong?
We are using Publications with exactly this configuration (%SI_OWNER% is used to put the Recipient Identifier into the generated file name), so it does work.
Files are generated correctly, but when i select SI_OWNER it gives my User name say “jpram” wherein i expect the Key value K1 and K2.
I tested this for the output format .pdf and WebI both results with jpram as the name of the output file.
Here is what i have done.
Report - Src Report with (key field as one of the column)
Publication with the following setup
Publication Title: Test Publication
Location: \jpram
Description:
Subscription Status: Not Subscribed
Documents:
Src Report
Recipients:
0 Enterprise recipient(s) included.
0 Enterprise recipient(s) excluded.
Dynamic recipients are used.
Recurrence:
Every 1 day(s) starting on Dec 9, 2013 and ending on Dec 10, 2014
Delivery Rules:
Deliver individual document when condition is met
Personalization:
Title Variable Name Dynamic Recipient Mapping
Src Report Key - Query1 Key
Distribution:
Default Enterprise Location
Business Objects Inbox
Formats:
Web Intelligence
Dynamic Recipients Configuration
Choose the source for the dynamic recipients - WebI/DeskI
Key Report (selected)
Map Fields from source document to those used send to the publication
Recipient Identifier(required) - Key
Full Name - BLANK
Email - BLANK
I’ve never tried it with Dynamic Recipients and destination of “BO Inbox”. And honestly I wouldn’t know what to expect for a result – since there’s no Enterprise user assigned, who gets the document?
As a test, try using File System or Email as a destination and see if it works as expected.
I’m using this because i have to split the report output for 1000 keys and i need to attach a shared outlook mail box address for these 1000 pdfs (if successful i will ZIP them before i send). But currently I’m just testing this split with 2 keys and delivering them to my Inbox.
Note: that these 1000 keys are not Enterprise users
(BOB member since 2008-09-15)
(BOB member since 2008-09-15)
(BOB member since 2007-03-23)
(BOB member since 2012-03-25)
(BOB member since 2010-12-10)
(BOB member since 2010-12-10)